Sort on FieldA , then Filter the same.
Pivottable or subtotal makes summaries only.
--
jamex
------------------------------------------------------------------------
jamex's Profile:
http://www.excelforum.com/member.php...o&userid=32243
View this thread:
http://www.excelforum.com/showthread...hreadid=521638