Results 1 to 6 of 6

Pulling Data from a Specific Month

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2010
    Posts
    3

    Pulling Data from a Specific Month

    I have a spread sheet with numerous months data. I need to isolate the data from, say, August. I have been playing with it for a while and have the data in various formats so I can use almost any formula but am looking for something that can be changed for each month easily.

    A1.........A2..........A3............A4............A5............A6..............A7
    Single.....Date......Numerical Date.....Doctor.....Reason......Item
    Digit
    Date

    8 1 1-Aug 41123 Dr. Letsgo Bloody Scissors
    8 1 1-Aug 41123 Dr. Green Rusted Scissors
    8 2 2-Aug 41124 Dr. Sparty Broken Knife
    8 3 3-Aug 41125 Dr. Doog Unsterile Spoon
    8 3 3-Aug 41125 Dr. Doog Scratched Soup Spoon
    8 3 3-Aug 41125 Dr. Slum Scratched Thermometer
    8 4 4-Aug 41126 Dr. Sparty Bloody Fork
    9 1 1-Sept 41154 Dr. Dude Stained Spork

    I need to know how many times each doctor comes up in a particular month (and then year)..

    I need to know how many times each "reason" comes up in particular month (and then year)...


    Sorry about the formatting, I tried the best I could
    Last edited by kjkb508; 08-16-2012 at 10:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1