#1   Report Post  
Old December 13th 17, 05:40 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Jul 2012
Posts: 17
Default Lok up Formula

I have the following data that I need a formula written for. Any help would be appreciated. Thanks.

In A6 through A17 I have people's names
In S6 through S17 I have a value for each person
In cell S30 I have the average of these values

Ultimately I would like to have a conditional formula to highlight in yellow the average of the range S6 though S17. I was able to highlight green the top and red the bottom through conditional formatting. I'm not sure how to get the average. To make it more difficult, the average # won't always equal what the average # actually is. Therefore, if getting a conditional formula to highlight the closest to the average number isn't possible, then I would like a formula in cell S27 to look up the names in A6 through A17 to look up each persons value in S6 through S17 and give me whoever is the closest to the average #.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula autofill to cells below formula arguments are cell areas in different columns [email protected] Excel Discussion (Misc queries) 1 September 7th 12 09:15 PM
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro [email protected] Excel Programming 1 July 20th 06 07:58 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM

All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017