Or Advanced Filter.
--
Brevity is the soul of wit.


"CLR" wrote:

Maybe the AutoFilter will do you..........Data Filter Autofilter

hth
Vaya con Dios,
Chuck, CABGx3



"will" wrote:

Hi,

Is there a way of listing those items that have a certain criteria - in
other words a sort of "ListIf" type command? Just as SumIf would sum the
values of items that have a certain criteria?

Many thanks for any assistance.

Mark.