Dear Sir/Madam,
I need help on generates top gross amount for the Sales Person, Product, Division and Section (which color in yellow)
Thanks alot,
Regards,
Puffyboy
Dear Sir/Madam,
I need help on generates top gross amount for the Sales Person, Product, Division and Section (which color in yellow)
Thanks alot,
Regards,
Puffyboy
See attachment
Quang PT
Hi Quang,
Can the column rank show the list example like (who is highest sales person with the gross amount, highest of which product and , etc).
Thank you.
Regards,
puffyboy
A sample for Sales:
R6:
Q6:![]()
Please Login or Register to view this content.
Similar to Products, Division and Section with range adapted.![]()
Please Login or Register to view this content.
Last edited by bebo021999; 03-03-2014 at 11:20 PM.
That works great! Thanks alot
Sorry it can't shows sales person name, products, etc if it's other months
Dear Sir/Madam,
Please find attached. I've included Feb amount for ranking of the month of Jan and Feb.
Thank in advance,
puffyboy
Sorry, it is my false.
In Q6:
See attahment.![]()
Please Login or Register to view this content.
That's great! Thanks alot bebo![]()
Nice to hear it works. Now is it time to mark it [SOLVED] and give rep to someone who gave help?
Done. Many thanks for your help![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks