Forum Discussion
Solved
Please suggest a formula for below query
Dears, I am preparing a log sheet that contains documents/drawings number with revisions. and each time I have to update one column manually with a word "Superseded" for older revisions of the same ...
- This formula seems to do the trick:
=IF(COUNTIF([@[Documents No.]]:OFFSET([Documents No.],ROW([@[Documents No.]]),0),[@[Documents No.]])>1,"SUPERSEDED","")
Dear Mr. Haytham,
Thanks for your response, Your suggested formula is working.
Regards
Sikander
Thanks for your response, Your suggested formula is working.
Regards
Sikander
Excellent, you're welcome.