now that I think about it, this is much more complicated. I have
multiple "value" columns for different dates. And I need to pick the
highest 32 items that meet the criteria for each date, but none of the
items can be used twice. So an additional criteria is that none of the
32 items could have been used in the previous column. Bleh! I'll
probably have to do this manually.


--
QuantumPion
------------------------------------------------------------------------
QuantumPion's Profile: http://www.excelforum.com/member.php...o&userid=23991
View this thread: http://www.excelforum.com/showthread...hreadid=376101