how to leave the cells that are not used empty blank instead of 0![]()
Please Login or Register to view this content.
how to leave the cells that are not used empty blank instead of 0![]()
Please Login or Register to view this content.
Hi K-Ching,
I think you could try this.
You will need to put your parameters back in but this does change the result, if it is '0' to a blank.![]()
Please Login or Register to view this content.
Hope this helps![]()
Remember you are unique, like everyone else
nope it dow not work
What value does 'Jour1Train' etc have?
Why are you using this word for a Cell value?
Is it a named range?
Probably best if you post the file.
sorry works fine my mistake i forgot it was an array formula i'm too tired thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks