Forum Discussion

Sikander Bashir's avatar
Sikander Bashir
Copper Contributor
May 23, 2018
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 ...
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    May 24, 2018
    This formula seems to do the trick:
    =IF(COUNTIF([@[Documents No.]]:OFFSET([Documents No.],ROW([@[Documents No.]]),0),[@[Documents No.]])>1,"SUPERSEDED","")
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
May 24, 2018

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.

Sikander Bashir's avatar
Sikander Bashir
Copper Contributor
May 27, 2018
Dear Mr. Haytham,
Thanks for your response, Your suggested formula is working.

Regards
Sikander
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 28, 2018
    Excellent, you're welcome.