How can a formula consider and act on the last 6 items in a column where a
new item is added to the next blank cell each day. I want to keep all the
old records.

Using Win XP and Excel 2002.

Thanks in advance.

Barney