Group By and Sort

Hi all,

Hope somebody can help me. I have a excel sheet where column A list a bunch of names (sometimes the same name is listed multiple times) and column B that has a dollar amount. On the rows that have the same name listed the first one will contain a dollar amount and the subsequent rows for the same name will be 0.00 or blank. I need to sort the sheet high to low dollar but with the names staying together.
Can somebody assist in helping me accomplish this?
I'm using Excel 2010

Thanks

Hi
Excel can add layers to your sort, so sort by column A (names) then by column B (values) should do the trick, unless you don't want the names alphabetically sorted

on the data tab select tools > sort and click add level to add col B

it should do - unless the names are not identical or you don't want them in alphabetical order
you don't do two separate sorts, it is one sort on names first then values, like this:
Capture.PNG
if this doesn't work, can you give a bit more detail on what your sort returns and how it differs from what you want?

ah - sorry, re-read the question and you're right!