I have a column that varies from 1 to 24 rows. I need to find the average of the values, looking at their absolute value.
I can use thisbut if the data only goes to b25 or b24 or anything less than B26 then it will average in 0 to the formula. How do i check how low the column goes before calculating the abs average?Formula:Please Login or Register to view this content.
I can useto find the last row but i dont know how to plug in the result from this formula into the range of the formula above.Formula:Please Login or Register to view this content.
Edit: Forgot to mention the column contains formulas that either return a number or "" so it has to ignore the ""
Bookmarks