First second third non blanks without ROW or COLUMN Functions

[seenu151]

Hi ,

I want to get first second and third non blanks. Column and Row functions are not supported. Please see the attachment for more info.
Any help is appreciated.

[daffodil11]

Instead of using ROW & COLUMN, which are just technically shortcuts, you could explicitly state the lazy array they refer to.

B9:

Please Login or Register  to view this content.

copied over and down

Produces result identical to your output.

[seenu151]

I am getting all zeros. Can you please double check..

[Haseeb Avarakkan]

Try in B9

=INDEX($B$3:$M$3,MATCH(1,INDEX((COUNTIF($B$8:$M8,$B$3:$M$3)=0)*ISNUMBER($B$3:$M$3),0),0))

Copy down & across.

[daffodil11]

I apologize. INDEX(..SMALL(IF is an array formula.

Most array formulas require you activate them.

This is confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.