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
Thursday, November 12, 2009
Subscribe to:
Post Comments (Atom)
Thnk you.
ReplyDelete