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

Any specific day in a date Range

L

Lrod

New Member
I have a worksheet with a month data. I need to get a data for only specific day (monday,tuesday, etc) on that date range and display all the rows on that day.

If my date range has 6 mondays, then my new spreadhseet has to show only those 6 mondays information, that way i can create a chart for that new data.


I'm a newbie to excel so I can see i can use vlookup for it but don't know how to get only a specific day in that date range.


Please help, have to create an analysis report.

Thanks in advance for the help.
 
Lrod

You will need to add a couple of helper columns and then setup a Report to extract the data with help from the helper columns


The first helper column will be a simple, If weekday = some value, Row No else 0

eg: =IF(WEEKDAY(A8)=2,ROW()/10000,0)


The second helper column will be a rank of the first helper column

eg: =Rank(value, range,0)


Now you can use the values in teh rank to extract the data using an index/match combo


Clear as mud?


I have put an example of this in work at: http://rapidshare.com/files/430489122/Sorter__Dates_.xls
 
You must log in or register to reply here.
Back
Top