Forum Discussion

tomas395's avatar
tomas395
Copper Contributor
May 04, 2022

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.....
Excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP

tomas395 

You can create a list of persons and sales and sort it descending on sales.

tomas395's avatar
tomas395
Copper Contributor
May 04, 2022

HansVogelaar   I do not think it will work out, I need just one formula(see below)

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 04, 2022

    tomas395 

    You'll need to use a combination of INDEX and MATCH.

  • tomas395's avatar
    tomas395
    Copper Contributor
    May 04, 2022
    Could you please clarify it?
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 04, 2022

    tomas395 

    I think it's time you did some research yourself.

  • tomas395's avatar
    tomas395
    Copper Contributor
    May 04, 2022
    Do not worry that is what I have been doing for the last few hours
  • tomas395's avatar
    tomas395
    Copper Contributor
    May 04, 2022
    that is what I have been doing for the last couple of hours

Share

Resources