Data Filter Operation
 

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

Data Filter Operation
 

=if(subtotal(9,SheetB!F2:F3000)<Sum(SheetB!F2:F30 00),"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))

--
Regards,
Tom Ogilvy


"Tim Childs" wrote in message
om...
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

Data Filter Operation
 

Tom

Many thanks for elegant solution, as ever

Best wishes

Tim

"Tom Ogilvy" wrote in message ...
=if(subtotal(9,SheetB!F2:F3000)<Sum(SheetB!F2:F30 00),"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))

--
Regards,
Tom Ogilvy