|
|
|
|
#1
09-11-2017, 03:59 PM
|
|||
|
|||
There are multiple ways to do what you ask and here's just one... =IF(Sheet2!A1<>"",Sheet2!A1,"") 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting with blank cells | mummy | Excel | 1 | 09-02-2017 06:04 AM |
 have a formula that combines two cells return a zero instead of a blank cell
|
Kubi | Excel | 3 | 08-07-2017 11:52 PM |
| Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
| Formula to hide '0' from blank referenced cells | formuladummy | Excel | 3 | 05-08-2014 02:33 AM |
|
Selecting blank cells in criteria
|
apolloman | Excel | 6 | 08-24-2011 05:38 AM |
Windows Vista 
Office 2007
Hybrid Mode