Thanks Gord...I will give it a try...but for my purposes, Ron Rosenfeld gave
me 2 solutions which suffice for my applicqtion...I need a formula rather
than a filter as I will be using the formula in SAP BW to return a specific
report...many thanks for repsonding...all inputs are value add...you learn
something new with each input.

"Gord Dibben" wrote:

Not true that filters fail on the 1000th row.

The autofilter drowdown list shows only 1000 items, but you can work around that
by using customcontains or see Debra Dalgleish's site for further refinement.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP


On Sun, 26 Aug 2007 02:46:10 -0700, Abdullah Kajee
wrote:

Thanks for responding Tevuna...your approach works as well...I just needed a
statement that I could use for managing more than 1000 line situations given
that EXCEL filters fail on the 1000th line.