| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extracting data with multiple criteria and values
I have a spreadsheet that I am working on for a game I am playing. I have information from two different sports team rosters. As such, all of the players show twice on the raw data sheet. I would like to separate them and their stats into separate team sheets and only have the highest value for each stat show up.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting data with multiple criteria and values
I have a spreadsheet that I am working on for a game I am playing. I
have information from two different sports team rosters. As such, all of the players show twice on the raw data sheet. I would like to separate them and their stats into separate team sheets and only have the highest value for each stat show up. Okay.., you definitely need to clarify some stuff here! How does players from "two different" team rosters end up as being duplicated? Are the players of team1 also on team2? How did the data for "two different" teams get on the same sheet in the 1st place when you want to separate this to 2 sheets? Why could the data not be put on separate team sheets in the 1st place? Are you looking for a cell formula solution or a VBA solution? How is the data arranged? What 'field' is the criteria for determining "highest value"? Would simple Conditional Formatting serve your purpose, or are you shooting for something more complicated/convoluted that will require heavier ongoing maintenance? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting data with multiple criteria and values
I forgot to aks...
Your subject lines states "multiple criteria" and so what other criteria is there besides "highest value" from each set of stats? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting data with multiple criteria and values
Typo...
I forgot to ask... Your subject lines states "multiple criteria" and so what other criteria is there besides "highest value" from each set of stats? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting data to another sheet using multiple criteria | Excel Discussion (Misc queries) | |||
| Extracting mixed values in single column to multiple colums | Excel Programming | |||
| extracting data by a criteria ? IF this , then That? | New Users to Excel | |||
| Extracting records that meet multiple criteria | Excel Programming | |||
| Extracting values from multiple EXCEL spreadsheets into one | Excel Programming | |||
Linear Mode
