Spreadsheet: 774791d1648655787-help-to-create-a-formula-to-find-max-value-k-for-each-customer-acct-sample-1-
Sheet: Sheet1

CUSTOMER_ID | [NAME] | LOC | COL 1 | DATE_1 | ID_2 | ID_3 | DAYS | [NAME] | DATE_3 | VALUE | [NAME] By Customer
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2021-03-05 00:00:00 | 2021-03-02 00:00:00 | 0 |  |  |  |  | 9120
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2021-04-08 00:00:00 | 2021-03-31 00:00:00 | 400 |  |  |  | 10689447 | 5892
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 32 | 2021-05-03 00:00:00 | 2021-05-02 00:00:00 | 320 |  |  |  | 1080203222 | 464
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 30 | 2021-06-02 00:00:00 | 2021-06-01 00:00:00 | 30
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2021-07-01 00:00:00 | 2021-06-30 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 32 | 2021-08-02 00:00:00 | 2021-08-01 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2021-09-01 00:00:00 | 2021-08-30 00:00:00 | 480
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 30 | 2021-10-07 00:00:00 | 2021-09-29 00:00:00 | 9120
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2021-10-29 00:00:00 | 2021-10-28 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 34 | 2021-12-07 00:00:00 | 2021-12-01 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 32 | 2022-01-03 00:00:00 | 2022-01-02 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2022-02-11 00:00:00 | 2022-01-31 00:00:00 | 0
1044510111 | Test 1 | 45 | 247 | 9999-12-31 00:00:00 | 44444 | 3 | 29 | 2022-03-02 00:00:00 | 2022-03-01 00:00:00 | 0
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 31 | 2021-03-22 00:00:00 | 2021-03-21 00:00:00 | 5201
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 30 | 2021-04-21 00:00:00 | 2021-04-20 00:00:00 | 4726
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 29 | 2021-05-20 00:00:00 | 2021-05-19 00:00:00 | 4734
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 32 | 2021-06-21 00:00:00 | 2021-06-20 00:00:00 | 5892
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 30 | 2021-07-21 00:00:00 | 2021-07-20 00:00:00 | 5486
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 29 | 2021-08-19 00:00:00 | 2021-08-18 00:00:00 | 5512
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 32 | 2021-09-20 00:00:00 | 2021-09-19 00:00:00 | 5503
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 29 | 2021-10-19 00:00:00 | 2021-10-18 00:00:00 | 5140
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 30 | 2021-11-18 00:00:00 | 2021-11-17 00:00:00 | 4803
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 32 | 2021-12-20 00:00:00 | 2021-12-19 00:00:00 | 4734
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 31 | 2022-01-20 00:00:00 | 2022-01-19 00:00:00 | 4380
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 29 | 2022-02-18 00:00:00 | 2022-02-17 00:00:00 | 4691
10689447 | Group 2 | 202 | 247 | 9999-12-31 00:00:00 | 55555 | 3 | 31 | 2022-03-21 00:00:00 | 2022-03-20 00:00:00 | 4129
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 31 | 2021-03-30 00:00:00 | 2021-03-28 00:00:00 | 243
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 30 | 2021-04-29 00:00:00 | 2021-04-27 00:00:00 | 327
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 29 | 2021-06-01 00:00:00 | 2021-05-26 00:00:00 | 299
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 32 | 2021-06-30 00:00:00 | 2021-06-27 00:00:00 | 366
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 30 | 2021-07-29 00:00:00 | 2021-07-27 00:00:00 | 464
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 31 | 2021-08-31 00:00:00 | 2021-08-27 00:00:00 | 315
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 30 | 2021-09-28 00:00:00 | 2021-09-26 00:00:00 | 413
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 29 | 2021-10-27 00:00:00 | 2021-10-25 00:00:00 | 236
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 34 | 2021-11-30 00:00:00 | 2021-11-28 00:00:00 | 223
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 29 | 2021-12-30 00:00:00 | 2021-12-27 00:00:00 | 154
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 30 | 2022-01-28 00:00:00 | 2022-01-26 00:00:00 | 153
1080203222 | Group 3 | 30 | 130 | 9999-12-31 00:00:00 | 22222 | 1 | 29 | 2022-03-01 00:00:00 | 2022-02-24 00:00:00 | 121