Position of nth non-blank cell

[redart]

Hi,
I have a column of numbers that contains randomly positioned blank cells. I'm trying to use the Match function to get the position (row number) at which the count of non-blank cells equals 12, something like
=MATCH(TRUE,count(A1:A50)=12,0)

however I keep getting the #N/A error. Can anyone tell me why this wont work, or suggest an alternative way of doing this ?.

Thanks.

 

[Mr Boris]

This regular formula returns the row number of the 12th non-blank cell in A1:A50 (counting from the last non-blank cell)

=LARGE(INDEX((A1:INDEX(A:A,LOOKUP(2,1/(A1:A50<>""),ROW(A1:A50)))<>"")
*ROW(A1:INDEX(A:A,LOOKUP(2,1/(A1:A50<>""),ROW(A1:A50)))),0),12))

Is that something you can work with?

This may be old, but works great with an indirect() reference! Couldn't get it to work from the top down rather than the bottom up, I always got an error, but I was able to work with it to dynamically show matched data members from an event list!

Great work Ron - greatly appreciated - particularly as it's not an Array Formula! !



Cheers
B