Hi!
I have a sheet that uses data from many other sheets. I.E. IF(A1="";"";A1)
Later on i get in trouble when i use the COUNTA formula... because Excel somehow thinks that "" is a blank space and counts that as a letter. This makes my "COUNTA" go nuts... (me as well)
Any other expressions than "" I can use? (0 and autoformat is a no-go!)
Vast amount of data and cells in original file, so changing the original sheets are... let's call it impossible
Appreciate any help on this.
Best Reggards
Wig!
I have a sheet that uses data from many other sheets. I.E. IF(A1="";"";A1)
Later on i get in trouble when i use the COUNTA formula... because Excel somehow thinks that "" is a blank space and counts that as a letter. This makes my "COUNTA" go nuts... (me as well)
Any other expressions than "" I can use? (0 and autoformat is a no-go!)
Vast amount of data and cells in original file, so changing the original sheets are... let's call it impossible

Appreciate any help on this.
Best Reggards
Wig!