Count of unique cells?

[medwardnfriends]

is there a formula to count the unique cells in a column? or formula to assign a binary value to a cell if another cell in the same row is unique to every other cell in its' column? Please help

 

[T. Valko]

I suppose the debate is whether or not one has a couple of approaches they use, or whether just a single way - for consistency purposes - is always offered up...

Matty

In other words...

One is set in their ways and one creates solutions for the immediate task at hand and is therefore more versatile.

 

[medwardnfriends]

I am using 2007. how do I add this USED function as a module? is that code entered into the VBE window?

 

[Aladin Akyurek]

I am using 2007. how do I add this USED function as a module? is that code entered into the VBE window?

In order to add the function to your workbook, run...

ALt+F11
Insert | Module
File | Close and Return to Microsoft Excel.