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","")
Hi,
Please try this formula in column S.
=IF(MAX((I2=$I$2:$I$9)*$F$2:$F$9)=F2,"","SUPERSEDED")
Note: Each time you enter this formula you have to press Ctrl+Shift+Enter at the same time because it's an array formula.
- Dear Mr. Haytham,
Thanks for your response, Your suggested formula is working.
Regards
Sikander- Excellent, you're welcome.
