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 name he will see line chart with dates and performance for specific employee.
http://www.mediafire.com/?4x0cxb388n7kydk <- here is a sample worksheet, by learning many cool tips on this site I've managed to create some basic dashboard with sumif,and vlookup formulas.
any help would be greatly appreciated
see sheet 1 ,but i wouldn't know how to use it in a chart i have created a dynamic named range called dates perhaps you could use that
Last edited by martindwilson; 11-14-2010 at 03:13 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you !!!
thats definetelly a kick start for me
basically what Im trying to create is chart with all dates and few series of KPI's (different tasks) this could easily be done using pivot table but i want to make something even more easy to use
chart will be shown in individual performance sheet showing performance across whole month (line chart)
when I finish I will share my experience and techniques
Last edited by losdamianos; 11-14-2010 at 03:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks