Hello guys.
I need your help again.
I have a client who gave me a list of all the invoices he issued for the year 2017 (Around 800 invoices).
He wants to know his top 10 clients.
The excel file has 6 columns: Date, Invoice Number, Client Code, Client Name, Disbursements, Fee, VAT, Total.
I want to create a new worksheet and have a table with the total of each client (Total fee) in every row. For a lot of clients multiple
invoices were issued during the year. How can I get a total for each client from that list and be able to see his top 10 clients?
If you need additional information let me know.
Thanking you in advance for any help.
Bookmarks