Forum Discussion
excel help
Hi, Could anyone help me with following tasks using just one excel formula? (dataset below) 1.Percentage of quarter's sales made by each trader. (for instance David´s sales for Q1.....
Thanks I got it.
Do you have any hints for 2. tasks?
Do you have any hints for 2. tasks?
Check out the RANK function.
- Yes but there is problem , how to sum sales for each person
You can use SUMIF or SUMIFS to sum the sales per person.
and answer for this task should be name of person. So who has highest, second highest and third highers sales. Any ideas?
