Retrieving Data in excel

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

Guest

Hi experts,
I want to retrieve data in excel based on the resources.
I have three columns in the excel i.e. task, resource and status. Now tasks
are unique and can be assigned to multiple users and for all task status can
be either done, pending or blank.
Now I want a summary sheet where I can display the summary data. Here there
will be five columns i.e. person responsible, Total, Done, Pending and
Blanks. Now for each person responsible, there should be the values of done,
pending and blank.
Now please tell me how to do this.

Siddarth Jain
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count with 1 variable & 1 constant criteria formula 3
Making a "summary worksheet" 2
Copy Data from 1 Sheet to Another 3
How to line break in one cell via a formula to stack cell entries 7
VLOOKUP formula for multiple worksheets 4
Custom Filter loses blank rows 2
Excel MS Excel "IF" Logic Help Needed 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top