| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists
In col A- there are numbers 1 thru 6 -4 times (4 number 1s, four nimber 2s
etc) that as a name associated to the number in col B. How do i shoe on a separte worksheet all name in col b that is associated with the number in col a. For ie. list of names that has the number 1 associatedd to it in col A. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
How about a PivotTable?
Use col A and col B as row values, and in that order. On Oct 30, 6:40 pm, Jeffrey wrote: In col A- there are numbers 1 thru 6 -4 times (4 number 1s, four nimber 2s etc) that as a name associated to the number in col B. How do i shoe on a separte worksheet all name in col b that is associated with the number in col a. For ie. list of names that has the number 1 associatedd to it in col A. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists
ilace,
thank you for your response,however I was unable to make your recommedation work. "iliace" wrote: How about a PivotTable? Use col A and col B as row values, and in that order. On Oct 30, 6:40 pm, Jeffrey wrote: In col A- there are numbers 1 thru 6 -4 times (4 number 1s, four nimber 2s etc) that as a name associated to the number in col B. How do i shoe on a separte worksheet all name in col b that is associated with the number in col a. For ie. list of names that has the number 1 associatedd to it in col A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| lists from other lists in excel | Excel Worksheet Functions | |||
Linear Mode
