Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to fill group of of odd number in sequence ?
Hi,
May I know how to fill up group of odd numbers in sequence in Column B , C and D ? Illustration: A B C D 1 xxx 1 1 1 2 xxx 1 1 1 3 xxx 3 1 1 4 xxx 3 3 1 5 xxx 5 3 3 6 xxx 5 3 3 7 xxx 7 5 3 8 xxx 7 5 3 9 xxx 9 5 5 What formula I must input at cell B1, C1 and D1 before copy downwards to get the numbers ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I generate a Sequence Number System in Excel? | Excel Discussion (Misc queries) | |||
Replace one number in a sequence in a group of cells | Excel Worksheet Functions | |||
how can I put a number from a sequence in every row in excel? | Excel Worksheet Functions | |||
Display zero at the begnning of a number sequence in Excel | Excel Discussion (Misc queries) | |||
auto fill sequence... | Excel Worksheet Functions |