A
Aoife
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?
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?