# Average unique values from an index

1. ## Average unique values from an index

Hello everyone!

I need some help with a good formula for an issue I'm having with excel, I need to calculate the average of a range based on an index.

I have this formula from another thread but now I need to link it to the index "=AVERAGE(IF(FREQUENCY(AQ5:AQ12,AQ5:AQ12),AQ5:AQ12))"

I attached a pic and an excel file with example values, in the pic, I want to calculate the average value from unique values on AQ column for a range given in the index on AJ column.

I hope it makes sense from the pic and excel file attached.

example.JPG  Register To Reply

2. ## Re: Average unique values from an index

Your description and sheet do not tally. In particular, what do you mean by the bit in red. I assume that AQ is now column H....

I want to calculate the average value from unique values on AQ column for a range given in the index on AJ column.  Register To Reply

3. ## Re: Average unique values from an index

Hi ,

This seems to work :

Formula:  `Please Login or Register  to view this content.`

This is an array formula , to be entered using CTRL SHIFT ENTER.

The first reference \$A\$2:\$A\$34 is one cell more than the data range because the FREQUENCY function returns an array which is one element more than the data range.

Narayan  Register To Reply