How do I layer info in Excel. Have large amts of data to sort.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Creating spreadsheet. Have large amts of data. For example, could have 937
names under one name, then 609 names under that 937 will have several layers
of info with it.
Ex. Column with "Person1". Under "Person1" I have 937 "Persons2". Under
each of the "Persons2" several data like dates, Y/N, location, training
scheduled, etc.
More of a "layering" technique.
Any help is appreciated!
 
Think about aranging your data going across columns, so you have your
Person1 column (eg for a manager?), and that first name is repeated in
937 rows. Against each of those entries you would have columns for
Person2, date, y/n, location etc. Then the next block of data would
have a different name for Person1, and his/her subsidiary data in the
adjacent columns.

Hope this helps.

Pete
 
Pete's right.....it's usually better to lay out the data in rows, like he
described, and then use Excel's AutoFilter or AdvancedFilter for viewing or
reporting.

Vaya con Dios,
Chuck, CABGz3
 
Back
Top