• 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. L

    calculate time based on criteria

    Thanks, I've managed to do this using 2nd match from vlookup and helper column so I ended up with PersonA1 PersonB1 PersonA2 etc then simply vlookup formula + counta (u get the idea :) ) anyway your formula is much cleaner thanks !
  2. L

    calculate time based on criteria

    Hello I have a spreadsheet with task list A B C D E F name task desc time date time spent Each person scan his card (name, task ,desc ) time and date is calculated automaticly. Im trying to calculate time spent on each task So when Person A appear again, in...
  3. L

    export column based on specific criteria

    @chandoo your sample is not working :(, I see the idea and would be greatful to see working example, in your link I see only one list with dates and there is no source for chart :( Workbook is designed to monitor performance of each individual ( hours are fed from another input spreadsheets...
  4. L

    export column based on specific criteria

    Hello there ! my table employee, date, cases picked, rate, performance Im trying to find a way to export column which will return all dates based on specific employee. Vlookup would return just one date which is not good. Im trying to create dynamic line chart so when my boss pick up a...
  5. L

    Hello .. Introduce yourself

    Hi all, My name is Damian and I'm a data analyst in liverpool. I found this website about 3 weeks ago and since then I made HUGE progress ! I feel now that Im the boss and Excel is my slave :D not the other way.
Back
Top