Sorting

[Rich Shaw]

I AM TRYING TO ADD COLUMN “F” TO MY SPREADSHEET TO RECORD “BEST”RANK (COLUMN A) ACHIEVED AFTER SORTING. I SORT COLUMNS C-E, SORT BY MONEY, HIGHESTTO SMALLEST AS THE AMOUNT IN COLUMN D CHANGES.


[TABLE="width: 479"]
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]THIS WEEK[/TD]
[TD] +/-[/TD]
[TD]NAME[/TD]
[TD]MONEY[/TD]
[TD]LAST[/TD]
[TD]BEST[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]A[/TD]
[TD]$100[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]F[/TD]
[TD]$90[/TD]
[TD]10[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]-2[/TD]
[TD]I[/TD]
[TD]$80[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]-2[/TD]
[TD]C[/TD]
[TD]$70[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]-2[/TD]
[TD]E[/TD]
[TD]$60[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD]-2[/TD]
[TD]D[/TD]
[TD]$50[/TD]
[TD]4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD]-2[/TD]
[TD]B[/TD]
[TD]$40[/TD]
[TD]5[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD]-1[/TD]
[TD]J[/TD]
[TD]$30[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9[/TD]
[TD]-1[/TD]
[TD]H[/TD]
[TD]$20[/TD]
[TD]8[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]-1[/TD]
[TD]G[/TD]
[TD]$10[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

Thank you
Rich

 

[mrshl9898]

so you want F to be fixed, row 2 = 1, row 3 = 2 etc?

=ROW(A2)-1

 

[Rich Shaw]

[TABLE="width: 407"]
<tbody>[TR]
[TD] A [/TD]
[TD] B[/TD]
[TD] C [/TD]
[TD] D[/TD]
[TD] E [/TD]
[TD] F[/TD]
[/TR]
[TR]
[TD]PLACE[/TD]
[TD] +/-[/TD]
[TD]NAME[/TD]
[TD]MONEY[/TD]
[TD]LAST[/TD]
[TD]BEST[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]AL[/TD]
[TD]$100[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[TD]BOB[/TD]
[TD]$90[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[TD]CHARLES[/TD]
[TD]$80[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0[/TD]
[TD]DALE[/TD]
[TD]$70[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0[/TD]
[TD]EVAN[/TD]
[TD]$60[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0[/TD]
[TD]FRAN[/TD]
[TD]$50[/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0[/TD]
[TD]GEORGE[/TD]
[TD]$40[/TD]
[TD]7[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0[/TD]
[TD]HAL[/TD]
[TD]$30[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]0[/TD]
[TD]JOHN[/TD]
[TD]$20[/TD]
[TD]9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0[/TD]
[TD]RICH[/TD]
[TD]$10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

I WANT COLUMN F TO RECORD THE LOWEST NUMBER EVER ATTAINED (COLUMN A) AFTER MULTIPLE SORTS. I SORT WHEN THE VALUES IN COLUMN “D” CHANGE. SORTING OCCURS C-F (NOT C-E AS PREVIOUS STATED), BY COLUMN “D”, SORT ON “CELL VALUES”, ORDER “LARGEST TO SMALLEST”. THANKS AGAIN!!!!

 

[mrshl9898]

Not quite following sorry, having 3 columns with identical vales isn't helping there.

If you could show a before, current after and what you want the after to look like i'm sure there'll be an easy solution.

 

[Rich Shaw]

I figured it out! I would of got back to you sooner but I have been implementing this in my program. Thanks for your attention to this matter!!!

Rich