Forum Discussion

Rhys Smith's avatar
Rhys Smith
Copper Contributor
Mar 25, 2018

Need some help regarding a workable formula

Hi all,   I am looking to see if anybody would be able to help make a workable formula for my budget I am making for myself.   I have attached two images - hopefully this makes sense? Basi...
Formulas & Functions
Requests
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 25, 2018

Rhys,

 

are you sure you are in the right community? The screenshots don't look like Excel.

 

Rhys Smith's avatar
Rhys Smith
Copper Contributor
Mar 25, 2018

Hi Detlef,

 

Thanks for the response - the version I use for Excel would probably be classed as 'ancient' these days, it is around the 2010 version...
I was hoping although it is an older version of Excel the formulas would still be very similar?

Regards
Rhys

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 25, 2018

    Rhys,

     

    I just noticed the tag "Excel on Mac". That's why it looks so different.

     

    I would recommend a pivot table. Simple and efficient.