Hi all,

I have an Excel stock portfolio that draws data every 30 seconds from an external API, and refreshes a cell with an updated value of the stock at that point in time.

I have successfully managed to record the highest value that ever comes into this cell with the Aggregate function [=AGGREGATE(4,6,AI5,M5)], where 4 is MAX, 6 is ignore errors, AI5 is the data cell, and M5 is the cell which stores the highest value.

However, the Min Function does not work at all. [=AGGREGATE(5,6,AI5,N5).] It just returns a "-"

Can anyone help me with this please?

Thank you.