Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return unique fields only - but not a filter?
I think my issue is best displayed with an example:
Here's my rows of data: Column A Bob Dave Dave Eric Simon Simon Simon Simon Tom etc.... Obviously there's other columns of data associated with each person. Is there a formula that can return the following: Bob Dave Eric Simon Tom etc... i.e. only the unique fields from the array? I want to return the unique fields on a different sheet and then use sumif on them to get the required results. I can't realy use filters/advanced filters etc as I want the user to only have to paste in his appropriate data and then move to the other sheet and see his results. Can anyone help? Thanks Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return a unique value | Excel Worksheet Functions | |||
How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
Inconsistent Results: Advanced Filter Unique Records Only | Excel Discussion (Misc queries) | |||
How do I return the unique entries from a column to a listbox | Excel Worksheet Functions | |||
filter on color-filled fields | Excel Worksheet Functions |