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","")
This formula seems to do the trick:
=IF(COUNTIF([@[Documents No.]]:OFFSET([Documents No.],ROW([@[Documents No.]]),0),[@[Documents No.]])>1,"SUPERSEDED","")
=IF(COUNTIF([@[Documents No.]]:OFFSET([Documents No.],ROW([@[Documents No.]]),0),[@[Documents No.]])>1,"SUPERSEDED","")