Hi !!
In column A, I have PnL values (both positive & negative numbers)
In column B, I have a formula that returns a value only if a value in A is positive value: =IF(A2<0,"",A2)
In column C, I have a formula that returns a value only if a value in A is negative value: =IF(A2>0,"",A2)
Therefore coloum B and C, either have values of blank cells (with formulas in them).
What formula can i put in coloum D that can return the contents in coloumn B but without all the gaps ?
(a condensed list tat returns all the positive values without any gaps)
I have attached a screenshot showing an example in green of the desired outcome (manually entered)
I am using Excel 365
In column A, I have PnL values (both positive & negative numbers)
In column B, I have a formula that returns a value only if a value in A is positive value: =IF(A2<0,"",A2)
In column C, I have a formula that returns a value only if a value in A is negative value: =IF(A2>0,"",A2)
Therefore coloum B and C, either have values of blank cells (with formulas in them).
What formula can i put in coloum D that can return the contents in coloumn B but without all the gaps ?
(a condensed list tat returns all the positive values without any gaps)
I have attached a screenshot showing an example in green of the desired outcome (manually entered)
I am using Excel 365