[Faith]

Originally Posted by Joe Ross

Here is one example on how to do that: http://www.chiefdelphi.com/forums/pa...le&paperid=487 Karthik used the OFFSET and MATCH functions.

Autofilter works great as long as you only displaying the data. I haven't figured out how to do calculations on the just the autofiltered data, though.

Thankyou .

I'll look into that. It would convenient to have two ways to view the data, alone and in comparison.