Test.xlsx
I have a table, with Column A=Upload Date, B=Case ID, C=Version, D=Amount, G=RA Number
Column B, F,GI, are supposed to be unqiue, and should contain one row for the table but they have multiple estimates. I want to pick the estimate uploaded with the latest date in Column A.
This will help remove duplication, and only give 1 record for RA. Note: some of the estimates may have more than 2 estimates (Column C).
Bookmarks