Sorting for blank cells.

G

Guest

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

..
 
G

Gord Dibben

Your description is a little vague for me.

Your Subject says "Sorting" but sort what?

Would you explain what is "separate", please.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting for Blank Cells 2
VB code 5
excel "IF" formula... if this possible ??? 0
Min functions 5
max value 1
Select longest call duration from 2 cells and place in another cel 3
Removing spaces in numerous cells 3
Sorting Help 1

Top