turkey leftovers for first elegant solution ..
col A col B
-------------------
RR 450
SS 350
TT 250
TT 300
RR 450
RR 400
SS 450
TT 500
what i need is formula out in column C that will pick off the largest x
values in colunn B based on criteria A.
e.g. sumif (large("TT"s, 2) = 800
having trouble isolating the 'TTs' in separate array to put in Large
function - want to keep entire table in this order, as formula will be
copied down and range will be based on dates in another column
TIA
Bookmarks