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