Just need a simple yes/no.
I have lots and lots of data.
What I wana do is remove any entry if it was later reversed.
i.e. a customer purchases something it costs $20.0
so row 1
Cost Reversal
20 0
a customer then returns said item
row 87
Cost Reversal
0 20
so if the rows custID# num clerk# match in both entries i dont want them coming back in my query of all costs.
is this possible or is this a task for excel for pre or post data mining.
Thanks!
I have lots and lots of data.
What I wana do is remove any entry if it was later reversed.
i.e. a customer purchases something it costs $20.0
so row 1
Cost Reversal
20 0
a customer then returns said item
row 87
Cost Reversal
0 20
so if the rows custID# num clerk# match in both entries i dont want them coming back in my query of all costs.
is this possible or is this a task for excel for pre or post data mining.
Thanks!