| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find an exact number in a different sheet and use the cell containing the number to output information
i have two sheets. on one sheet i have a column of about 100 team
numbers ranging in varying intervals from 1 to 1676. the other sheet looks like this: (cell columns separated by - ) [team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ... [team number 1] - [team 1 stat] - [team 1 stat] - [team 1 stat] ... [team number 4] - [team 4 stat] - [team 4 stat] - [team 4 stat] ... [team number 6] - [team 6 stat] - [team 6 stat] - [team 6 stat] ... [team number 2] - [team 2 stat] - [team 2 stat] - [team 2 stat] ... Note that team 6 appears in two locations. i need to take each team number from my first sheet and find it in the other sheet with all the stats so that i can export averages or totals to the sheet with only the team numbers. my problem is that i have a list of team numbers, but i don't know what order they will appear in the stat sheet, because the matchups are random. How can i find the team in the stat list and export the stats to the team list? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| an exact number if a number is less than | Excel Worksheet Functions | |||
| Search A Cell for Certain Letters Then Output a Number | Excel Discussion (Misc queries) | |||
| Code using A sheet to find a number | Excel Discussion (Misc queries) | |||
| look for the exact number | Excel Discussion (Misc queries) | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
Threaded Mode
