PDA

View Full Version : Solved: Count Function



rahullambe
11-05-2008, 01:36 PM
Hi Friends,

I have 2 excel sheets, 1 sheet contain list of all customers and second sheet contain service provided to customer. now in 1 sheet of all customer list contains more than 4000 names of customer, whereas the 2nd sheet contains 500 names. these 500 names are included in 1st sheet. I just want to put up mark "YES" in next row of customer list in 1st sheet to whom we service provided. and rest should be "NO".

Please help me.:think:

Bob Phillips
11-05-2008, 01:46 PM
=IF(COUNTIF(Sheet2!$A:$A,A1),"Yes","No")

rahullambe
11-05-2008, 02:46 PM
Thanks a Lot