Data Filter Operation

[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

 

[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))

 

[Tim Childs]

Tom

Many thanks for elegant solution, as ever

Best wishes

Tim