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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I generate a list from a range of values
your are required to elaborate your problem, which values you want to identify? robo7084 Wrote: 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 -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=557971 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I generate a list from a range of values
Sorry - to explain
Imagine I have the number 1-5 as my criteria - Throughout a range of cells on a sheet I have lots of number from 1-5. I need to generate a list of all the numbers displayed within that range to identify any of the numbers within my criteria have not been entered in the range eg A1=2, A2=3, A3=5 B1=1, B2=3, B3=2 C1=5, C2=3, C3=3 The list generated would be 1,2,2,3,3,3,3,5,5 By doing a vlookup I would then know that number 4 had not been entered in the range The format for the numbers are "1.1.i", "1.1.ii", etc "starguy" wrote: your are required to elaborate your problem, which values you want to identify? robo7084 Wrote: 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 -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=557971 |
Reply |
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 |