Try this:

=IF(ISERR(SMALL(IF(FREQUENCY(CODE($A$2:$A$10),CODE ($A$2:$A$10)),ROW(INDIRECT("1:"&ROWS($A$2:$A$10))) ),ROWS($1:1))),"",INDEX($A$2:$A$10,SMALL(IF(FREQUE NCY(CODE($A$2:$A$10),CODE($A$2:$A$10)),ROW(INDIREC T("1:"&ROWS($A$2:$A$10)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
Adjust your range to suit


"Shudder777" wrote:

I was wonder how to go about the following:

I have a list of characters, and I want to be able to have a list of all of
the unique characters. The built in advanced filter function is not case
sensitive. Is there anyway to make it case sensitive, or is there another way
to do this?

Any help is much appreciated.