| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifying next number in a range and referencing it
My column looks like this
4101801 4101901 41011001 41011101 there are spaces here 41011205 41011301 Now, I would like to have this list without spaces (without using a filter) purely by using formulas at another location, so that the final result looks like this: 4101801 4101901 41011001 41011101 41011205 41011301 I have been trying for hours but dont get tanywhere, Im probably thinking way to complicated. Many thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying a Selected Range in a Macro | Excel Discussion (Misc queries) | |||
| Searching for mulitple strings and assigning identifying number | Excel Worksheet Functions | |||
| vba, identifying a range | Excel Worksheet Functions | |||
| Identifying Overlapping Dates within a range | Excel Worksheet Functions | |||
| Identifying single column within named range | Excel Discussion (Misc queries) | |||
Threaded Mode
