Yes the auto filter works for the blanks but I can't figure out how to remove
the rows with the $ amounts. Any ideas.

"Dave Peterson" wrote:

Didn't the autofilter technique work?

falcios wrote:

This is how the spreadsheet looks now:

TEST123 $100
$100

TEST124 $200
$200

TEST125 $300
$300

How do I remove the dollar amounts rows below the text.

"Dave Peterson" wrote:

Convert column B to values
Select column B
edit|copy
edit|paste special|values

Now apply Data|Filter|autofilter to that column
Filter to show the cells that look blank
Delete those visible rows

Then data|filter|autofilter (to remove that filter)



falcios wrote:

Thanks Dave it worked.

Sorry but I have another question. Now I have duplicate numbers in my
worksheet. How I do remove the rows with the numbers under the text starting
at A2.

Thanks.

"Dave Peterson" wrote:

Sigh.

Put this in B1:
=IF(ISNUMBER(A2),A2,"")


Dave Peterson wrote:

Oops, put this in A1:
=IF(ISNUMBER(A2),A2,"")

falcios wrote:

Thanks Bob

I copied the function on B2 and I got an error.
I am not familiar with this function. If my text starts in cell A1 what
should the function line read.

"Bob Phillips" wrote:

In B2, add

=IF(ISNUMBER(A3,A3,"")

and copy down.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"falcios" wrote in message
...
Sample text

TEST123
$100

TEST124
$200

TEST125
$300

How can I put the dollar amount values in a separate column [column b] on
the same line as text.

Thanks






--

Dave Peterson

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson