Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
An array or function is needed to create a list based on a single shared
criteria. ID# Value Name y1 5 Jill x2 7 Jack x3 3 Mary y1 15 James y1 9 Vito z1 4 Wally Based on the above table a list selecting ID# y1 would generate: Jill James Vito Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) |