Spreadsheet: 733388d1621541537-trying-to-find-a-way-to-get-the-previous-answer-from-a-list-of-values-sample_data_v2
Sheet: Sample Data

ID | Address | City | State | Zip | Price | Date | Value | $$ delta | % change in Delta | Percentage | [NAME] | Status | Answer | Date of Answer | Notes
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-01-04 00:00:00 | 558300 |  |  |  |  | Not adjusted/informed |  |  | This example shows a change in the dollar amount for value as well as a >3% change in variance
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-02-05 00:00:00 | 561000 |  |  |  |  | Not adjusted/informed
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-03-16 00:00:00 | 543400 |  |  |  |  | Adjustment made, give me previous answer | 561000 | 2021-02-05 00:00:00
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-04-03 00:00:00 | 545500 |  |  |  |  | Adjustment made in previous month(s)
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-01-04 00:00:00 | 1127000 |  |  |  |  | Not adjusted/informed |  |  | This example shows the value assumed a higher dollar amount and didn't adjust downwards towards the price
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-02-05 00:00:00 | 1147400 |  |  |  |  | Not adjusted/informed
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-03-16 00:00:00 | 1146700 |  |  |  |  | Not adjusted/informed
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-04-03 00:00:00 | 1147200 |  |  |  |  | Not adjusted/informed | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-01-04 00:00:00 | 407800 |  |  |  |  | Not adjusted/informed |  |  | This example shows the value assumed a lower dollar amount and didn't adjust upwards towards the price.  [NAME] stayed outside of 10%
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-02-05 00:00:00 | 430400 |  |  |  |  | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-03-16 00:00:00 | 443300 |  |  |  |  | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-04-03 00:00:00 | 435600 |  |  |  |  | Not adjusted/informed | Not adjusted/informed
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-01-04 00:00:00 | 704000 |  |  |  |  | Not adjusted/informed |  |  | This example shows a change in the dollar amount for value but not a 3% change in variance, however, a change to 0% variance because an adj. has been made
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-02-05 00:00:00 | 698900 |  |  |  |  | Adjustment made, give me previous answer | 704000 | 2021-01-04 00:00:00
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-03-16 00:00:00 | 706600 |  |  |  |  | Adjustment made in previous month(s)
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-04-03 00:00:00 | 709000 |  |  |  |  | Adjustment made in previous month(s)
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-01-04 00:00:00 | 1010800 |  |  |  |  | Not adjusted/informed |  |  | This example shows a change in the dollar amount for value as well as a >3% change in variance
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-02-05 00:00:00 | 994300 |  |  |  |  | Not adjusted/informed
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-03-16 00:00:00 | 1044100 |  |  |  |  | Adjustment made, give me previous answer | 994300 | 2021-02-05 00:00:00
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-04-03 00:00:00 | 1042700 |  |  |  |  | Adjustment made in previous month(s)
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-01-04 00:00:00 | 684300 |  |  |  |  | Not adjusted/informed |  |  | This example shows the value assumed a lower dollar amount and didn't adjust upwards towards the price.  [NAME] stayed outside of 10%
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-02-05 00:00:00 | 682300 |  |  |  |  | Not adjusted/informed
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-03-16 00:00:00 | 689700 |  |  |  |  | Not adjusted/informed
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-04-03 00:00:00 | 694800 |  |  |  |  | Not adjusted/informed | Not adjusted/informed
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-01-04 00:00:00 | 823300 |  |  |  |  | Not adjusted/informed |  |  | This example shows a change in the dollar amount for value as well as a >3% change in variance
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-02-05 00:00:00 | 828600 |  |  |  |  | Not adjusted/informed
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-03-16 00:00:00 | 899400 |  |  |  |  | Adjustment made, give me previous answer | 828600 | 2021-02-05 00:00:00
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-04-03 00:00:00 | 899800 |  |  |  |  | Adjustment made in previous month(s)