Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicate values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate values | Excel Worksheet Functions | |||
DUPLICATE VALUES | Excel Discussion (Misc queries) | |||
Duplicate Values | Excel Discussion (Misc queries) | |||
Duplicate values | Excel Discussion (Misc queries) | |||
Duplicate values | Excel Programming |