deenoseban
New Member
Hi All,
I need a small help in fixing my formula.
i have a report from erp with few employees name and the amount they owe. It is a dynamic report and changes everyday.
My requirement is that I need a formula to link with employees who has a balance
In the below screenshot column D shows the balance and i wrote a formula to bring the values =IF($D2>0,B2,"")
My objective is avoid blanks with out using filter. Is there a dynamic formula to fix this.
I need a small help in fixing my formula.
i have a report from erp with few employees name and the amount they owe. It is a dynamic report and changes everyday.
My requirement is that I need a formula to link with employees who has a balance
In the below screenshot column D shows the balance and i wrote a formula to bring the values =IF($D2>0,B2,"")
My objective is avoid blanks with out using filter. Is there a dynamic formula to fix this.