Hi,
I have the attached spreadsheet that has 3 columns.
What I need to happen is when there are two values in Column A "Acct" that are them same go to Column C "Amount" and make the value for both rows equal to the highest value.
ie; for Acct: 123456 change Row 2 to the highest Value ie; 250.66
Cheers
Bookmarks