Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's the scene -
List 1: Joe Joe Joe Jill Jill Jake Jane Jane I want a list that will summarize the names such that I will see each name only once (same premise as the Autofilter); i.e. desired result: Summary: Joe Jill Jake Jane In addition, if I add Jack to List 1....- List 1: Joe Joe Joe Jill Jill Jake Jane Jane Jack Jack Jack Jack .....the name "Jack" will automatically be added to the Summary list: Summary: Joe Jill Jake Jane Jack Thank you to anyone that can help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create a sorted summary list of counted species | Excel Discussion (Misc queries) | |||
Check 2 different list get associated value from a column | Excel Worksheet Functions | |||
Filterered list to new worksheet | Excel Worksheet Functions | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Summary List?? | Excel Discussion (Misc queries) |