Keep text filter away numbers

[KH_GS]

Hi

What formula would be good for filtering away cells that contain only numbers?

Also
Autofilter does custom take functions?
Advance filter does criteria take functions in the same manner?

[Max]

"KH_GS" wrote:
> What formula would be good for filtering away cells
> that contain only numbers?

One way ..

Assume source data in col A, from row1 down

Put in B1:
=IF(ISERROR(SMALL(C:C,ROW(A1))),"",
INDEX(A:A,MATCH(SMALL(C:C,ROW(A1)),C:C,0)))

Put in C1: =IF(A1="","",IF(ISNUMBER(A1),"",ROW()))

Select B1:C1, fill down until the last row of data in col A

Col B should return the required results,
all neatly bunched at the top

And if there's the possibility of "text" numbers within col A
and these are to be treated as numbers (i.e. to be omitted)
then we could put instead in C1:
=IF(A1="","",IF(ISNUMBER(A1+0),"",ROW()))

(Formula in col B unchanged)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---