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 - |
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 - |
All times are GMT +1. The time now is 10:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com