Hello,
I need help creating a formula that would consolidate results, as in keeping the same ID for a year a Sum the numbers for that year while also at the same time, if that ID hasn't had a value in that year, to be removed from the filter/list.
For example the data:
PT1000000 - 1 - 2012
PT1000000 - 1 - 2013
PT1000000 - 2 - 2014
PT2000000 - 3 - 2013
PT2000000 -1 - 2014
PT2000000 - 1 - 2015
Result in column 2013 then consolidating the data and sum the previous result:
P100000 - 2
PT20000 - 3
2014
P100000- 4
PT20000 - 4
2015 (PT10000 was removed from 2015 list as it doesn't have any result in this year, it it had an entry with the year with a number even if it's zero it would still count and be in 2015)
PT20000 - 5
Example spreadsheet with expected results and a few more entries:
test3.xlsx
Thank you in advance!
I need help creating a formula that would consolidate results, as in keeping the same ID for a year a Sum the numbers for that year while also at the same time, if that ID hasn't had a value in that year, to be removed from the filter/list.
For example the data:
PT1000000 - 1 - 2012
PT1000000 - 1 - 2013
PT1000000 - 2 - 2014
PT2000000 - 3 - 2013
PT2000000 -1 - 2014
PT2000000 - 1 - 2015
Result in column 2013 then consolidating the data and sum the previous result:
P100000 - 2
PT20000 - 3
2014
P100000- 4
PT20000 - 4
2015 (PT10000 was removed from 2015 list as it doesn't have any result in this year, it it had an entry with the year with a number even if it's zero it would still count and be in 2015)
PT20000 - 5
Example spreadsheet with expected results and a few more entries:
test3.xlsx
Thank you in advance!
Last edited:
