Forum Discussion
how to find the last value of a certain type in a row of values
I have two rows a and b, I want to find the value of row a that is adjacent to the last value of a certain typ in row b.
=INDEX(A3:O3,LARGE(IF(ISTEXT(A4:O4),COLUMN(A4:O4)),1))
=INDEX(A3:O3,LARGE(IF(ISNUMBER(A4:O4),COLUMN(A4:O4)),1))
You can apply these formulas to find the last text or number. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.