PDA

View Full Version : Solved: Excel Formulas based on Lowest cost



Holland
04-27-2010, 07:51 AM
Hi there,
Been working on an Excel spread sheet trying to High-lite a set of cells based on lowest cost as well as selecting the name of the person who has the lowest cost. Sorry if it sounds confusing, please see example for a better idea of what I mean.

Also can't really use VBA if possible, was hoping to configure this with either,
If Statements, OffSet, etc, etc or what ever someone might recommend.

Thank you in advance for any suggestions and support.

Holland

Bob Phillips
04-27-2010, 09:09 AM
1. Use conditional formatting with a ormula of

=$D2=MIN($D:$D)

2. =INDEX(C:C,MATCH(MIN(D:D),D:D,0))

Holland
04-27-2010, 09:51 AM
Thank you for the quick reply, tried your formula to no avail. Attached is a clearer description of what I am after. Again I do thank you for your assistance.

Holland


quote=xld]1. Use conditional formatting with a formula of

=$D2=MIN($D:$D)

2. =INDEX(C:C,MATCH(MIN(D:D),D:D,0))[/quote]

Bob Phillips
04-27-2010, 11:46 AM
.

Holland
04-27-2010, 12:23 PM
Honestly I appreciate your help, I do and thank you for the attached spread sheet.

All I really need I hope is simple, maybe I am making it complicated, let me try again.

1. Cells B24 to L4 will have a name and a cost associated to every cell
2. Cell M 24 to have a formula listing the "Name" of the lowest cost
3. Need another formula to high-lite in yellow both the Name & Lowest Cost of the 2 cells between B24 to L24.

Thank you again,
Hope this is more detailed.

Holland

Bob Phillips
04-27-2010, 12:37 PM
So what is my example not doing that it should. It reproduced exactly what you showed.

Holland
04-27-2010, 12:55 PM
Hi agn and thx,
Your sample is not populating cells M24:M27 as my sample shows currently I am typing the Name in manually, and it is not high-lighting the Lowest Name&Cost in the rows, I am high-lighting them manually.

Thx agn,
Holland

Bob Phillips
04-27-2010, 02:09 PM
No, because as I read your spreadsheet, M24:M27 is your example results, not the actual data. I put the CF and formula in rows 1 to 5.

Holland
04-27-2010, 08:50 PM
I truly apologize, works amazing, THANK YOU!!!

Holland :friends: