Find first nonblank cell row # in pivot table using MATCH

S

Space Elf

I can't figure out a way to get MATCH to use a lookup value that would be
anything except a blank cell inside a Pivot Table. I also tried OFFSET, but
the data I need to get to is to the left of the lookup column. Plus, I need
the row # for other functions.
=MATCH('anything but blank',CO869:CO933,0)
I have tried >"0", >0, NOT("0"), NOT(0), NOT(ISERROR(CO869:CO933), ISBLANK
with previous, NOT(""), NOT(" ").
The column I'm searching has various numbers and I need to find the data to
the left of any number (nonblank).
Please help?
 
B

Biff

Hi!

Pivot tables! %^&*($!!!

Try this:

Entered as an array using the key combo of CTRL,SIFT,ENTER:

=INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933<>"",0))

Biff
 
S

Space Elf

Much Thanks!


Biff said:
Hi!

Pivot tables! %^&*($!!!

Try this:

Entered as an array using the key combo of CTRL,SIFT,ENTER:

=INDEX(CN869:CN933,MATCH(TRUE,C0869:CO933<>"",0))

Biff
Click to expand...
 
Top