Forum Discussion
Solved
help with syntax/functions to select cells based on criteria of other cells...and not null
Hello, Folks helped me with a previous question about selecting cells based on criteria of other cells (see below). But now I've realized that I also need to exclude looking at cells that are bla...
=IFERROR(INDEX(B:B,LARGE(IF(($D:$D<>"")*($A:$A=$I2),ROW($A:$A)),1)),"")You can try this formula which returns the expected results in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The formula was entered in cell J2 and copied across range J2:N4.
=IFERROR(INDEX(B:B,LARGE(IF(($D:$D<>"")*($A:$A=$I2),ROW($A:$A)),1)),"")You can try this formula which returns the expected results in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The formula was entered in cell J2 and copied across range J2:N4.
That worked great! Thanks so much!