What do you mean by filter by criteria, what kind of filter are you applying,
advanced or autofilter, if advanced you would need a criteria like

=EXACT(A5,"X")

so if you put that in H2 you would use

$H$1:$H$2

as criteria with H1 blank and A5 would be the first cell with data in column A

if you use autofilter you would need a help column and same formula

=EXACT(A5,"X"), copy down then filter on TRUE

"X" can be replaced in both formulas with a cell where you put the criteria


For what it's worth next version of Excel will allow some more filterng
options like colour etc


Regards,

Peo Sjoblom


"kk122" wrote:


No help there. I need to filter the list in place based on criteria in
colA. it would also be nice to filter by format as well. That would
give me multiple stages for each character. For example...
Stage A could be broken up into A, *A*, -A-, a, *a*, -a-.
It would still all sort as "A" but i could filter by each stage of A or
all BOLD stages of A, B, and C.


--
kk122
------------------------------------------------------------------------
kk122's Profile: http://www.excelforum.com/member.php...o&userid=31074
View this thread: http://www.excelforum.com/showthread...hreadid=542270