If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
compare data from one column with another and compare result to yet another
I'm not real sure how to go about doing this.
I need to compare one column (ALL - a2:a3793) to see if it has any numbers that are not in another column (ALL AFTER CHG - d2:d2735). Then take the results of that and compare them to another column. (INACTIVE c2:c1056) All of the columns are formatted as text. What is the most efficient way to do this? TIA Matt |
#2
|
|||
|
|||
compare data from one column with another and compare result to yet another
easiest way is to use formulas
in B2 or another column in row 2 =if(Countif($D$2:$D$2735,A2)=0,If(Countif($C$2:$C$ 1056=0,"Not in B or C","Not in B, in C"),"In B") then drag fill down to 3793. -- Regards, Tom Ogilvy "Matt Williamson" wrote in message ... I'm not real sure how to go about doing this. I need to compare one column (ALL - a2:a3793) to see if it has any numbers that are not in another column (ALL AFTER CHG - d2:d2735). Then take the results of that and compare them to another column. (INACTIVE c2:c1056) All of the columns are formatted as text. What is the most efficient way to do this? TIA Matt |
Thread Tools | |
Display Modes | |
|
|