How can I check for duplicate $'s?

M

MDG

I have made an Excel (2003 version) spread sheet (370+ entries) of money
spent. I want to check the column containing the dollar amounts to see if I
have duplicated any amounts.
How can I do this?
 
B

Bob Phillips

If the amounts in column C, in column D add

=IF(COUNTIF(C:C,C1)>1,"Dup","")

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
M

MDG

Bob Phillips said:
If the amounts in column C, in column D add

=IF(COUNTIF(C:C,C1)>1,"Dup","")

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...
 
M

MDG

Bob Phillips said:
If the amounts in column C, in column D add

=IF(COUNTIF(C:C,C1)>1,"Dup","")

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)




Thank you, Bob, for replying. I didn't make myself clear. All the $ amounts are in one column. My first column is the date, my second is "to whom paid" and my 3rd is the amount. I want to double check that I have not duplicted $'s under another date or name so I'm looking for example 501.00 twice. Help!
Click to expand...
TIA,
MDG
 
K

Kevin Vaughn

Once you have entered Bob's formula, and copied down, then check all
instances of dup. Those are the duplicates you said you were looking for.
 
Top