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

export column based on specific criteria

L

losdamianos

New Member
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 chandoo.org I've managed to create some basic dashboard with sumif,and vlookup formulas.


But this for now is too complicated for me :(


any help would be greatly appreciated
 
Interesting question. However, I am not sure if I understand the data format in download workbook. so I made my own example to show how you can extract all the matching values and feed them to a chart.


Download the file from here: http://img.chandoo.org/playground/filter-matching-values.xls


Make sure you check the formulas behind names lstDates and lstRates to understand how this is set up.
 
Have a look at an example of how this can be done with formula at

http://chandoo.org/forums/topic/index-match-row-formula-error


Or If you don't like Array Formulas have a look at a method for doing it using helper cells

Example at: http://rapidshare.com/files/430489122/Sorter__Dates_.xls
 
@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, so only number of cases has to be typed ) each activity (top labels) has different speed therefore 100% of picking is not the same as 100% of putaway.

I have 4 departments, national, night freight, p&p and jwp so each employee usually works in just one department

@Hui

thanks for the topic with sandwiches, I see Im not the only one . i will try to apply same technique in my workbook.


Here is what I've done so far with help from you and guys on other forum:

http://www.mediafire.com/?dkt37ctnz1pyyfk

(look Data2)
 
You must log in or register to reply here.
Back
Top