Question to the smart people here to help me with pivot tables.. I appreciate it.

[gorhamsj]

Hi... I am doing a problem for work and i dont know how to solve it.
it is a problem where we have days in one column and we have requests in the other... and using a pivot table or something I need to find out what are the three conseccutive ddays to find the highest request numbers...
so it could be day 1,2,3 or day 2,3,4 etc...

Date	Week	Comp	Eyes	Requests	Zeros	Avail Drivers	Hourly
01/01/2014	Thursday	1	5	5	1	3	20
02/01/2014	Friday	2	15	21	6	6	35
03/01/2014	Saterday	3	25	37	11	9	50
04/01/2014	Sunday	4	35	53	16	12	65
05/01/2014	Monday	5	45	69	21	15	80

<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

Thanks!!!!

 

[oldbrewer]

Date	Week	Comp	Eyes	Requests	Zeros	Avail Drivers	Hourly		helper
01/01/2014	Thursday	1	5	5	1	3	20
02/01/2014	Friday	2	15	21	6	6	35
03/01/2014	Saterday	3	25	37	11	9	50		63
04/01/2014	Sunday	4	35	53	16	12	65		111
05/01/2014	Monday	5	45	69	21	15	80		159
			159 is biggest so sat sun mon 3,4,and 5 jan
			there must be more to it !!!

<colgroup><col><col span="10"></colgroup><tbody>
</tbody>

 

[oldbrewer]

Date	Week	Comp	Eyes	Requests	Zeros	Avail Drivers	Hourly		helper
01/01/2014	Thursday	1	5	5	1	3	20
02/01/2014	Friday	2	15	21	6	6	35
03/01/2014	Saterday	3	25	37	11	9	50		63
04/01/2014	Sunday	4	35	53	16	12	65		111
05/01/2014	Monday	5	45	69	21	15	80		159
06/01/2014	Tuesday			25					147
07/01/2014	Wednesday		56					150
08/01/2014	Thursday			99					180
09/01/2014	Friday			34					189
10/01/2014	Saterday			23					156
11/01/2014	Sunday			32					89
12/01/2014	Monday			25					80
13/01/2014	Tuesday			26					83
14/01/2014	Wednesday		27					78
15/01/2014	Thursday			28					81
16/01/2014	Friday			29					84
							search for biggest	189
							use offset match to find	07/01/2014
							start date of 3 day run
							formula is	=OFFSET($J$3,MATCH($J$20,$J$4:$J$17,0)-2,-9)

<colgroup><col><col span="7"><col><col><col span="3"></colgroup><tbody>
</tbody>

 

[gorhamsj]

Thanks a lot! I am trying to prepare for an interview A quick question. what is J3? and will this show you the start day of the 3 days which have the most accomululated requests? thanks... glassdoor said this:

2.1 8-10 questions are basic extraction from excel sheet but the trick is knowing some excel skills like pivot tables, e.g. what is highest completed trips in a given 24 hrs, what is the highest request in consecutive 72 hrs,

Thanks!!!!

 

[oldbrewer]

col J is the last column, J3 is the empty cell above 63 - starting from there run down the column to find $J$20 (the biggest 3 day total) and when you have found it go up 2 cells then go left 9 cells