Find Duplicates then perform calculation

[Lisa]

Is there a function that will find duplicate records and
then if it is duplicate it will then perform a calculation?
And where would I put this function?

Example:
If Invoice ## is listed more than once, divide by # of
times listed.

Thanks

Lisa

 

[Guest]

use the find duplicates wizard
hth