I am streaming data that I then add some functions to and it is displayed as a percentage in cells M26 and N26. As such M26 and N26 are continuously updating to display new percentage figures.

I would like cell M28 to display the highest percentage figure in M26 (i.e. if previously M26 is 2% and then updates to 1.5%, I would like M28 to remain as 2%). For cell N28, I would like to display the lowest percentage displayed in the cell N26.

My VBA knowledge is basic, so your assistance is appreciated.

Thanks,
R