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 ret...
Elva_Tanguerre Perhaps like this? (Used good old VLOOKUP as I don't know if you have access to newer functions like XLOOKUP).
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.