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:

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: