Hello Friends
Version : MS Excel 2010
Attached File Name : How to eliminate the Space.xlsx
My requirement is I want to plot the number of entries which comes ±5 with the Condition (Cell A3) in Quantity (in Cell C13) and the name of the entry )in cell D13).
I myself did a formula and got the Quanity for the entries in Cell C13 and the names in Cell D13.
But the problem is I used IF and REPT formulas (&REPT(CHAR(10),1)) when the condition ±5 is not met with entries then the REPT formula will move the pointer to next line.
So the height is huge since condition is not matched means it is `blank' and REPT move the formula to next entry.
Now my requirement is I want to eliminate the Height / Blank Space in Cell D13. It has to shows just A4 without Space / Height.
thanks in advance
thilag
Bookmarks