Forum Discussion
Solved
Amount divided by how many time the ID repeats
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 |
Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).
2 Replies
Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).
- Thanks. Makes sense, I did not even need the vlookup - I just selected the Total amount cell.
