If Statement Help

M

MJSlattery

=IF B# = C#, TRUE VALUE, FALSE VALUE

With that said how do I retain the True values so they can be utilize
after the condition no longer applies, i.e., it is now false.

I am using this in a quary of an array that is constantely changing bu
want to capture the data when the condition is true.

Any help will be greatly appriciated.

Thanks,

Michae
 
J

JulieD

Hi

you'll need code for this to basically do a paste special when the condition
is true ...then, of course, you'll "lose" the formulas in the cell - or i
guess the information could be pasted special to another location.

if you'ld like to go down this path, please reply with the ranges of the
data and where you want the "true" values to go.

Cheers
JulieD
 
Top