I want to store the max value a certain cell has ever had - which btw is a value that changes based on conditions.
I.e. something like this: cell A1: =B1 if B1>A1 else keep A1
Is this possible?
I want to store the max value a certain cell has ever had - which btw is a value that changes based on conditions.
I.e. something like this: cell A1: =B1 if B1>A1 else keep A1
Is this possible?
Not without VBA.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
VBA can do it, if you would prefer VBA. I don't readily have a VBA based example.
Circular references can do this, if you are allowed to change the "enable iteration" setting. A recent (4 years ago) example with links to prior examples: https://www.excelforum.com/excel-gen...amic-cell.html
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks