Mark certain cells

  • Thread starter Thread starter frederico roldao
  • Start date Start date
F

frederico roldao

I have a sheet with 3 columns.

On column "A" I have 1000 email addresses, on column "B" I have 200 email
addresses.

On column "C" I want to have a formula that will mark the cell if the
address on the adjacent cell (in column B) also exists somewhere in column A.

How do I go about this?
 
In C1 enter:
=IF(COUNTIF(A:A,B1)>0,"a","") and set the font to Marlett

Then copy down
 
Hi,

=IF(COUNTIF($A$1:$A$1000,B1)>0,"Duplicate","")

Drag down to the length of column B

Mike
 
one way - in C1:

=IF(COUNTIF($A$1:$A$1000,B1)>0,"yes","")

then drag/copy down
 
I'm sorry, I didn't explain myself properly!

I mean to have a mark on column C on the rows where in column A there is a
value that is also in column B (anywhere on column B, not necessarily side by
side)
 
And if you try any of the suggestions provided you'll find that's exactl what
they do!!
 
actually the formula that worked was =IF(COUNTIF(B:B;A1)>0;"y";""), which is
a bit different from what was advised, but the advice served as a starting
point, so, thanks!
 
You must log in or register to reply here.

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

Help needed 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel VBA 1
How to count the maximum number flanked by zeros 9
Conditional Minimum formula 3
Adding data only if adjacent to cell labeled "male"/"female" 1
COUNTIFS ? 1

Back
Top