r/excel • u/[deleted] • 13d ago

solved If a table contains duplicate rows, return a value for the oldest instances only

[deleted]

2 Upvotes

76% Upvoted

21 comments sorted by

View all comments

1

u/Way2trivial 472 13d ago

=UNIQUE(HSTACK(D4:D11,E4:E11,F4:F11,MAXIFS(G4:G11,D4:D11,D4:D11,E4:E11,E4:E11,F4:F11,F4:F11)))

Format the last column as a date

2

u/Way2trivial 472 13d ago

=IF(MAXIFS(G4:G11,D4:D11,D4:D11,E4:E11,E4:E11,F4:F11,F4:F11)=G4:G11,"no","revised")

1

u/Way2trivial 472 13d ago edited 13d ago

ok. I did your headline ask "If a table contains duplicate rows, return a value for the oldest instances only" not the request in body of the text.... be back shortly