Sorting for Blank Cells

[TOM]

I have a spreadsheet that looks like this:

02 01 VI
$29.00

01 01 AX


01 01 OA
$10.00

I want to separate the ones without a dollar value under
the "01" or "02" cell. Can anyone offer any help?
Thanks,
Tom

 

[Frank Kabel]

Hi
one way:
Add a helper column (lets say B)
enter the following in B1
=IF(ISNUMBER(A1),"",IF(ISNUMBER(A2),"","to be filtered"))
copy this down
After this select this column B, copy it and insert it again as Value
('Edit - Paste Special'). Now do your sorting

 

[Guest]

This worked beautifully -Thanks

-----Original Message-----
Hi
one way:
Add a helper column (lets say B)
enter the following in B1
=IF(ISNUMBER(A1),"",IF(ISNUMBER(A2),"","to be filtered"))
copy this down
After this select this column B, copy it and insert it again as Value
('Edit - Paste Special'). Now do your sorting

--
Regards
Frank Kabel
Frankfurt, Germany


.