| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I generate a list from a range of values
Hi
I have a worksheet containing a range of values (values are in the format "1.1.i" or "2.a.i") I want to identify which values are represented in the range of values Is there a way of creating a list of values from the range ? This way I can then do a vlookup to identify which values are mssing from the master list I am using Excel 2002 Regards Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| matching one value in a list of values | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Select values from list | Excel Discussion (Misc queries) | |||
| How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
Threaded Mode
