My next thought is thatthe numbers might be text "numbers" which min ignores and would value as 0s.drawing data from a cell with a value already in it
Try coercing those with leading "--" like this
=AGGREGATE(5,6,--AI5,--N5)
This might confuse AGGREGATE which is expecting a range. The double "--" may cause AGGREGATE to view those as an array which requires a different syntax. I've never tried applying AGGREGATE to 2 non contiguous cells.
Dave
Hi Dave,
Tried =AGGREGATE(5,6,--AI5,--N5), it returned a #VALUE! error.
To test this out, simply open a fresh excel sheet,
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
3. Cell C1 (Key in =AGGREGATE(5,6,A1,C1) - this is supposed to store the smallest number that comes in to Cell A1, but it doesn't work.
4. Randomly key in numbers into Cell A1 to see if the cells store them in the respective formula cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ExcelNoob09 
Register To Reply
Bookmarks