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
Bookmarks