Working with Dates and "Active Wells".... HELP! very confusing!

texas979

New member
Joined
Jul 17, 2013
Messages
4
Reaction score
0
Points
0
Year First Active
Year Last Active
19822013
19832013
19832003
19831988
19842013
19842013
19842013
19842013
19841997
19841990
19852013
19852013
19852013
19852013
19852013
19852013
19852013
19852000
19852000
19851991
19851988
19851987
19862013
19862013
19862013
19862011
19861989
19872013

Each row above is a different well

I need to make a graph with the data above.

Basically, the x axis needs to be years.
(1982, 1983, 1984...........2012, 2013)

The y axis needs to be the number of ACTIVE wells each year.
For example, the very last well (last row of data) was active from 1987-2013.
And the one before that was active 1986-1989

How can i represent the number of wells that were active each year?

Thank you!

i dont know ANY vba, so if you suggest using vba, please guide me step by step!
 
Back
Top