Closed Thread
Results 1 to 2 of 2

big time help Need for Excel Whizzes

  1. #1
    Registered User
    Join Date
    06-02-2008
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    15

    Red face big time help Need for Excel Whizzes

    Please go to worksheet function section where I posted
    my problem with an attached Excel spreadsheet. It involves multiple columns with 2 day counter columns
    i need the difference between two numbers but, it involves
    looking within a range for a number "1" or the word "start"
    I can change it to either, then if this is found within the
    range go 2 columns over and grab that number and minus
    it from the cell 2 columns over from the formula cell.
    eg. go to day #155 unless range (I55:I60) contains the word "start" if it contains the word start then in that row
    go 2 columns over and take this number. Minus it from cell L61.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Thread closed.
    Please read the Forum Rules about duplicate posts.
    Last edited by shg; 06-04-2008 at 11:32 PM.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing time
    By Ziggy_ks1 in forum Excel General
    Replies: 1
    Last Post: 04-21-2008, 10:42 PM
  2. Time Ranges
    By jmag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2008, 03:24 PM
  3. Time w/in Each Hour of Day btwn a Time Range
    By gbrogmus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-30-2007, 03:01 AM
  4. Date and Time Graphs
    By sach0025 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-10-2007, 01:07 AM
  5. Assignment overDUE PLEASE PLEASE HELP!!
    By undergrad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2006, 12:34 AM

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