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
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