I am trying to calculate the minimum value at the minimum or earliest date. My formula currently looks like =AGGREGATE(15,7,$L$2:$L$321/((R2=$A$2:$A$321)*(T2=$C$2:$C$321)),1) With L column being my helper values, R column being the reference, A column matching my references as there are multiple entries and T column being the earliest date with C column being the full list of dates.
My aggregate small function is returning zero only for some calculations when I include a filter however I want to see the smallest value for each reference at the earliest date in my list of values with the smallest value being around £1,000 when I put a filter on.
If anyone can help me I would very much appreciate it - I have tried to explain it the best way I can but sorry if it is confusing!
My aggregate small function is returning zero only for some calculations when I include a filter however I want to see the smallest value for each reference at the earliest date in my list of values with the smallest value being around £1,000 when I put a filter on.
If anyone can help me I would very much appreciate it - I have tried to explain it the best way I can but sorry if it is confusing!