Rank & Highlight Lowest toHighest (Costs)

[MyCon]

Hi,

I have a table that represents 11 vendor services & their positions.

I'm looking to highlight from lowest to highest team costs while ignoring 0s or $0.00 rates or costs.

As you will see in my table example, in Row 19, I have sum total team costs with an "X" underneath. I wish to highlight (using conditional formatting), in row 19, lowest to highest team costs & rank in some way, underneath its costs.

I'm more concerned with costs than team member totals but may want both

How can this be done within main table?

In my Table 2 example, I did manage individual positions bill rate but not sure how to modify function to ignore 0s or $0.00 rates.

Change Excel extension from, ".doc" to ".xlsm"

Thanks

 

[MyCon]

Hi,

Can anyone assist with at least the first part of my objectives?

Thank you for your assistance.

 

[Khalid NGO]

Hi,

Your question is not 100% clear to me, it would helped if you have included the expected results.

However, based on my understanding, can you check these?

{array formula} in C28:
=MIN(IF((C10:X10>0)*($C$20:$X$20="X"),C10:X10))

(regular formula) in D28:
=INDEX($C$5:$X$5,,MATCH(C28,C10:X10,0)-1)

Copy down both.

{array formula} in J28:
=IFERROR(SMALL(IF(($C10:$X10>0)*($C$20:$X$20="X"),$C10:$X10),J$27),"")

Copy across and down.

{array formula needs to be entered with the key combination of
Ctrl+Shift+Enter instead of just enter}

Regards,