Extract specific data from a table

**Kristof088** · 12-06-2012, 10:01 PM

Dear forum,

I have a table filled with assembled data per day. I would like to find the most efficient way to copy the weekends data in a seperate table to prepare a graph focusing on WE only.

Please mind that as the days pass by, the changes automatically apply in the table... I added the table.
I would really appreciate your help since I've been stuck on this assignment for some days.

**FDibbins** · 12-07-2012, 01:04 AM

this formula will identify the weekends for you...
=IF(WEEKDAY(C3,2)<6,"",1)

a suggestion however, would be to flip your table so that the dates go downwards rather than across the top. My reason for suggesting this is that your table is going to grow over time, and it will make things a lot easier if it grows downwards rather than sideways.

if you transpose the table as suggested, and then copy that formula down, you can filter on "1" which will give you just the w/e's...the graph will only show weekends, so no need for another table

**Kristof088** · 12-07-2012, 09:23 AM

Thank you FDibbins! You're advice is really appreciated.

**VKS** · 12-08-2012, 10:21 AM

Hello Kristof, Please check if you find attached worksheet useful. Do let me know if you want to know how to go forward with updating this table. Thanks/VKS

**Kristof088** · 12-10-2012, 09:07 PM

Well, in response to your spreadsheet, I would like to present my document again with some more info.
As you can see there is a graph in place that shows the evolution of all data over the past 30 days. The graph is constantly moving.
I'd need a similar graph which only shows the weekend data. The idea is to analyse their evolution.

What would you suggest?

thanks in advance!