Forum Discussion
excel is there a formulae to do this?
Hello I am trying to make my life a little bit easier, I have several sheets that I would like to extract an entire row using specific criteria in one cell. I am not tech savvy so coding and macros a...
=INDEX('00GM14'!A$2:A$6,SMALL(IF('00GM14'!$F$2:$F$6="NT",ROW($A$2:$A$6)),ROW(1:1))-1)
This formula works for data from one sheet as shown in the attached file. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.