| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching column data
Hello,
I have two columns where I need to find non-matching data. For example, I would want to know in this example anytime a value appears in column A and does not appear in Column B (i.e., APPLE does not appear in column B). Using the sort function will not work as I have blank spaces in some of the rows and they are not all in the same order. Thanks! A B APPLE GRAPEFRUIT ORANGE PEAR PEAR ORANGE GRAPEFRUIT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
| Matching Data in a Row and Display in Column | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
| matching data from column b | Excel Worksheet Functions | |||
| Matching data in one column to another | Excel Worksheet Functions | |||
Threaded Mode
