Closed Thread
Results 1 to 4 of 4

Need a Formula that extract certain data

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question Need a Formula that extract certain data

    I am making a excel program that works out my power usage, solar production and cost of bill etc as I am new to excel would appreciate any help

    SHEET ( Power Bill) In Column A, B, C I have days, date, Time which is broken down from Column D which has day-date-time the days are broken up into 5 minutes interval for each day

    What I am aiming to do is create 2 graphs on SHEET Day-Month Graphs & I am not sure if I need to create another worksheet first with extracted data & what formulas would achieve my goal

    ( Graph1) I want to call it Hourly.... For the hourly Graph I am hoping that I can type a date in a cell & excel will look down the column either column B or D and extract all cells relating to that date then I need for it then add all 5 minutes intervals up for each hour of the day ......... Graph will contain the read out of column I & K broken into hours per 24 hours

    ( Graph1) I want to call it Daily.... For the Daily Graph I am hoping that I can type a range of 2 dates in a cell & excel will look down the column either column B or D and extract all cells relating to that dates then I need for it then add all 5 minutes intervals up for each day between those date ......... Graph will contain the read out of column I & K broken into days

    I have attach the latest version of my Program & again I will appreciate any help & please just bare with me

    Updated Version Power Bill.xlsx
    Last edited by Waynej4t; 11-11-2012 at 08:05 PM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,764

    Re: Need a Formula that extract certain data

    Dupe http://www.excelforum.com/excel-form...her-cells.html

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Need a Formula that extract certain data

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Need a Formula that extract certain data

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

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