Results 1 to 6 of 6

Recording a high value from another cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016
    Posts
    615

    Recording a high value from another cell

    I have a spreadsheet that is automatically updated from another program I use.

    Cell AD5 has a value that constantly changes (up and down) after each update from the program.

    What I want to be able to do if it is possible, is to have another cell (AF5) show the HIGHEST figure ever recorded in cell AD5...and adjust accordingly each time AD5 hits it's highest ever amount.

    eg, lets say AD5 starts with 100....it then drops to 98....AF5 retains 100.....AD5 then changes to 102....AF5 changes to 102....AD5 drops to 96....AF5 would retain 102...etc

    The figure returned in cell AF5 is then used as a trigger in another column/cell.

    I could use additional cells apart from AF5 if it is necessary.

    Possible?

    Many thanks for taking the challenge.
    Cheers
    Hammer
    Last edited by hammer2; 08-25-2011 at 03:19 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