Excel formula please

[ashliiii]

Suppose I have a sheet as follows:

Cell A1 = 25
Cell A2 = 56
Cell A3 = 31
Cell A4 = 77
Cell A5 = 9
Cell A6 = 45

Cell B1 = large(A$1:A$6, 1)
Cell B2 = large(A$1:A$6, 2)
Cell B3 = large(A$1:A$6, 3)
Cell B4 = large(A$1:A$6, 4)
Cell B5 = large(A$1:A$6, 5)
Cell B6 = large(A$1:A$6, 6)

What is the formula in cell C1 to show the highest value is in cell A4. And when copied down, cell C2 to show the second highest value is in cell A2 etc.

C1 = A4
C2 = A2
C3 = A6 and so on.

Thank you for your time.

 

[JoeMo]

Book1
	A	B	C
1	25	77	$A$4
2	56	56	$A$2
3	31	45	$A$6
4	77	31	$A$3
5	9	25	$A$1
6	45	9	$A$5
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=LARGE($A$1:$A$6,ROW(A1))
C1:C6	C1	=ADDRESS(MATCH(B1,$A$1:$A$6,0),1,1)

 

[ashliiii]

Book1
	A	B	C
1	25	77	$A$4
2	56	56	$A$2
3	31	45	$A$6
4	77	31	$A$3
5	9	25	$A$1
6	45	9	$A$5
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=LARGE($A$1:$A$6,ROW(A1))
C1:C6	C1	=ADDRESS(MATCH(B1,$A$1:$A$6,0),1,1)

Thank you for your time, it works. Bless!.

 

[DanteAmor]

In case you have equal values in column A:

Dante Amor
	A	B	C
1	25	77	A4
2	56	56	A2
3	31	45	A6
4	77	31	A3
5	31	31	A5
6	45	25	A1
24%

Cell Formulas
Range	Formula
B1:B6	B1	=LARGE(A$1:A$6, ROW(A1))
C1:C6	C1	=ADDRESS(LARGE(($A$1:$A$6=B1)*(ROW($A$1:$A$6)),COUNTIF(B1:B$6,B1)),1,4,1)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[JoeMo]

Thank you for your time, it works. Bless!.

You are welcome - thanks for the reply.