| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Numbers and Produce a List
Hi Everyone,
I have a List of 6 Number Combinations in Columns "B:G" in a Sheet Named "Draws". The Minimum Number is 1, and the Maximum Number is 49 within EACH 6 Number Combination. I have a Sheet Named "Results", and in Cell "B2" I have a Figure of the Number of Draws I want to go Back. If the Figure in Cell "B2" is 20 for Example, that is the Number of Draws I want to go Back ( Starting at the Bottom and Going Up ). I then want to Produce a List of Numbers that have NOT Been Drawn in those 20 Draws from the 49 Numbers Please. Many Thanks in Advance. All the Best. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| produce list automatically from choice of drop down list | Excel Discussion (Misc queries) | |||
| How do I delete unique numbers from a list and save duplicates? | Excel Worksheet Functions | |||
| How do I produce Automatic Quotation Numbers in Excel? | Excel Discussion (Misc queries) | |||
| produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
| How do I delete a character from a list of item numbers? | Excel Worksheet Functions | |||
Threaded Mode
