Count Unique

[GSears]

Hello,

Is there a way to COUNT Unique values and showing only
those values where the Count is > 1


Thanks,

Greg

 

[Frank Kabel]

Hi
what do you mean with this
1. Counting the number of unique entries: See:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

2. Or do you want to count only those entries which appear at least
twice in your list?

 

[Peo Sjoblom]

I would use the advanced filter, unique records only and criteria =A3>1
where A3 is the first row of data
Where list range could be $A$2:$A$500
Criteria range $F$1:$F$2
where the =A3>1 is in F2 and F1 is blank
then you check unique records only

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[GSears]

Thank You,

However I cannot use Filter since the data is on another
WorkSheet ....... What I am doing is an Audit Check (
Audit WorkSheet ) to see if there's redundant data ( which
will be eventually imported into Access) in the Data
WorkSheet ....... The check must also be automated with
either a function or Pivot Table.

Thanks,

Greg

 

[Peo Sjoblom]

You can still use filter, you only have to start from the sheet where you
want the
result.
Ms. Dalgleish have some info how to extract to another worksheet here

http://www.contextures.com/xladvfilter01.html


You could automate it using a macro.

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom