Hello Excel-experts,
PROBLEM:
The user defines a MINIMUM and a MAXIMUM value (whole numbers) as well as a list of some numbers to be excluded.
Required is:
1. A list with all numbers from MIN to MAX without the numbers from the exclude-list.
2. All numbers from the required list should be numbered sequentially in a separate row.
Please check out my sample worksheet in which you can see my (poor) attempt at solving my numbering-problem as well as three examples of what I would like to accomplish. I also give some comments of what means what and what doesn't work.
Any help is really appreciated.
Kind regards,
Fie Buls
P.S. I hope the attaching of the worksheet will work... if not I will look in the help to figure out how to do it :-)
Bookmarks