Share this content
1

Eliminate Duplicate Customers From Excel

I just want the last invoice for each customer

Invoice    Date              Inv#     Name                Amount

Invoice   12/05/2012   33077   Fe**, Lucy            94.34

Invoice   12/23/2014   33538   Fe**, Lucy            93.28

Invoice   01/27/2016   33786   Fe**, Lucy            93.28

Invoice   03/16/2018   40192   Fe**, Lucy            95.40

Invoice   11/25/2013   33329   Fel*****, Ron   127.20

Invoice   12/14/2016   33934   Fel*****, Ron   174.90

Invoice   05/03/2012   32919   Fer*****, Mrs.    91.16

Invoice   06/23/2016   33870   Fer*****, Mrs.    90.71

Replies (1)

Please login or register to join the discussion.

wss
By MarianaSink
Mar 21st 2018 14:24

liked

Thanks (1)
Share this content