Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with filtering...
I have two columns of similar data - how do I set up a filter to return (or
enter into another column) the data that is only in one column? Ex, column "ALL" has the letters A-Z in it, while column "some" has just consonants. How can I set up a filter to return just the vowels that are missing from the "some" column? Thanks in advance - |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with filtering...
One way:
Add a column to your table: A2:A27 = ALL B2:B22 = SOME C2:C27 = this formula entered in C2 and copied down: =COUNTIF(B$2:B$22,A2) Filter on column C = 0 Biff "Ed" wrote in message ... I have two columns of similar data - how do I set up a filter to return (or enter into another column) the data that is only in one column? Ex, column "ALL" has the letters A-Z in it, while column "some" has just consonants. How can I set up a filter to return just the vowels that are missing from the "some" column? Thanks in advance - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Filtering | Excel Worksheet Functions |