function to show if two fields in a column have the same data.

  • Thread starter Thread starter j-p-c
  • Start date Start date
J

j-p-c

column A has peoples names and B has their phone numbers.
if both b1 and b18 have the phone number 123456 I would like the C column
(c1 and c18) to have a tick or something to show that those lines have the
same number. or to make both the phone numbers highlight?

how can I do this.

I have tried but have no idea where to start.


thanks
 
C1: =IF(COUNTIF($B:$B,B1)>1,"a","")

format as Marlett font, and copy down
 
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

Cell format 3
If function help 0
Word Create a Phone Book using MailMerge in word 2007 0
large database with multiple rows 2
Wild Cards in Vlookup 3
Buying a modern phone help needed. ;-) 14
Checking if data exists another table and, if yes, extracting a value 0
Nested IF? 3

Back
Top