Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating an average based on criteria
Hope someone can help with the following:
I have a worksheet ("data") with the following details: range: A2:AO20000 column S is the country of customer column C date order placed column D data order sent column R customer column V product bought What I would like my VBA to do is take this information, and then i another sheet called "analysis" use the information typed into cell A1 customer area and A2: customer name And calculate for each product bought by the customer, the average tim between column C and column D. Note where nothing is displayed in cell A1 in "analysis" then th result of the VBA would give all customers. Help please ! Thank you, Scott -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE BASED ON 2 CRITERIA | Excel Worksheet Functions | |||
Calculating Average based on 3 filled cells from left in a row | Excel Discussion (Misc queries) | |||
average based on criteria | Excel Worksheet Functions | |||
need to average based on criteria | Excel Discussion (Misc queries) | |||
Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions |