| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number columns skip blanks
I have 5 columns of data imported from another program into excel. I want
the 1st column to be numbered in sequential order based on input from the 4th column. If cell D1 has text in it then cell A1 should read the number 1. If cell D2 is empty the A2 should be empty. If cell D3 has text in it then A3 should read number 2. The forth column will always change based on the imported data and I want the first column to reflect that. Any ideas? -- wsk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you extend the number of blank columns in a worksheet? | Excel Worksheet Functions | |||
| Paste Special - Skip Blanks | Excel Discussion (Misc queries) | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
| I WANT TO SET PRINT RANGE TO NUMBER OF COLUMNS | Setting up and Configuration of Excel | |||
| Change number of columns mid page? | Excel Worksheet Functions | |||
Threaded Mode
