Hi,
I am trying to avoid calculations on certain rows that I pull from the database.
If cell value in column B is repeated (duplicate) value across the entire column B, then only pick the row with earliest date in column A for the cell value in column B, and delete all other duplicate rows. See raw data example below and expected data below. How do I do this using formula?
A B
4/5/20 5
4/6/20 5
4/10/20 5
4/10/20 8
4/10/20 9
4/13/20 9
4/10/20 12
4/11/20 12
4/14/20 9
4/10/20 3
Expected result
A B
4/5/20 5
4/10/20 8
4/10/20 9
4/10/20 12
4/10/20 3
Bookmarks