I have the excel table with invoices for last year. I have to find the highest value for each of my clients. Please find attached the example table. My result shoud be:
Client X 2500
Client Y 3000
Client Z 4200
First I have to use counter of clients. But what’s the next step?
Of course my analize is much more complicated, but if I know the above solution, I will manage it.