Match Identifying Problem

DORAMIUS

New Member
Joined
May 4, 2005
Messages
30
I'm currently using formula =COUNTIF($G$1:G1,G1)>1 in column G to identify duplicate numbers. However, sometimes a reference number is not required, so ****** is input instead as it cannot be blank for business reasons. my formula identifies it as a duplicate and it's not supposed to be so it shows on a report incorrectly. What formula can I add to remove the cell highlighting for just ****** without it conflicting with my current formula? I've attempted a number of differet ways, but they seem to not work because of the above listed formula, or they cancel the ability of the first formula.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello, DORAMIUS,

would this work for you ?
=AND(COUNTIF($G$1:G1,G1)>1,G1<>"******")


kind regards,
Erik
 

Watch MrExcel Video

Forum statistics

Threads
1,118,674
Messages
5,573,597
Members
412,537
Latest member
Mohamed_5966
Top