Hi
-I'm using non english Ms Excel 2010
I have made one sheet with original table like this:
http://prntscr.com/25s2nv
in other sheet I need copy of that table, so I connected (tied) (I don't know correct english word sorry) original with copy.
I need just data, formatting doesn't matter. Like this:
http://prntscr.com/25s3l1
(In my language 'Hárok' means Sheet btw)
1, I know about excel options > advanced card > Show a zero in cells that have zero value.
2, I know about custom formatting exact cells with text: 0;-0;;@
3, I know about Pivot table zero setting, but I haven't pivot tables and never will use.
so those ones, are not solutions for me.
Why ?
Because I need to keep blank cells blank in 'copy' sheet same as in original, and cells with value zero, same with value zero. But now excel made all zeros out of purpose by changing untouched cells to zeros and also zero value cells to zero. I need make him distinguish between those two types of zero cells, or just simply not write zeros into blank cells.
I have found this old article:
http://windowssecrets.com/forums/showthread.php/44686-Paste-link-gives-zero-%28Excel-xp%29
- someone wrote this command to write into cell:
=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)
- I was trying to rewrite it with any combination because I'm using excel 2010, but excel don't want accept my formula. Something is wrong. (Yes I changed word Sheet for word in my language)
Please help me how may I set it well
Thanks a lot
Bookmarks