HELP: EXCEL function Index & Match with 3 criteria, Reward given

Discussion in 'General Precious Metals Discussion' started by Lunardragon, Oct 19, 2016.

  1. Lunardragon

    Lunardragon Well-Known Member Silver Stacker

    Joined:
    Oct 19, 2011
    Messages:
    3,968
    Likes Received:
    76
    Trophy Points:
    48
    Location:
    Land of Nineth Dragon
    Hello,

    I am having a difficulty to apply Index and match excel function (with 3 criteria) on my worksheet.

    Could someone help me please? send me a pm if you could.

    I will send out 1x 1oz Kook PM silver coin (mint) as to say thank you if you could resolve this puzzle.

    thank you.


    LD
     
    Lunardragon, Oct 19, 2016
    #1
  2. Lunarowl

    Lunarowl Active Member Silver Stacker

    Joined:
    Jun 6, 2011
    Messages:
    2,326
    Likes Received:
    19
    Trophy Points:
    38
    Location:
    Lala-land [Sod-nee]
    How did you manage to fit 3 dimensional data into a worksheet to start with?
     
    Lunarowl, Oct 19, 2016
    #2
  3. Lunardragon

    Lunardragon Well-Known Member Silver Stacker

    Joined:
    Oct 19, 2011
    Messages:
    3,968
    Likes Received:
    76
    Trophy Points:
    48
    Location:
    Land of Nineth Dragon
    Thank you all.
    Finally it resolved.

    LO,
    The raw excel data from the system being the database.
    Then need to feed the workbook with using on a cost centre, income category and date as criteria. The formula is very looooong :)
     
    Lunardragon, Oct 19, 2016
    #3

Share This Page