Excel Lists

I had a spreadsheet with several columns
J - a person who will do the task
E - an estimate of time to perform something
K - the phase that the task is going to do something
L - column l was hidden and contained values like = j1 & k1 - it was used for lookup of how much a person was working on a specific task.

I wanted to summerize the tasks to come up with

  1. who is working on the project.
  2. at which phase is that person needed for that project
Read More