MATCH to ignore blank cells in array
 

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

MATCH to ignore blank cells in array
 

Hi,

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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tony Gardner" wrote in message
...
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

MATCH to ignore blank cells in array
 

On 10 Sep, 11:10, "Ashish Mathur" wrote:
Hi,

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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"Tony Gardner" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks!

MATCH to ignore blank cells in array
 

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Tony Gardner" wrote in message
...
On 10 Sep, 11:10, "Ashish Mathur" wrote:
Hi,

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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com

"Tony Gardner" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks!