ynissel wrote:
For anyone else that reads this - I have a table of 9 columns and about 30
rows. I have 5 different companies that fill these ranges with prices and
I want the average price - but dropping the lowest.

I did not follow the entire thread, but based on the summary above,
is there some reason why the following does not satisfy your needs:

=(SUM(A1:I30)-MIN(A1:I30))/(COUNT(A1:I30)-1)

Caveat: This drops only __one__ instance of the lowest value.
If your intent is to drop __all__ instances of the lowest value,
the above does not meet your needs.