Data Filter Operation

T

Tim Childs

I have one sheet (Sheet A) with formulae (or even formulas, if you
must) referring to numbers on a different sheet (Sheet B), which
itself has a Data Filter to help with the interim analysis of data but
needs to be set at Data Showall once finished.

What is the simplest way of getting a warning to appear on Sheet A
when the data is being masked by the use of the filter in Sheet B.

Thanks in advance, Tim
 
T

Tom Ogilvy

=if(subtotal(9,SheetB!F2:F3000)<>Sum(SheetB!F2:F3000),"Data if
filtered","Data is not Filtered")

pick a column that has no blanks and is composed of numbers.

Or you could use CountA (and subtotal(3,range)) as opposed to sum (and
Subtotal(9,range))
 
Top