Hello,
I have an original list of numbers with blank cells in the range B2:K2.
I would like a new list in the range B3:K3 ignoring blank cells.
Please help with any formula or VBA
Thank you all.
I am using Excel 2000
Regards,
Moti
I have an original list of numbers with blank cells in the range B2:K2.
I would like a new list in the range B3:K3 ignoring blank cells.
Please help with any formula or VBA
* | A | B | C | D | E | F | G | H | I | J | K | L |
1 | ||||||||||||
2 | Orignal List With Blank | 1 | 3 | 4 | 6 | 7 | 9 | 10 | ||||
3 | New List No Blank | 1 | 3 | 4 | 6 | 7 | 9 | 10 | ||||
4 | ||||||||||||
5 |
Thank you all.
I am using Excel 2000
Regards,
Moti