Finding similarities/differences between columns.

I have 10 columns that have accounts sorted in specific ways. Some of the columns have more accounts than the others. If I chose one column, how might I find out how the other columns differ from that one in both the order of the accounts, and also which accounts my chosen column has/doesn't have that the other columns don't have/have.

Thanks.

Your second question can be addressed by the use of the COUNTIF function. A value of zero would indicate the the chosen value does not exist in the specified range.

Originally Posted by mrice

Your second question can be addressed by the use of the COUNTIF function. A value of zero would indicate the the chosen value does not exist in the specified range.

Thanks mrice. I see people use COUNTIF a lot and I'm just getting around to learning how to use it.

Two follow-up questions:
1. Lets say I used the COUNTIF and found that there was a 1 for BA. This tells me that the BA account in 2nd column can be found in the first. however, there isn't a BA account in the first column...only PBA, ABA, etc etc. Is there a way I can weed out the partials like this?

2. Is there a faster way to make a list of all the accounts missing than to go through and find all the zero values and then copy/paste those accounts into other cells?

Thanks for your help.

You could use a user defined function such as this to find partials

Please Login or Register  to view this content.

Hit Alt F11, insert a new module and paste in thee code above.

You willl then have a new function in the function wizard which you can use like any other.

e.g.

=CountIfPartial(A1,C1:C2)