Posted by: Anonymous
[ip: 75.121.38.205]
on November 01, 2008 12:22 PM
One way to get a CONFLICT flag on every conflict is to change to the COUNTIF function, i.e.
IF(COUNTIF(B$2:B$15;B2)=1;"OK";"CONFLICT")
I include the $ in my formulas to make copy and paste easier.
Learn about Linux
Download Linux
Get Linux help
Conflicts
Posted by: Anonymous [ip: 75.121.38.205] on November 01, 2008 12:22 PMIF(COUNTIF(B$2:B$15;B2)=1;"OK";"CONFLICT")
I include the $ in my formulas to make copy and paste easier.
#