Spreadsheet: 733412d1621562371-trying-to-find-a-way-to-get-the-previous-answer-from-a-list-of-values-jwallz44
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 | -8300 |  | 98.5133440802436 | 0.01509090909090909 | 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 | -11000 | 0.7545454545454545 | 98.0392156862745 | 0.02 | Not adjusted/informed
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-03-16 00:00:00 | 543400 | 6600 | -1.666666666666667 | 101.2145748987854 | -0.012 | Adjustment made | 561000 | 2021-02-05 00:00:00
ABC1 | 123 Main Street | Amityville | YO | 11111 | 550000 | 2021-04-03 00:00:00 | 545500 | 4500 | 1.466666666666667 | 100.8249312557287 | -0.008181818181818182 | Adjustment made in previous month(s)
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-01-04 00:00:00 | 1127000 | -77000 |  | 93.16770186335404 | 0.07333333333333333 | 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 | -97400 | 0.7905544147843943 | 91.51124280983092 | 0.09276190476190477 | Not adjusted/informed
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-03-16 00:00:00 | 1146700 | -96700 | 1.007238883143744 | 91.56710560739513 | 0.09209523809523809 | Not adjusted/informed
[NAME] | 174 Katherine RD | Amityville | YO | 11111 | 1050000 | 2021-04-03 00:00:00 | 1147200 | -97200 | 0.9948559670781894 | 91.52719665271967 | 0.09257142857142857 | Not adjusted/informed | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-01-04 00:00:00 | 407800 | 182200 |  | 144.6787641000491 | -0.3088135593220339 | 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 | 159600 | 1.141604010025063 | 137.0817843866171 | -0.2705084745762712 | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-03-16 00:00:00 | 443300 | 146700 | 1.087934560327198 | 133.092713737875 | -0.2486440677966102 | Not adjusted/informed
GHI3 | 15 Lima Ave | Amityville | YO | 11111 | 590000 | 2021-04-03 00:00:00 | 435600 | 154400 | 0.9501295336787565 | 135.44536271809 | -0.2616949152542373 | Not adjusted/informed | Not adjusted/informed
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-01-04 00:00:00 | 704000 | -5000 |  | 99.28977272727273 | 0.00715307582260372 | 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 | 100 | -50 | 100.0143081985978 | -0.0001430615164520744 | Adjustment made | 704000 | 2021-01-04 00:00:00
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-03-16 00:00:00 | 706600 | -7600 | -0.0131578947368421 | 98.92442683272007 | 0.01087267525035765 | Adjustment made in previous month(s)
JKL4 | 1117 Walnut Tree LN | Amityville | YO | 11111 | 699000 | 2021-04-03 00:00:00 | 709000 | -10000 | 0.76 | 98.58956276445699 | 0.01430615164520744 | Adjustment made in previous month(s)
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-01-04 00:00:00 | 1010800 | 128200 |  | 112.6830233478433 | -0.1125548726953468 | 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 | 144700 | 0.8859709744298548 | 114.5529518254048 | -0.1270412642669008 | Not adjusted/informed
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-03-16 00:00:00 | 1044100 | 94900 | 1.524762908324552 | 109.0891677042429 | -0.08331870061457419 | Adjustment made | 994300 | 2021-02-05 00:00:00
MNO5 | 112 Ranch River Rd | Amityville | YO | 11111 | 1139000 | 2021-04-03 00:00:00 | 1042700 | 96300 | 0.9854620976116303 | 109.2356382468591 | -0.0845478489903424 | Adjustment made in previous month(s)
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-01-04 00:00:00 | 684300 | 104700 |  | 115.3003068829461 | -0.1326996197718631 | 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 | 106700 | 0.9812558575445174 | 115.6382822805218 | -0.135234474017744 | Not adjusted/informed
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-03-16 00:00:00 | 689700 | 99300 | 1.074521651560926 | 114.3975641583297 | -0.1258555133079848 | Not adjusted/informed
PQR6 | 135 Castle CT | Amityville | YO | 11111 | 789000 | 2021-04-03 00:00:00 | 694800 | 94200 | 1.054140127388535 | 113.5578583765112 | -0.1193916349809886 | Not adjusted/informed | Not adjusted/informed
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-01-04 00:00:00 | 823300 | -75700 |  | 109.194704239038 | -0.08420467185761958 | 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 | -70400 | 0.7545454545454545 | 108.4962587496983 | -0.07830923248053392 | Not adjusted/informed
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-03-16 00:00:00 | 899400 | 400 | -1.666666666666667 | 99.95552590615966 | 0.0004449388209121246 | Adjustment made | 828600 | 2021-02-05 00:00:00
STU7 | 123 Carmel DR | Amityville | YO | 11111 | 899000 | 2021-04-03 00:00:00 | 899800 | 800 | 1.466666666666667 | 99.91109135363413 | 0.0008898776418242492 | Adjustment made in previous month(s)