How to store the lowest value that ever happens in a dynamic cell?

Hi ExcelNoob09. Welcome to the forum.

My first thought is that the smallest number is 0 and the cell is formatted to display "-" for those.

Edited Incorrect grid post.

Also the test

1. Cell A1 (Key in any number you like)
2. Cell B1 (Key in =AGGREGATE(4,6,A1,B1) - this will store the Max number that ever comes into Cell A1

returns a circular ref error and then 0.

This works fine at my end.

	A	B	C
1	MIN	MAX
2	1	12	A2=AGGREGATE(5,6,A3,B3)
3	12	1	B2=AGGREGATE(4,6,A3,B3)

Hi, it doesn't record the highest values that ever occurred in the cells.
If you change the values in Row 3, the numbers change accordingly in Row 2

I need the target cells to store the highest and lowest values from one source cell with dynamically changing values. Hence I only used 3 cells in my example. Cell A1 will dynamically change in value, so you can keep keying in numbers into it.

The max value will be successfully stored in the Max cell, but the Min cell doesn't .