Hi Greg
I think you asked this question before :-)
What do you mean with Count 1?
Please provide an example of your data (plain text - no attachment
please)

--
Regards
Frank Kabel
Frankfurt, Germany

"GregS" schrieb im Newsbeitrag
...
Hello,

Is there a way to COUNT Unique values and showing only
those values where the Count is 1 ....Please Note: The
Count must show up on a seperate WorkSheet ( Audit
WorkSheet) not on the Source WorkSheet which will be
imported into Access ........ this, I beleive, makes
Filter Unique not an option.

Thanks,

Greg