Thursday, November 12, 2009

Sort in MS Excel format: Leave the cell or cell box space (not a simple type)

     Today I presented in MS Excel Tip sequence which forms the desired cell or cell box space (not a simple type)



Steps are as follows
1. Insert cells to 2 cells, using formulas in MS Excel cells in the first sequence. And set the default to make the cell sorting patterns, an example is Cell A and B, respectively.


2. Cell type formula in the desired order by model example is the Cell B7:
=IF(MOD(A5,2)=1,A5+1,"")



3. Copy the formula as needed.


4. Select the first cell and set the hide.


5. You can format as needed



Try applied job.

Thank you,
Worawut  Bunwang

1 comment: