I'm trying to write a formula or use filtering to get a list of uncleared
checks in a check register. The data looks like this:
21 A B C
22 Date Amount Cleared
23 xxxxx 1.98 X
24 xxxxx 2.55
25 xxxxx 3.00 X

I need to extract the information for check 124, which has not cleared.
I've tried using the IF and ISBLANK functions in an advanced filter dialgue,
but can't seem to make it work. In the criteria cell, my formula is
=IF(ISBLANK(C23),"",B23).
Thanks