Forum Discussion
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 documents .Please suggest me a formula that automatically update "supersede" column if excel found the latest revision of any document. Please refer to the below given screenshot.
- 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.
- This formula seems to do the trick:
=IF(COUNTIF([@[Documents No.]]:OFFSET([Documents No.],ROW([@[Documents No.]]),0),[@[Documents No.]])>1,"SUPERSEDED","")
