Hello,
I have a table where the items listed in col A:A, may be repeated .. but there are other criteria in columns B:D, and a timestamp for each row in col E:E. I have generated this sheet with VBA userform where the user enters selection from listboxes and applies status via combo boxes. When user clicks > OK vba code grabs values in list box (that user has selected) and selections from the combo boxes and pastes into excel.
Where i have 2 orange highlighted rows in the data tab (representing Home Page) I would like to grab one that is timestamped the latest (this is also the one noted as mark as Approved).
I have combed through forums for days now, and tried different combinations of formulas, such as using: min/max, countif, vlookups based on IF statements.
I cannot figure out how to identify the following:
IF a Feature is listed in column A:A more than once AND has the same values in column B:B & C:C, then take the one with the latest timestamp and copy to a new tab.
Thanks a million in advance!
Heat map 6-25.xlsm
Bookmarks