| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching column data
Thank you, that works for me.
"Sheeloo" wrote: Enter this in C1 (or wherever you want) and copy down =SUMPRODUCT(--($B$1:$B$20=A1),--($B$1:$B$20<"")) Change B20 to the end of your list . Anywhere you get 1 or more means that the item in A1 appears in Col B "MNetD" wrote: 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
