1) Data is contained in a workbook called Template New 2006
F4:BE4 contains date references; breaking the full year down into
weeks.
F31:BE31 contains £ returns from customers;some cells are left blank.

New Workbook is being created to track these returns against the date
of the return.

Objective: How can I get Excel to return the average £ of the five most
recent returns, ignoring any blank cells?

2) One workbook; two worksheets.
sheet 2 contains 3 columns; column a = id #, column b = date, column c
= any comments on the customer. Note: there are usually several notes
per customer.

In sheet 1 I would like to show the most *recent* comment in column c
for a specified id # (in this case example 004)

Can anyone help?


--
Aoife
------------------------------------------------------------------------
Aoife's Profile: http://www.excelforum.com/member.php...o&userid=33191
View this thread: http://www.excelforum.com/showthread...hreadid=531306