| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to filter and list data based on different data.
My first column is a list of surnames so non-unique data. My second is a list
of first names, again non-unique but there is no duplication of the combination of surnames and first names. I need to list all the first names which go with an individual surname. eg Brown John Brown Peter Brown Michael Smith John Smith David Jones Peter Jones David (but about 500 rows altogether) and I need to be able to, using the above example, enter Smith in a cell and get a list showing "John" and "David", or enter Jones and get "Peter" and "David" Can someone help? Please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) | |||
| Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
| Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
| how do i filter data by number of characters in excel? | Excel Discussion (Misc queries) | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
Threaded Mode
