Median for Year
try
to get the row
try
=MATCH(MEDIAN(IF(year(C:C)=2007,G:G)),G:G*(year(C: C)=2007),0)
this will select the first job with the median.
you can use index match to extract the specific info you want
if there are several the job gets a little harder.
" wrote:
How do I set up a formula that will calculate the job that produced
the median amount of revenue for each year? (Jobs are counted in the
year they were submitted.) My data is set up as below:
Columns:
A: Customer Name
B: Customer Number
C: Date Job was Submitted
D: Date Job was Returned
E: Turnaround Time
F: Associate who Completed the Job
G: Revenue from Job
Thanks in advance for your help,
Kevin
|