Hi Everyone,
So I need a formula that allows me to find the average of a column within a chart while ignoring duplicate values and blank cells.
I tried using this formula:
=AVERAGE(IF(FREQUENCY([$AMOUNT],[$AMOUNT]),[$AMOUNT]))
but it doesn't work if there are blank cells present.
Can anyone help?
Thanks
Bookmarks