Re-arrange rows by column

Originally Posted by excel_newb2

I have a column of salesman and their various sales, 1 per row. That is, each row is devoted to one salesman, and a row for each salesman exists the number of times he has made a sale.

I would like to get a running average of the total amount sold by each salesman. I would like to take from the column of salesman and only take the last two sales they have made, and form a new spreadsheet with this information.

So, if I had the following salesmen and wanted only the last 2 sales from each:

A1: John
A2: Bob
A3: Bill
A4: Bob
A5: Bill
A6: John
A7: John
A8: Bob

This would result:

A1: Bob
A2: Bob
A3: John
A4: John
A5: Bill
A6: Bill

(complete with sales info extending to the right). The main point, and the one that has me hung up, is that I would like to rearrange the rows starting with the bottom of the column of names, so that I have a running average of the two MOST RECENT sales.

Any help with this would be greatly appreciated. Thanks very much.

In a spare column, in (say) D1 put

=COUNTIF(A1:A$9999,A1)

and formula fill that to the end of your data, then apply Data, Filter and Custom filter on that column =1 OR =2

note, the display can be copied to a new area or sheet for sorting etc if required.

hth
---