Need length of service to be averaged automatically when selecting from a drop down menu

[MrRichRod]

Hi there,

I've created a spreadsheet for my job that already gives me the LOS (length of service) of each employee. I've also created an area where you can choose the employee (by name) from a drop down menu next the assignment they are to be fulfilling that shift.

What I need help with is when I select the employee's name from the drop down menu, to have Excel automatically identify their LOS and then average that with other employee's LOS's I've selected for that shift. The result would be displayed somewhere else on the same sheet.

I'd be glad to upload anything I can to help get this where I need it, but I'm new to the forum and am not sure how to upload a sample of what I'm working with.

Thanks in advance to anyone to can help!!

 

[CWatts]

Perhaps this will work for you?

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:75px;" /><col style="width:70px;" /><col style="width:23px;" /><col style="width:50px;" /><col style="width:115px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Employees</td><td style="text-align:center; ">Hire Date</td><td > </td><td > </td><td >Three Employees</td><td style="text-align:center; ">Days</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Tim</td><td style="text-align:center; ">1/5/2001</td><td > </td><td style="text-align:right; ">1</td><td >Tim</td><td style="text-align:center; ">3751</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Jane</td><td style="text-align:center; ">8/25/2005</td><td > </td><td style="text-align:right; ">2</td><td >Sally</td><td style="text-align:center; ">497</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Sally</td><td style="text-align:center; ">12/3/2009</td><td > </td><td style="text-align:right; ">3</td><td >Steve</td><td style="text-align:center; ">1020</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Bob</td><td style="text-align:center; ">4/9/2004</td><td > </td><td > </td><td >Average Tenure:</td><td style="text-align:center; ">1756</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Steve</td><td style="text-align:center; ">6/28/2008</td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >F2</td><td >=IFERROR(TODAY<span style=' color:008000; '>()</span>-VLOOKUP<span style=' color:008000; '>(E2,$A$1:$B$6,2,FALSE)</span>,"")</td></tr><tr><td >F3</td><td >=IFERROR(TODAY<span style=' color:008000; '>()</span>-VLOOKUP<span style=' color:008000; '>(E3,$A$1:$B$6,2,FALSE)</span>,"")</td></tr><tr><td >F4</td><td >=IFERROR(TODAY<span style=' color:008000; '>()</span>-VLOOKUP<span style=' color:008000; '>(E4,$A$1:$B$6,2,FALSE)</span>,"")</td></tr><tr><td >F5</td><td >=AVERAGE(F2:F4)</td></tr></table></td></tr></table>

 

[Joe Galvan]

Hey Rich.. .check you email...