Mar 17 2022 01:49 AM
Dear All,
I have a trouble when I make a copy value from a Pivot Table. Where cells in Pivot table are empty, excel does not recognize those cell as empty ones. So when I apply a formula witch involve those cells, an error occurs.
A simple Vlookup pointing that cells, as I expect, should return a "0" value, but instead of "0" it show me an empty cell, like if there is some value in it.
Does anyone have any idea about it? I use large excel files and sometimes this cells are really too much to be corrected manually.
Thank you all!
Marco
Mar 17 2022 01:54 AM
Mar 17 2022 02:28 AM
Mar 17 2022 02:42 AM
first of all thank your for your reply.
Unfortunately I do not use spaces between the " symbol, because I just want an epty cell if there is no value inside.
In general, if I use an =iferror(vlookup(A1;B1:C10;2;FALSE);""). This formula show me a value if present in that range, otherwise put nothing, neither a "0" value. The problem is starting from this point. If I make a copy value of the cell "A1" when it is empty, and try to use it inside a formula, excel show me a #value! error.
If I try the =Code(A1) it show me that it is an empty cell, but in reality Excel use it like a non-empty one...
Thanks
Marco
Mar 17 2022 03:07 AM
@Marco853 Not entirely sure what you are trying to do, but a cell with nothing in it is considered to be blank/empty. However, a cell with "" may appear to be blank/empty for the human eye, but it contains an empty string and for Excel, the cell is not blank/empty.
Can you share a file or include a screenshot showing the formula you are using and the content of the cells/range?
Mar 17 2022 03:46 AM
Mar 17 2022 03:53 AM
@Marco853 Still don't understand what you are trying to achieve, but if having a lot of zeroes is the problem, consider a custom format that suppresses zeroes. Something like General;General;
Mar 17 2022 04:15 AM