| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Match Data usign criteria from 3 columns?
Assume that the first column is "A" and continues in order. I need to match information of vehicles that have the same VIN8+10, EqCd, and Region #. The result would provide a number of Matches by Region, A VIN8+10 and the average proceeds of the matched VIN8+10. The result would look something like this: VIN8+10: 1FTDF15YS # Matches: 6 Avg. Prcd.: $1 Mwelanetz View Public Profile Send a private message to Mwelanetz Find More Posts by Mwelanetz Add Mwelanetz to Your Contacts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Match a value to multple criteria both in rows and columns | Excel Worksheet Functions | |||
| match multiple criteria in both rows and columns | Excel Worksheet Functions | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
| Problem with criteria when usign worksheetfunction | Excel Programming | |||
Linear Mode
