Hello,
I have a file I open and save everyday. I have a column with dynamic numbers (s10:s50). I'd like to keep track of the highest numbers for each row down column (S)...
If I copy column (s) over to column (t) as static text, is there a way to make a condition for each cell in column (t) to update it to the column (s) number if column (s) number turns greater than the static column (t) number? So, column (s) will show dynamic numbers, and column (t) will show the highest number column (s) has ever shown. Thanks!
I have a file I open and save everyday. I have a column with dynamic numbers (s10:s50). I'd like to keep track of the highest numbers for each row down column (S)...
If I copy column (s) over to column (t) as static text, is there a way to make a condition for each cell in column (t) to update it to the column (s) number if column (s) number turns greater than the static column (t) number? So, column (s) will show dynamic numbers, and column (t) will show the highest number column (s) has ever shown. Thanks!