Formula to hide '0' from blank referenced cells

gebobs · #1 05-07-2014, 09:50 AM

{=if(isblank(RawData!B:B),"",RawData!B:B)}

formuladummy · #2 05-08-2014, 02:16 AM

Thanks.

The formula worked for the first cell and pulled in the column header, but when I changed it to an array formula (using CTRL+SHIFT+ENTER) to reference the whole column, it crashed my whole system. This didn't happen for the other columns.

Is there another option?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
How to organize and insert blank cells between a huge number of data?	tareq	Excel	12	09-29-2010 02:12 PM
Using both drop down lists and blank cells for text	voltarei	Word	0	03-18-2010 04:16 AM