| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a text based count with criteria from two differnt workbook
My master data sheet has multiple instances relateing to when a product was
ordered. I need to create an order count in a second workbook by verifing against multiple cells. Below is a short example... ** Master Data Course Type Date Salad apple 15-Mar Salad apple 17-Mar Salad apple 17-Mar Salad pear 15-Mar Salad pear 1-Apr Salad walnut 10-Mar Dessert apple 12-Mar Dessert banana 14-Mar Dessert banana 14-Mar Dessert banana 2-Apr Dessert mango 19-Mar Dessert mango 22-Mar ** Reporting Data Course Type Order Count Salad apple Salad pear Salad walnut Dessert apple Dessert banana Dessert mango The master data sheet I am working with has more than 14000 lines and more than 500 types, so entering in each type/course would be extremely cumbersome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on two different criteria | Excel Worksheet Functions | |||
| Count text cells based on two criteria | Excel Worksheet Functions | |||
| I want formula for multiple criteria using ih differnt column | Excel Worksheet Functions | |||
| Insert text from another workbook based on criteria | Excel Worksheet Functions | |||
| count cells,containing text, based on more than one criteria? | Excel Worksheet Functions | |||
Threaded Mode
