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.....
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?
You can create a list of persons and sales and sort it descending on sales.
HansVogelaar I do not think it will work out, I need just one formula(see below)
You'll need to use a combination of INDEX and MATCH.
- Could you please clarify it?
I think it's time you did some research yourself.
- Do not worry that is what I have been doing for the last few hours
- that is what I have been doing for the last couple of hours