software

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?--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=527915quot;KH_GSquot; wrote:
gt; What formula would be good for filtering away cells
gt; 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))),quot;quot;,
INDEX(A:A,MATCH(SMALL(C:C,ROW(A1)),C:C,0)))

Put in C1: =IF(A1=quot;quot;,quot;quot;,IF(ISNUMBER(A1),quot;quot;,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 quot;textquot; 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=quot;quot;,quot;quot;,IF(ISNUMBER(A1 0),quot;quot;,ROW()))

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