PDA

View Full Version : [SOLVED] AutoFilter criteria help



newbie101
05-07-2014, 11:54 PM
Hi Folks,

Is it possible to use one criteria on multiple fields, for example if one column has deposits and another has withdrawals I want the criteria to be: deposits-withdrawals>0

If it isn't possible is there a quick alternative?

Thanks in advance.

Bob Phillips
05-08-2014, 01:43 AM
You would need to create a helper column with that amount and filter that.

newbie101
05-08-2014, 02:21 AM
I was trying to avoid that. But if it isn't possible otherwise, that's what I'll do.