• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Capture Minimum and Maximum values from a Single Common dynamic cell.

E

EeHh

New Member

Hi,

I am looking to Capture Minimum and Maximum values froma single Common Dynamic cell.

Details:

Sheet 1: Pulls dynamic (auto/manual refresh) data from web query.

Sheet 2: Cell A1 displays a dynamic number (profit or Loss and which keeps on changing) which is calculated using dynamic values from Sheet 1. It can be Positive or Negative or can change from Positive to Negative & vice versa during the session/day.

Requirement:

Sheet 2, B1 should show MAX value of Cell A1 reached today (not session).
Eg: In A1, suppose Max Value reached = -10, Min Value reached = -20, B1 cell should display -10 and keep on updating as the value changes.
Eg: In A1, suppose Max Value reached = +50, Min Value reached = -15, B1 cell should display +50 and keep on updating as the value changes.


Sheet 2, C1 should show MIN value of Cell A1 reached today (not session).
Eg: In A1, suppose Max Value reached = -10, Min Value reached = -20, C1 cell should display -20 and keep on updating as the value changes1
Eg: In A1, suppose Max Value reached = +50, Min Value reached = -15, C1 cell should display -15 and keep on updating as the value changes.

Optional:
Sheet 2, D1 should show MAX value of Cell A1 reached till date.
Sheet 2, E1 should show MIN value of Cell A1 reached till date.

Only the value in cell A1 in Sheet2 is to be considered and not the entire column A.

There will be various figures in A column but are only concerned with cell A1.

Tried a few solutions but Minimum is captured only when it is a Negative figure.

If above conditions are too many or complex, a basic solution to capture Minimum / Maximum capture would help too.

Thanks.
 
Hello,
Good explanation but still a sample excel sheet of above mentioned data, will really assist you to get help.
 
Hi,
Attaching files.
Thanks.
 

Attachments

  • Sample1.xlsx
    22.5 KB · Views: 15
  • Sample2.xlsx
    22.5 KB · Views: 8
  • Sample3.xlsx
    22.5 KB · Views: 4
EeHh

Firstly, Welcome to the Chandoo.org Forums

Your post has been cross-posted, which means it has been seen on other websites. This is considered poor practice, as it can waste peoples time, which could be spent elsewhere, especially if you get a solution elsewhere and don't notify us.

I encourage you to please read the site rules at:
http://forum.chandoo.org/link-forums/new-users-please-read.17/
 
Hi,

as you said that value of cell A1 is dynamic, did you mean that it will be overwritten in the cell with a newer value? You have also provided an example of values in cell A1 - 5, 3, 5, 2, 1, 6, 7, 9 from where you are getting these values.
 
Faseeh said:
Hi,

as you said that value of cell A1 is dynamic, did you mean that it will be overwritten in the cell with a newer value? You have also provided an example of values in cell A1 - 5, 3, 5, 2, 1, 6, 7, 9 from where you are getting these values.
Click to expand...

Yes, A1 will be overwritten.
A1 gets it's value from D9.

Value (5, 3, 5, 2, 1, 6, 7, 9) were mentioned as examples.

Got basic solution in another forum/website, link mentioned in post#5 above.

Next, looking for automation w.r.t. Till Date Min / Max.

Thanks.
 
You must log in or register to reply here.
Back
Top