Is there a function......

M

mftmish

Good Morning,
Is there a function which would allow me to compare a
column of numbers to another column of numbers to see if
any of the numbers in column A appear in column B?
Thanks!
 
P

Peo Sjoblom

=COUNTIF(Column1,first-cell_Column2)>0

an example

=COUNTIF($A$2:$A$500,E2)>0

copy down adjacent to the column you are checking
and it will return TRUE if a value in E is also in A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Identifying duplicates between 2 spreadsheets 0
Text duplication question 0
Finding the proper style field and the numbered paragraph value within the style 0
Calculate total by row number 4
Help with a basic condition 0

Top