Question on IFAND formula in Excel - & is it the best method

Hello happy campers,

I have a question regarding an IFAND formula (if its even the best method)
I have a sheet (attached) and i would like a forumla to tell me the following.

If the name in column A appears again with the same area as Column B then show me "DUPLICATE" if not show me nothing

Now the IF statement i can do, but i do not know how to combine it with the AND, & im also unsre if this is the best method.
In short i want to know when a name appears in the list under the same area more than once.

Thanks in advance for your time.

galvinpaddy

Assuming you have Excel 2010 as per your profile, then try:

=IF(COUNTIFS($A$1:$A1,$A1,$B$1:$B1,$B1)>1,"Duplicate","")

copied down