| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching data in two columns
Hello,
I need help with finding the last game that two teams played each other, either home or away. This is to decide who will have the home town advantage in the semi-finals. What formula would be able to find the last time two teams played each other in a season (either home (Team A vs Team B) or away (Team B v Team A)), and extract the score for the last game for both teams? Thank you and best regards Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching 2 columns of data | Excel Discussion (Misc queries) | |||
| Matching two columns and their data | Excel Worksheet Functions | |||
| Matching Data in Columns | Excel Worksheet Functions | |||
| How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
| Matching data in columns | Excel Discussion (Misc queries) | |||
Threaded Mode
