Need sort to exclude blanks

[mkmed]

Hello,

I am needing help with a sort function. My columns are parts that are populated from another sheet and some orders use 2 - 3 rows and others may use 100. I have manually sorted these for quite awhile.

Now, I want to automate the sort. If I select enough rows to be more than any order will need, I won't allow me to choose largest to smallest. Choosing Z to A works, but it leaves all the blank rows as entries.

Is there a way to make the sort function ignore any blank cells(rows) and collate the data from largest to smallest (Column C) regardless of the quantity?

Thanks for any help.

Mark

 

[mkmed]

Very good guess!!! I didn't realize that mattered, but they all have formulas that are preceeded by if's to keep them blank if their dependent cell is blank. I need this to stay that way. Can we make the sort work with this new info?

Sorry for the misunderstanding.

Mark

 

[Jonmo1]

Can you make them return 0 instead of blank? Then they would go to the bottom when sorted.

 

[mkmed]

I could make them say 0, but then when I print it will print out 100+ rows of zeroes on small orders. Any other ideas?

Thanks,
Mark

 

[Jonmo1]

you can set your sheet to Not Display 0's

tools - options - view
Uncheck "Zero Values"

I'm not 100% sure that will effect the printing, but i think it would..

 

[mkmed]

Jonmo,

I would reccomend you for an award I would!!! Thanks for all the great help. I am working on another enhaancement that might be a little over my head also. I will be back!!

Thanks again,
Mark