MATCH to ignore blank cells in array

T

Tony Gardner

Just spent ages typing out my query and I can't see it posted
anywhere...
I need the MATCH function to ignore blank cells and return the row of
the next value in an array.
i.e, if A1 is blank and A2 contains 3, I need to return 2 from looking
in the array "A1:A2"

Cheers
 
T

Tony Gardner

Hi,

You may array enter (Ctrl+shift+Enter) this formula

=MATCH(FALSE,A1:A2="",0)

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com







- Show quoted text -
Click to expand...

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Match to ignore blank cells 0
Match Array returning #NA, Works individually 4
Dealing with the error: unable to filter on excel hc home school 0
Index Match & #values 0
Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Lookup Function help 1
Compare last digit in 5 cells for match 0

Top