How to sort multiple rows from left to right?

[crimmo]

I have a table which has 10 columns, a = name, b-e = Address 1,2,3,4, f-j = date of call 1,2,3,4,5. Ideally column f should show the date of the latest call, going down the row to j from newest to oldest.

So one record will have the name of someone, their address and the dates of all calls made to them, there maybe 0 calls, up to 5. However the original data was entered haphazardly so that the dates are not in sequence. The newest date maybe in column h, the oldest in column f etc.

I need to resort the information in these rows so that the newsiest dates are put into f etc.

I can do this on a row by row basis by amending the sort function to read left to right but with over 2,000 records this is not practical. If I highlight multiple rows it sorts them based on the first row, which means only the first row moves and none of the data in the other rows move.

Does anyone have a solution to this?

Thanks

[Pete_UK]

Put this formula in K2 (assuming your data starts on row 2):

=LARGE($F2:$J2,COLUMNS($A$1:A$1))

then copy this across to O2. Then copy K2:O2 down as far as necessary (row 2000 ?). Then fix the values in columns K to O, then delete columns F to J.

Hope this helps.

Pete

[crimmo]

Hi Pete

That is a beautiful solution, thanks. I am still not sure how it works but it does.

[Pete_UK]

Glad to hear that, crimmo - thanks for feeding back.

Perhaps you can mark the thread as Solved (the FAQ describes how to).

Also, you might like to click on the "star" icon in the bottom left corner of a post that you have found helpful, to pass on your thanks more directly.

Pete