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.

	A	B	C	D	E	F
1	THIS WEEK	+/-	NAME	MONEY	LAST	BEST
2	1	5	A	$100	6	1
3	2	8	F	$90	10	2
4	3	-2	I	$80	1	3
5	4	-2	C	$70	2	4
6	5	-2	E	$60	3	5
7	6	-2	D	$50	4	6
8	7	-2	B	$40	5	7
9	8	-1	J	$30	7	8
10	9	-1	H	$20	8	9
11	10	-1	G	$10	9	10

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

Thank you
Rich

 

[mrshl9898]

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

=ROW(A2)-1

 

[Rich Shaw]

A	B	C	D	E	F
PLACE	+/-	NAME	MONEY	LAST	BEST
1	0	AL	$100	1	1
2	0	BOB	$90	2	2
3	0	CHARLES	$80	3	3
4	0	DALE	$70	4	4
5	0	EVAN	$60	5	5
6	0	FRAN	$50	6	6
7	0	GEORGE	$40	7	7
8	0	HAL	$30	8	8
9	0	JOHN	$20	9	9
10	0	RICH	$10	10	10

<tbody>
</tbody>

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