Maybe a Range Formula?

[smarch]

I have a list of name in column A, a list of numbers in column B to start with. In week 1, I will be entering numbers into column C and I need a formulas to tell me the name (column A) of the person who increased their numbers the most (B2 compared to C2 for example).

Thanks!

 

[svendiamond]

I would just call column D "difference" and then find the largest difference and match it up with the name.


=INDEX(A1:A10,MATCH(MAX(D1:D10),D1:D10,0))

 

[AhoyNC]

If you won't have any duplicates then Svendiamond formula.
If you could have more than 1 person with the same difference then:

Copy formula down.
NOTE: This is an array formula and must be entered with

Excel Workbook
	A	B	C	D	E
1	Name				Names
2	Name1	14	15		Name2
3	Name2	30	55		Name5
4	Name3	19	38
5	Name4	11	26
6	Name5	13	38
7	Name6	14	28
8	Name7	15	28
CTRL-SHIFT-ENTER.