Sort Formula multiple criteria

[disepyon]

Hello and thanks for taking time to look at my situation.

I need help figuring out my situation as this is beyond my excel knowledge.

Will try my best to explain as clearly as possible.

Here is a picture of the data that is manually entered in while im working. Because I have duplicate names or same owners owning in different group and severance had to create column column c with the formula shown to separate the duplicate names.
\1

So while I am working entering data in the data tab, I want the names from column c to automatically display and update and be sorted in a separate worksheet, pic below.
\1

The owners need to sort first by group letter a-z, then it needs to sort by severance letter a-z, then needs to sort by acres highest to lowest.

I do want any blank owners in column c showing in the result tab, however because technically those blank owners have "" in the cell due to the formula, im not sure if it can be eliminated from displaying in the results tab, so in that case I want all the cells with "" in column c of data tab to show up at the end of the owners in the result tab and not be displayed in between any names.

attached is my example.

I found this article that shows at the very end a long formula that will automatically display and update and sort names alphabetically which is nice but i need this to work for my situation.
http://trumpexcel.com/2015/02/sort-d...order-formula/


Please help, thanks

[sanram]

You can use 4 helper column for that. I have written the formulas on your sample file. Check the attachment. Hope this will help.

[disepyon]

Hey Sanram,

Much appreciation. from spending a couple of days on this, what you showed me in the example was what I kind of figured I would have to do, now things are clearer on how to go about it, thanks to you. Ill just end up hiding the helper columns after I get it working on my work template.

Thanks for the help

[sanram]

You are most welcomed. It's feeling warm that it helps.

[sanram]

Please mark your post as solved if you think that the above solution solved your problem. Also give a reputation score to the person who solved your problem.

[disepyon]

Will do. I actually rep you the other day, just tried again and telling me to spread some reputation around first.