Blank cells

[its_subu]

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.

 

[Yogi Anand]

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!

 

[its_subu]

Thank you. This worked perfectly fine.

GoodLuck