Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Associate values in worksheet??
Working with data listing stats associated with individuals that belong to
groups, i.e., individuals A, B, C belong to group X. I have data on the individuals but they are not placed in groups. Other than manually adding a column or field to each identity, is there a better way to use Excel to do this, i.e., if I build a table of group associations, can I do something like a "Find and Replace," for example, "Find and put this groupname in the adjacent cell?" Is there a better way to accomplish this? Thanks!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Associate values in worksheet??
If you build up a table of associations somewhere (eg from X1 onwards)
like this: Name Group A X B X C X D Y E Y and so on, then you can use the VLOOKUP function like this: =VLOOKUP($A1,X:Y,2,0) assuming A1 is the cell where the name is. You can copy this down to pick up the Groups for all Names. Hope this helps. Pete On Jul 4, 2:16*pm, Jon M wrote: Working with data listing stats associated with individuals that belong to groups, i.e., individuals A, B, C belong to group X. I have data on the individuals but they are not placed in groups. Other than manually adding a column or field to each identity, is there a better way to use Excel to do this, i.e., if I build a table of group associations, can I do something like a "Find and Replace," for example, "Find and put this groupname in the adjacent cell?" Is there a better way to accomplish this? Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Associate Data Across Rows | Excel Discussion (Misc queries) | |||
How can I associate a formula with Checkboxes | Excel Discussion (Misc queries) | |||
ASSOCIATE number TO VALUE | Excel Discussion (Misc queries) | |||
associate color | Excel Discussion (Misc queries) | |||
Associate name with email | Excel Discussion (Misc queries) |