• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Using Excel to understand if I have enough resource

    Hiya Hui Sorry I didnt make my data clear. The 1 is just an indicator that they are trained in it, but it could be an X or a Y, its not hugely relevant but what ever will fit a formula I can put in there. The time on the left is the incoming volume for that task each day. I can add a column...
  2. D

    Using Excel to understand if I have enough resource

    Hi I have uploaded a version of what I am thinking of making here https://www.dropbox.com/s/955iyb9yq7nd289/RESOURCE%20SPREADSHEET.xls What I would like to do is the insert a calculation next to their names, in B16:B22. For example, for Lucy it shows that she is trained in tasks 1,4 & 10...
  3. D

    How to extract text list from data table

    Hi SirJB7, thanks for your post. I did spend a good few hours searching words that I thought might be relevant, but I am not entirely skilled in the exact phrases that come with Excel. I certainly would never have come up with formulas like that! I havent heard of an array formula so I will do...
  4. D

    Using Excel to understand if I have enough resource

    Hi I am trying to build a database that will tell me if I have enough resource to cover a number of different tasks. The numbers stack up as this. I have a team of 20 people who are trained in anything from 2 to 50 activities. Each activity takes a different amount of time, and has different...
  5. D

    Hello .. Introduce yourself

    Hi Im not new to Excel but I am self taught, and this site is helping hugely! I am moving into the heady world of being a BA, and the department I work in has over 300 different activities to do, between 100 staff, and across 8 work types, so keeping on top of what theyre doing and where we...
  6. D

    How to extract text list from data table

    Hi Thanks for replying. Ill play about with the Pivot function again. It does get me a version of what I wanted, I think I may then need to do some work on removing the blank columns where a particular person isnt trained in a task for example. Thanks again for your quick reply
  7. D

    How to extract text list from data table

    Hi I apologise in advance if this question has been answered elsewhere. I have been searching the site for 3 hours and attempting some of the options I have come across, but I cant quite get it to do what I want. I have a table of MI that I will need to update monthly to tell me if I have...
Back
Top