| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I automatically sequence the month
Assume your data in column A looks like this:
(4 data cells and 2 blanks) A B May jnrc hapj odgq nmek June gqck qfde qicn rmbp July mrki apbr kqak ibkc In column B, type May, select it and 5 blank cells below it, and drag down the fill handle as far as data in column A goes. Select data in column A and Go To Special Blanks Delete Shift cells left |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding values based on current month | Excel Worksheet Functions | |||
| Month End Projection formula? | Excel Worksheet Functions | |||
| How do you change the year but not the month automatically? | Excel Discussion (Misc queries) | |||
| 4 and 5 week months | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Threaded Mode
