Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Hi, I have two columns with numbers. I need to know what numbers in column A
is the same in column B. Could this be done by highlighting? or some other way? Thanks for your help! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Look he
http://www.cpearson.com/excel/Duplicates.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindsey" wrote in message ... Hi, I have two columns with numbers. I need to know what numbers in column A is the same in column B. Could this be done by highlighting? or some other way? Thanks for your help! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Thank you, but the columns are seperate.
A B 12 12 15 16 32 32 543 324 I want know what values that are listed in column B are listed in column A. Thanks! "Niek Otten" wrote: Look he http://www.cpearson.com/excel/Duplicates.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindsey" wrote in message ... Hi, I have two columns with numbers. I need to know what numbers in column A is the same in column B. Could this be done by highlighting? or some other way? Thanks for your help! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Insert the following formula in C1 (or whatever row your data in A and
B begins). It will return "In A" if the value in B occurs in A, or "Not In A" if the value in B doesn't occur in A. =IF(COUNTIF(A$1:A$5,B1),"In A","Not In A") Change A$1:A$5 to the range of cells in A that have data. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 22 Oct 2008 13:19:01 -0700, Lindsey wrote: Thank you, but the columns are seperate. A B 12 12 15 16 32 32 543 324 I want know what values that are listed in column B are listed in column A. Thanks! "Niek Otten" wrote: Look he http://www.cpearson.com/excel/Duplicates.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindsey" wrote in message ... Hi, I have two columns with numbers. I need to know what numbers in column A is the same in column B. Could this be done by highlighting? or some other way? Thanks for your help! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Thank you, this worked! However I have one last question. Is there a way you
could do this with 3 columns and have it tell you which column it is in and not in? Thanks! "Chip Pearson" wrote: Insert the following formula in C1 (or whatever row your data in A and B begins). It will return "In A" if the value in B occurs in A, or "Not In A" if the value in B doesn't occur in A. =IF(COUNTIF(A$1:A$5,B1),"In A","Not In A") Change A$1:A$5 to the range of cells in A that have data. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 22 Oct 2008 13:19:01 -0700, Lindsey wrote: Thank you, but the columns are seperate. A B 12 12 15 16 32 32 543 324 I want know what values that are listed in column B are listed in column A. Thanks! "Niek Otten" wrote: Look he http://www.cpearson.com/excel/Duplicates.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Lindsey" wrote in message ... Hi, I have two columns with numbers. I need to know what numbers in column A is the same in column B. Could this be done by highlighting? or some other way? Thanks for your help! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Match Columns
Is there a way you could do this with 3 columns
and have it tell you which column it is in and not in? Starts to get a bit longish ... but here's one play which executes the logic checks & delivers the results Data is assumed in cols A to C, from row1 down, where data in col C is to be checked with that in cols A and B Copy direct from below n then paste directly into D1's formula bar (it's all meant in the same cell, broken down for easier clarity on the checks/sequence): = IF(C1="","", IF(AND(COUNTIF(A:A,C1),COUNTIF(B:B,C1)),"In A & B", IF(AND(COUNTIF(A:A,C1),NOT(COUNTIF(B:B,C1))),"In A not B", IF(AND(NOT(COUNTIF(A:A,C1)),COUNTIF(B:B,C1)),"In B not A", "Not in A nor B")))) With the formula confirmed in D1, copy D1 down to the last row of data expected in col C P/s: Do take a moment to press the Yes button below from where you're reading/posting (ie in MS's newsgroup webpage). Do this rating for all responses which help to answer your queries -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 columns to 2 columns in different worksheets | Excel Discussion (Misc queries) | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
If columns match | Excel Worksheet Functions | |||
How do i Match all COLUMNS? | Excel Worksheet Functions |