View Duplicate entries

Frank,

That formula work great, but when you are tagging duplicates where the range
has formulas in them, then the formula ends up getting tagged as a duplicate
and not the result. Any ideas how I can get around that issues?

Ruan


"Frank Kabel" wrote in message
...
Hi
have a look at
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

Oscar wrote:
What would I need to do to view duplicate entries. I have a mailing
list, that i get new data in excel every week Id like to view
duplicates on a separate sheet so I wont stain my eyes looking thru
thousands of entries any help is appreciated.

Hi
it should only tag them as duploicates if they return the same values

--
Regards
Frank Kabel
Frankfurt, Germany


Ruan wrote:
Frank,

That formula work great, but when you are tagging duplicates where
the range has formulas in them, then the formula ends up getting
tagged as a duplicate and not the result. Any ideas how I can get
around that issues?

Ruan


"Frank Kabel" wrote in message
...
Hi
have a look at
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

Oscar wrote:
What would I need to do to view duplicate entries. I have a mailing
list, that i get new data in excel every week Id like to view
duplicates on a separate sheet so I wont stain my eyes looking thru
thousands of entries any help is appreciated.

Hello Frank,

Sometimes my formulas will return a blank value.

Example - I have the following formula on Sheet 2 in a column that has 400
rows.
=IF(DMC_SSN="","",DMC_SSN)

DMC_SSN is the range name on Sheet 1

So, what is happening is that it is tagging all my blanks

Ruan

"Frank Kabel" wrote in message
...
Hi
it should only tag them as duploicates if they return the same values

--
Regards
Frank Kabel
Frankfurt, Germany


Ruan wrote:
Frank,

That formula work great, but when you are tagging duplicates where
the range has formulas in them, then the formula ends up getting
tagged as a duplicate and not the result. Any ideas how I can get
around that issues?

Ruan


"Frank Kabel" wrote in message
...
Hi
have a look at
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

Oscar wrote:
What would I need to do to view duplicate entries. I have a mailing
list, that i get new data in excel every week Id like to view
duplicates on a separate sheet so I wont stain my eyes looking thru
thousands of entries any help is appreciated.

Hi
try
=IF(AND(COUNTIF($A$1:$A$1000,A1)1,A1""),"Duplic ate","")

--
Regards
Frank Kabel
Frankfurt, Germany


Ruan wrote:
Hello Frank,

Sometimes my formulas will return a blank value.

Example - I have the following formula on Sheet 2 in a column that
has 400 rows.
=IF(DMC_SSN="","",DMC_SSN)

DMC_SSN is the range name on Sheet 1

So, what is happening is that it is tagging all my blanks

Ruan

"Frank Kabel" wrote in message
...
Hi
it should only tag them as duploicates if they return the same
values

--
Regards
Frank Kabel
Frankfurt, Germany


Ruan wrote:
Frank,

That formula work great, but when you are tagging duplicates where
the range has formulas in them, then the formula ends up getting
tagged as a duplicate and not the result. Any ideas how I can get
around that issues?

Ruan


"Frank Kabel" wrote in message
...
Hi
have a look at
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

Oscar wrote:
What would I need to do to view duplicate entries. I have a
mailing list, that i get new data in excel every week Id like to
view duplicates on a separate sheet so I wont stain my eyes
looking thru thousands of entries any help is appreciated.