Automatic Sort using a formula

Hi All

Need some help please...

I have two columns which I need to be able to sort automatically without selecting the data, copy and pasting it and then sorting it manually. Can this be done with a formula?

The customer names are in column D and the ranking field is in column E on my "Summary" sheet. Can it be set up so that the last row is found e.g.

Please Login or Register  to view this content.

I have attached an example file - I would need the formulas to be placed in the yellow coloured fields.

Hi

Cell Y4 =LARGE($E$4:$E$23,ROWS($1:1)) Then copy down

Cell X4 =INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=Y4,ROW($E$4:$E$23)-MIN(ROW($E$4:$E$23))+1),COUNTIF($Y$4:Y4,Y4))) Control+Shift+Enter.Not Enter. Then copy down.

Top 5
Cell AD4 =LARGE($E$4:$E$23,ROWS($1:1)) Then copy down

Cell AC4 =INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=Y4,ROW($E$4:$E$23)-MIN(ROW($E$4:$E$23))+1),COUNTIF($Y$4:Y4,Y4))) Control+Shift+Enter.Not Enter. Then copy down.

Bottom 5
This not easy with bottom 5.
Get bottom without 0

Cell AD18
=MIN(IF(($Y:Y>0),$Y:Y)) Control+Shift+Enter.Not Enter.

It long time I did bottom 3 got file in my computer some where.

Get back to you for this one.

Find the file.

I look at Peter_UK

It same the formula as Peter_UK for bottom 5 =INDEX(Y$4:Y$23,COUNTIF(Y$4:Y$23,"<>0")-5+ROWS(A$1:A1))

Please click on attachment