View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon M Jon M is offline
external usenet poster
 
Posts: 24
Default 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!!!