how to group data in excel
hi everyone. Got one big question.
here goes:
how can I group data in excel, from one speadsheet that acts as data column then putting the result to other spreadsheet. For example,
spreadsheet 1: one column there contains "developer' or "designer"
spreadsheet2: must contain all the names which are tagged in spreadsheet1 as "developer"
spreadsheet3" must contain all the names which are tagged in spreadheet1 as "designer"...
guys.. help.. I'm just starting to learn excel=)