|
|
#6
01-20-2016, 08:37 AM
|
||||
|
||||
As I said in post #2, a formula can't show/hide rows. A formula to fill 'YES' gaps would be considerably more complex and you'd never know whether all the data were captured unless you made sure to have amply more rows with formulae than you have with 'NO' data to display.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Can a Data Source be one sheet in a multi-sheet Workbook
|
nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
| Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
| Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
|
Help Coloring a cell in Sheet one if data is missing from another sheet
|
Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode