Florida1510
New Member
- Joined
- Mar 13, 2020
- Messages
- 35
- Office Version
- 2010
- Platform
- Windows
Excel Gurus,
Good morning I need some assistance. I have a results spreadsheet that is feed from another spreadsheet. This results 0.00 in months where there is no data yet. Here is my question I'm trying to find the NEXT to last data field so that my report can show the Current months data and the Previous months data side by side. I have a formula to pull in the last value that is not a zero however I'm struggling to write a formula that will pull in the previous months results. Right since all the future months that have no data are zeros the formula that I have written is going to the bottom of the spreadsheet and pulling in the next to last entry which is a zero. If someone could advise me what I need to add to the below formula so that it will only pull in the previous month result if in has data greater than zero. Note - actual results will always be greater than zero.
Current formula - =INDEX(Data[Total SIMs],AGGREGATE(14,6,(ROW(Data[Total SIMs])-ROW(D3)+1)/(Data[Total SIMs]<>""),2))
I have added an image of my spreadsheet. The result I'm trying to get for this month would be 117,643.40
Any assistance would be appreciated. Thanks in advance.
Owen
Good morning I need some assistance. I have a results spreadsheet that is feed from another spreadsheet. This results 0.00 in months where there is no data yet. Here is my question I'm trying to find the NEXT to last data field so that my report can show the Current months data and the Previous months data side by side. I have a formula to pull in the last value that is not a zero however I'm struggling to write a formula that will pull in the previous months results. Right since all the future months that have no data are zeros the formula that I have written is going to the bottom of the spreadsheet and pulling in the next to last entry which is a zero. If someone could advise me what I need to add to the below formula so that it will only pull in the previous month result if in has data greater than zero. Note - actual results will always be greater than zero.
Current formula - =INDEX(Data[Total SIMs],AGGREGATE(14,6,(ROW(Data[Total SIMs])-ROW(D3)+1)/(Data[Total SIMs]<>""),2))
I have added an image of my spreadsheet. The result I'm trying to get for this month would be 117,643.40
Any assistance would be appreciated. Thanks in advance.
Owen