Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two Problems
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
elapsed time problems | Excel Worksheet Functions | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
Pivot table problems | Excel Discussion (Misc queries) | |||
Integrity Problems in PivotTables | Excel Discussion (Misc queries) | |||
I'm getting mad - I'm having problems with EXCEL file name length | Excel Discussion (Misc queries) |