Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there one or combination of Excel function to count unique entr
I have a spreadsheet with multiple rows and columns. In each row and column,
the cells contain one or more the same data for example A B C .... 1 Orange USA A2 2 Apple USA B1 3 Orange Canada C1l 4 Oragne USA A2 5 Peach Canada A1 6 Apple USA A2 I need a function or combination of function to ONLY list ONE occurance of each. In the example. Col A will list "Orange, Apple Peach", Col B lists "USA, Canada" Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there one or combination of Excel function to count unique entr
Użytkownik "Wellie" napisał w wiadomo¶ci ... I have a spreadsheet with multiple rows and columns. In each row and column, the cells contain one or more the same data for example A B C .... 1 Orange USA A2 2 Apple USA B1 3 Orange Canada C1l 4 Oragne USA A2 5 Peach Canada A1 6 Apple USA A2 I need a function or combination of function to ONLY list ONE occurance of each. In the example. Col A will list "Orange, Apple Peach", Col B lists "USA, Canada" Regards u can try with advanced filter if u want to get unique entries mcg |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there one or combination of Excel function to count unique
I looked at the doc and not quite sure how to use the advance filter. I need
the result to be placed on another worksheet or other column. Rather than shown in a dropdown box like the AutoFiler. Please help a bit further. "Gazeta" wrote: U¿ytkownik "Wellie" napisa³ w wiadomo¶ci ... I have a spreadsheet with multiple rows and columns. In each row and column, the cells contain one or more the same data for example A B C .... 1 Orange USA A2 2 Apple USA B1 3 Orange Canada C1l 4 Oragne USA A2 5 Peach Canada A1 6 Apple USA A2 I need a function or combination of function to ONLY list ONE occurance of each. In the example. Col A will list "Orange, Apple Peach", Col B lists "USA, Canada" Regards u can try with advanced filter if u want to get unique entries mcg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
excel should have a function to count sheets | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |