I have this formula which has been serving me well for a while now.. but I need to change it so that it captures the minimum absolute value, rather than the minimum value.

=Minifs($AE$1:AE53,$C$1:C53,C54)

This does not work:

=Minifs(ABS($AE$1:AE53),$C$1:C53,C54)

I tried using Filter function:

=Min(Filter(ABS($AE$1:AE53),$C$1:C53=C54))

But this gives me a circular dependency error, even though the formula is not on a row in the filter range.


Any ideas?

Thanks in advance for any tips.

Maria