Forum Discussion
How do I extract data from one sheet to another, depending on a numerical ranking system?
Hey all, I've got a screenshot below to illustrate what I'm working with. But here's the situation. On the left-hand window (step three), I have a series with a 1-5 ranking system in the next col...
aspireworks You'll be much better off if you can structure your data in a flat-file (think database) type structure, and keep all your entries on one sheet:
Name | Trait #1 | Trait #2 | Trait 3
From there you can use PivotTables to summarize. As you add/remove data, just refresh the PivotTables to see the newest updates.
HTH