I am using:
=COUNTIF($D$2:$D$14,D2)>1
to give me TRUE / FALSE, where column D is a helper column consisting of columns A, B and C concatenated.
Is there any way to use a single formula for CF without a helper column?
I am using:
=COUNTIF($D$2:$D$14,D2)>1
to give me TRUE / FALSE, where column D is a helper column consisting of columns A, B and C concatenated.
Is there any way to use a single formula for CF without a helper column?
Last edited by tone640; 08-23-2011 at 08:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks