GetHitFooL
New Member
- Joined
- May 19, 2015
- Messages
- 13
Okay guys, so I need to go through all my rows of data anywhere from 800-2500 and look at the creation date. I have a function that finds how many rows so I just do a for loop to go through ever row. What I don't know how to do is select just the year from the creation date and add it to a t chart on another sheet named "Priority". If the year has already been listed I don't want it to be listed again.
For Example I could have the following example:
Creation Date
6/1/2015
4/5/2015
7/1/2012
8/2/2013
And would want the chart to list
2012
2013
2015
Then I want to go through and count how many of each of these occur in my data. The thing I don't get is how to count for just whats on the list since it could start at 2010 and go through 2015 or maybe another sheet just has 2014 and 25. So I don't know how many if statements to make and want this to be dynamic so it will work for years to come.
If we can solve this problem, how can I make a graph that uses just the data in the chart. I can't figure out how to take the t chart that we made above and make a graph with just that data. So sometimes it could have 5 years but some might have 2 and so on.
For Example I could have the following example:
Creation Date
6/1/2015
4/5/2015
7/1/2012
8/2/2013
And would want the chart to list
2012
2013
2015
Then I want to go through and count how many of each of these occur in my data. The thing I don't get is how to count for just whats on the list since it could start at 2010 and go through 2015 or maybe another sheet just has 2014 and 25. So I don't know how many if statements to make and want this to be dynamic so it will work for years to come.
If we can solve this problem, how can I make a graph that uses just the data in the chart. I can't figure out how to take the t chart that we made above and make a graph with just that data. So sometimes it could have 5 years but some might have 2 and so on.