ExcelEnthusiast93
New Member
- Joined
- Dec 13, 2018
- Messages
- 1
Hi All,
I have a large spreadsheet in which the data changes on a monthly basis, each month i need to go through all the rows and find any that are not equal to "0". Unfortunately it is not as simple as applying a filter as there a lot of formatting issues (Which i do not control).
Currently on a seperate blank spreadsheet i have the following formulas to obtain this information and then i have to filter to get all the values at the top.
1.) =IFERROR(IF($ED1<>0,$A1,""),"")
2.) =IFERROR(IF($ED1<>0,Accruals!$C1,""),"")
3.) =IFERROR(ROUND(IF($ED1>0,Accruals!$ED1,""),2),"")
4.) =IFERROR(ROUND(IF($ED1<0,$ED1,""),2),"")
With ED being the column of December 2018, EE December Total, so January data i need will be EF etc..
Is there a way i can get a code so if these conditions are FALSE, then it will search the next Row, and all i have to do is change the first part of the code each month?
Appreciate any help!
Thank you,
I have a large spreadsheet in which the data changes on a monthly basis, each month i need to go through all the rows and find any that are not equal to "0". Unfortunately it is not as simple as applying a filter as there a lot of formatting issues (Which i do not control).
Currently on a seperate blank spreadsheet i have the following formulas to obtain this information and then i have to filter to get all the values at the top.
1.) =IFERROR(IF($ED1<>0,$A1,""),"")
2.) =IFERROR(IF($ED1<>0,Accruals!$C1,""),"")
3.) =IFERROR(ROUND(IF($ED1>0,Accruals!$ED1,""),2),"")
4.) =IFERROR(ROUND(IF($ED1<0,$ED1,""),2),"")
With ED being the column of December 2018, EE December Total, so January data i need will be EF etc..
Is there a way i can get a code so if these conditions are FALSE, then it will search the next Row, and all i have to do is change the first part of the code each month?
Appreciate any help!
Thank you,
