Jun 15 2021 09:01 AM - edited Jun 15 2021 09:03 AM
Hello, I am looking for a formula that will divide the total amount by as many time as the gift ID is present. For instance, donor 1 is present three times, so the $900 should be divided by 3 and return $300 for each row. For donor 2, the $500 would be divided by 2 as it is present twice for a return of $250 in each row. Etc. The spreadsheet wont' be sorted by ID like below though. Thanks!
Gift ID | Name | Real Amount | Total |
984 | Donor 1 | $ 900.00 | |
984 | Donor 1 | $ 900.00 | |
984 | Donor 1 | $ 900.00 | |
123 | Donor 2 | $ 500.00 | |
123 | Donor 2 | $ 500.00 |
Jun 15 2021 09:26 AM
Solution@Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).
Jun 15 2021 11:33 AM
Jun 15 2021 09:26 AM
Solution@Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).