Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I know how Advanced Filter Unique works, but I would like to have something
different. Suppose I have a little table like this : Henk 1 4 6 7 Koos 2 5 7 1 Toos 4 3 2 4 Henk 1 5 7 3 If I use Advanced Filter Unique records, the result will be the same as the tabel itself, because the table contains unique records only. But I want to see Henk only once with data 1 4 6 7, or with 1 5 7 3. E.g. Henk 1 4 6 7 Koos 2 5 7 1 Toos 4 3 2 4 How do I do this? Thanks in advance filter, Henk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count unique fields | Excel Worksheet Functions | |||
Counting Unique Text Fields | Excel Discussion (Misc queries) | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Vlookup for non-unique fields | Excel Discussion (Misc queries) | |||
Return unique fields only - but not a filter? | Excel Worksheet Functions |