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.
Bookmarks