Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get nth distict value in a column
Hi,
Is there anyone clever enough to know how to work this out? I've got a column with a list of data. In a summary I'd like to be able to get a distinct list from the column. So from the following source data: Column ----------- IB3\SJ16 IB3\SJ16 IB3\SJ16 SJ17 SJ17 IB3 IB3\SJ16 Verdi SJ17 Tax Certs Verdi Verdi I'd like to be able to get Summary Column ------------- IB3\SJ16 SJ17 IB3 Verdi Tax Certs I've tried playing with the various LOOKUP functions but this has got me stumped. Can anyone point in the direction on how to get this working. Many thanks Si |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |