Microsoft Office Forums - View Single Post - percentage increase?

Thread: percentage increase?

View Single Post

Old

07-13-2011, 12:45 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

The percentage increase for each person will be like this:

Code:

=(C2-B2)/B2

Format each cell as %

Then to get the person with the largest percentage increase, you can use this formula:

Code:

=INDEX(A2:A4,MATCH(MAX(D2:D4),D2:D4,0))

Reply With Quote