GoogleSheets: Minifs with ABS?

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

Thanks so much, AliGW!! I'm still trying to find my way around here! 😊

Originally Posted by rorya

That works fine for me. Can you post a link to a sheet where it doesn't work?

I turned on the setting to allow iterative calculations, and now it works!

Thanks so much 🙃

Thanks Rorya, found the circular reference, which I somehow missed as it only occurs on the first row! All fixed :-)