Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flitering for unique records in Col B based on filtering in Col A
I have three rows of data in Say Col A, Col B and Col C
Col A has values W,X,Y,Z Col B has values 1,2,3,4 ... 50. Col C has names of customers. There are about 300 records, thus multple numerical values in 4 categories of W, X, Y and Z. There are also repeating values of numbers for a given category. e.g. Category W has 1,3,28,1,1,34,1,45,2,5,2,2,6 etc in Col B and Col C has diff customer names. Thus although here category W has 13 records there are only 8 unique values in Col B. If I filter on Col A for category W, I get 13 rows. How should I filter, use formula or sort or something else, that will give me unique values of Col B when I filter on Col A. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering unique records ajit | Excel Discussion (Misc queries) | |||
Filtering for Unique Records with multiple-column criteria | Excel Discussion (Misc queries) | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
filtering for unique records | Excel Discussion (Misc queries) |