Hi Guys,
Can you please help me with a task I have to solve about average but I have no idea how to do it.
What I have here is that I have to put data into some empty fields in order to get the data in the same levels throw months.
I attached a spreadsheet but in short what I have to get would be:
if month 1 = 10 and other months empty so I would to get 10 to all months so I used max([variable1] ...[variable6]) So everything was ok here...
But if I have two or more values I would have to get the average from these values and fill the empty fields....
Can you please help me with this?
Thanks a ton
