orcafriend
New Member
- Joined
- Jun 9, 2004
- Messages
- 3
Hi All.
I am new to arrays and am very excited over the usefullness of this tool.
I have a LARGE spreadsheet with 4 columns of data. There are thousands of rows covering many years of data. I have data points for each day of the month for multiple years, but here is a simplified version of the data.
date month Flow1 Flow2
1/1/2005 1 15 23
2/16/2005 2 20 30
1/1/2006 1 10 15
1/16/2006 1 8 12
2/1/2006 2 20 30
2/16/2006 2 30 45
3/1/2006 3 20 30
3/16/2006 3 8 12
4/1/2006 4 6 9
What I would like to do is to graph flow1 against flow 2 for each date in the month of January. A second graph will plot all the Febuary flows...and so on.
I can not sort by month because the date needs to stay in chronological order because of a vlookup function that gets the flow1 & 2 data based on the date.
Any thoughts?
Jim
I am new to arrays and am very excited over the usefullness of this tool.
I have a LARGE spreadsheet with 4 columns of data. There are thousands of rows covering many years of data. I have data points for each day of the month for multiple years, but here is a simplified version of the data.
date month Flow1 Flow2
1/1/2005 1 15 23
2/16/2005 2 20 30
1/1/2006 1 10 15
1/16/2006 1 8 12
2/1/2006 2 20 30
2/16/2006 2 30 45
3/1/2006 3 20 30
3/16/2006 3 8 12
4/1/2006 4 6 9
What I would like to do is to graph flow1 against flow 2 for each date in the month of January. A second graph will plot all the Febuary flows...and so on.
I can not sort by month because the date needs to stay in chronological order because of a vlookup function that gets the flow1 & 2 data based on the date.
Any thoughts?
Jim