Found your web while browsing for help with an Excel formula, or combination that I was trying to make work. Maybe you can help me, maybe you can’t. Let’s say I need cell C38 to pick from range C10:C30 all values of “5”. When it finds all these “5” values, I need it to pick the highest value in cell range D10:D30 that are in same row as the C column “5” value, even if more than one are equal values, and put this value in cell C38. I’ve been trying to combine LARGE, SUMIF,COUNTIF formulas, but cannot get the right syntax or combination. Is this some kind of nested function? I am not too advanced on Excel, but am learning. I appreciate any help you can provide.