Re: Duplicate values
- From: "Norman Jones" <normanjones@xxxxxxxxxxxxxxxxxxx>
- Date: Sat, 10 Dec 2005 08:58:46 -0000
Hi Fred,
See Chip Pearson's duplicate page for a varirty of techniques:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
See particularly the sections, at the foot of the page, entitled:
Extracting Values Common To Two Lists
and
Extracting Values On One List And Not Another
---
Regards,
Norman
"fred" <fred@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1F599C5B-92C1-40DE-9D2D-9DC6BC054A7C@xxxxxxxxxxxxxxxx
> Each quarter I receive two lists of data containing information concerning
> how much money my shops have taken and when and another list detailing the
> amount taken to the bank and when.
>
> I will then have to compare the two lists to ensure the amount taken
> matches
> the amount banked which it quite often dosn't.
>
> Each list has the store number a date and an amount.
>
> Is it possible to automatically look through the two amount columns and
> match up those where the store number and the amount are the same and then
> align these duplicate values , thus leaving me just those with different
> values to manually wade through.
>
> Thanks
.
- Prev by Date: Re: Count no of rows with interior color
- Next by Date: 438
- Previous by thread: calneder
- Next by thread: Re: Duplicate values
- Index(es):
Relevant Pages
|
