Selecting the Lowest Rank from across columns

[broncos347]

I have a spreadsheet where I rank a series of costs across four columns what I would like to do is the input lowest cost (Rank 1) into another cell to highlight the lowest cost, in the table below I would like to show the lowest value, which in this case is in cell B7, in cell C3. Any help would be appreciated.

Book4
	B	C	D	E	F
2	Budget	£ 8,000.00
3	Winning Proposal
4	Budget variance	£ 8,000.00
5
6		A	B	C	D
7	TOTAL price	9,644.00	3,460.00	7,515.00	4,350.00
8
9	Weighting	A	B	C	D
10	40	14	40	18	32
11	20	20	20	20	20
12	20	20	20	20	15.5
13	TOTAL	54	80	58	67
14	RANKING	4	1	3	2
Sheet1

Cell Formulas
Range	Formula
C4	C4	=C2-C3
C9:F9	C9	=C6
C13:F13	C13	=SUM(C10:C12)
C14:F14	C14	=RANK(C13,$C$13:$F$13,0)

 

[Joe4]

Wouldn't you just put this formula in cell C3?

=MIN(C7:F7)

 

[broncos347]

Oh FFS why didn't I see it was that simple, thanks for helping

 

[Joe4]

You are welcome.