|
|
#1
07-13-2011, 03:23 AM
|
|||
|
|||
percentage increase?
Hi.
I need to show who has increased the most percentage sales but not sure how to do it as I'm quite new to using office. Here's what I need to do: The first column is the name, the second is the first week the third is the 2nd eek and the fourth would be the percentage amount so: John 11,174 16,439 ??? Mark 9,032 10,343 ??? Dave 7,322 6,435 ??? Could some one help with this please? 
|
|
#2
07-13-2011, 12:45 PM
|
||||
|
||||
|
The percentage increase for each person will be like this:
Code:
=(C2-B2)/B2 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))
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| percentage on columns | 911 | Excel | 1 | 09-01-2010 09:28 AM |
| Can I auto increase numbers in a column? | compact | Word | 1 | 09-10-2009 07:16 AM |
Windows Vista 
Office 2003
Linear Mode
