tomas395
May 04, 2022Copper Contributor
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..)
David James Sarah
Q1
Q2
Q3
Q4
2. 10. Who had the first, second and third highest sales by names?
3. . What percentage is each sale for all those made in the same year?
Thank you for any help
Tom