Blank cells

its_subu

New Member
Joined
Nov 19, 2005
Messages
7
I have an excel list. Rows till 4000 and columns till M. From A to L there are values in all the 4000 rows. But M column has values for may be 1000 rows only and that too in random.

My question is how can I make the blank cells of the M column appear first in the list with its corresponding rows followed by the rows which have A to M with values.


Please let me know.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
its_subu said:
I have an excel list. Rows till 4000 and columns till M. From A to L there are values in all the 4000 rows. But M column has values for may be 1000 rows only and that too in random.

My question is how can I make the blank cells of the M column appear first in the list with its corresponding rows followed by the rows which have A to M with values.

Please let me know.
Hi its_subu:

Here is one way ...

1) use a helper column N ... with following formula in cell N1 ...

=IF(M1="",1,M1)

this formula is then copied down to your 4000 rows

2) then sort your list A1:N4000 by column N in ascending order

3) then you may optionally delete the helper column N

You may also automate this process with a macro.

I hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,670
Members
412,481
Latest member
nhantam
Top