Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to count differences between columns
Hello,
I have a list of 12,000 rows separated into two columns. In each row, the two columns either match or don't. So I've made a third column that is just a simple "if" function in each row that puts a "1" in if the two columns differ. I then use a "countif" at the bottom to tally the # of different rows. The problem I am running into is that some of the rows have one column with an empty cell (no data). So for this row I would have data for one column, but not both. Obviously according to my functions, excel will count these as different. I would like these rows to not be counted as different. Does anyone know how to exclude rows where one of the columns has no data from being counted as "different"? As always, many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two columns contents for differences | Excel Worksheet Functions | |||
Find the differences in 2 columns | Excel Discussion (Misc queries) | |||
Differences between two columns. | Excel Discussion (Misc queries) | |||
Compare 2 columns to see differences | Excel Worksheet Functions | |||
Counting differences in numbers across columns | Excel Worksheet Functions |