How to find the first Non Empty Column & row in a range

**turist** · 03-04-2013, 05:52 PM

In the attached table I found the Last Column and Row which non empty cells in a range.

But I need to find the first column and row which non empty(filled) in the range .

Please see the attached file.

Thanks in advance for the prompt answers and kind help.

Regards,

**tigeravatar** · 03-04-2013, 06:21 PM

turist,

Use the max(if( formula except instead of MAX use MIN, be sure to array-enter it

**turist** · 03-04-2013, 06:40 PM

Thanks for prompt reply, but MIN does NOT work in that case.
When MIN used it shows ZERO(0).

Originally Posted by tigeravatar

turist,

Use the max(if( formula except instead of MAX use MIN, be sure to array-enter it

**tigeravatar** · 03-04-2013, 07:32 PM

Ah, take out the if_false argument from the formula:

Please Login or Register  to view this content.

**turist** · 03-04-2013, 07:41 PM

Yessssssssssss.
I also missed the false argument.

Thanks again for your help.
Regards,

Originally Posted by tigeravatar

Ah, take out the if_false argument from the formula:

Please Login or Register  to view this content.

How to find the first Non Empty Column & row in a range

LinkBack

Thread Tools

Rate This Thread

Display

How to find the first Non Empty Column & row in a range

Re: How to find the first Non Empty Column & row in a range

Re: How to find the first Non Empty Column & row in a range

Re: How to find the first Non Empty Column & row in a range

Re: How to find the first Non Empty Column & row in a range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions