Solved: Excel Formulas based on Lowest cost

[Holland]

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]

1. Use conditional formatting with a ormula of

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

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

[Holland]

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,0))[/quote]

[Bob Phillips]

.

[Holland]

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]

So what is my example not doing that it should. It reproduced exactly what you showed.

[Holland]

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]

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]

I truly apologize, works amazing, THANK YOU!!!

Holland