Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Year First Active
    Year Last Active
    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

    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!

  2. #2

  3. #3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •