Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Results 1 to 6 of 6
  1. 2nd October 2008, 08:22 PM #1
    Tankstand's Avatar
    Tankstand
    Tankstand is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Christies Beach
    Age
    59
    Posts
    972

    Default Tankstand needs Excel help

    Hello Everyone,

    I have need of your collective talents.

    I have attached an example of what I am trying to do, which is basically asking for the higher of two cells values to show in another cell and the lower in the other. Hopefully the text in my spreadsheet clarifies things.

    I am running Office 2007 and the default format of *.xlsx is not able to be uploaded here! I had to save as *.xls!

    Thanks,

    Mark.
    The secret to creativity is knowing how to hide your sources.
    Albert Einstein
    Reply With Quote Reply With Quote
  2. 2nd October 2008 08:22 PM # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Age
    2010
    Posts
    Many





     
  3. 2nd October 2008, 08:54 PM #2
    watson's Avatar
    watson
    watson is offline Deceased
    Join Date
    Sep 2006
    Location
    Avoca Victoria
    Age
    81
    Posts
    10,501

    Default

    G'day Mark,
    I've tried a few times, and can't open your attachment.
    I'll close down then try again.

    Restarted & got the attachment..the logic seems feasible to me......but then again....
    I'll not comment further until someone cleverer than I, solves your task.
    Reply With Quote Reply With Quote
  4. 2nd October 2008, 09:33 PM #3
    KevM's Avatar
    KevM
    KevM is offline GOLD MEMBER
    Join Date
    Apr 2002
    Location
    Margate Tasmania
    Posts
    1,148

    Default

    Mark,
    Been a while but think this should do for a solution.
    Last edited by KevM; 2nd October 2008 at 09:33 PM. Reason: wish I could spell
    Kev
    Reply With Quote Reply With Quote
  5. 2nd October 2008, 10:09 PM #4
    More_Firewood
    More_Firewood is offline More Firewood
    Join Date
    May 2008
    Location
    Laguna
    Age
    69
    Posts
    60

    Default Excel Help

    Hi

    An easier way is to put a formula like:
    =MAX(L7, L8)
    in the cell where you want the maximum
    =Min(L7, L8)
    in the cell where you want the minimum

    Andrew
    Reply With Quote Reply With Quote
  6. 2nd October 2008, 10:46 PM #5
    Chipman
    Chipman is offline SENIOR MEMBER
    Join Date
    Sep 2007
    Location
    Melbourne
    Posts
    1,133

    Default

    Andrew has got it right!!!!!


    Chipman
    Reply With Quote Reply With Quote
  7. 3rd October 2008, 12:21 PM #6
    Tankstand's Avatar
    Tankstand
    Tankstand is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Christies Beach
    Age
    59
    Posts
    972

    Default

    A Huge thankyou to Kev and Andrew!

    Both ways work,

    I nearly got there with the "IF" method.

    I love this forum!
    The secret to creativity is knowing how to hide your sources.
    Albert Einstein
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. MS excel
    By Harry72 in forum COMPUTERS
    Replies: 4
    Last Post: 30th July 2008, 12:36 AM

Tags for this Thread

Posting Permissions

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

Forum Rules