Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Working with Dates and "Active Wells".... HELP! very confusing!
1982 2013
1983 2013 1983 2003 1983 1988 1984 2013 1984 2013 1984 2013 1984 2013 1984 1997 1984 1990 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2013 1985 2000 1985 2000 1985 1991 1985 1988 1985 1987 1986 2013 1986 2013 1986 2013 1986 2011 1986 1989 1987 2013 Each row above is a different well The first column is the year the well was first active. The second column shows the year the well was last active. 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I use "if statements" when working with dates? | Excel Worksheet Functions | |||
Replace(ActiveCell.Formula, "Round(","") not working as expected | Excel Programming | |||
Another "working with dates ?" | Excel Worksheet Functions | |||
Working out age from "Day" "Month" "Year" | Excel Worksheet Functions |