This did what I needed it to do when I used it on the same sheet, but
couldn't get it to work right when referencing another sheet. (Basically
putting unique values on another sheet. e.g.
=IF(COUNTIF(Main!M$19,Main!M24)=1,Main!M24,"")

I haven't looked at the countif function, but I'm guessing I need to strip
out one of the 'Main!' references and change it to the local sheet cell
reference

"ShaneDevenshire" wrote:

Hi,

Select the column and use the Data, Filter, Advanced Filter, copy to a new
location, Unique records only.

Or use a formula like
=IF(COUNTIF(A$1:A1,A1)=1,A1,"")

and copy it down. Only the unique entries will be displayed.

If these help, please click the Yes button.
--
Thanks,
Shane Devenshire


"OnTheEdge" wrote:

I'm trying to figure out how I can automatically only show unique values in a
column range using a function. Is there a way to do this?

Thanks...