Trying to write AVERAGEIF formula with FREQUENCY for unique values

[In Cali 77]

Hello,

I am using Excel 2010 and need to create a formula to show the monthly average for when talent lists are created for positions. The issue that I am having is that in the candidate database, the requisition number will show multiple times but I only want to calculate for each unique requisition once.

Column BB-Requisitions
Column AK-Shows month of created talent list
Column AD-Shows the number of days for generating the talent list

I have been trying different formula variations and unfortunately I do not have a lot of experience with using Frequency.
=AVERAGEIF(Data!AD:AD,Data!AK:AK,"=October",IF(FREQUENCY(Data!$B:$B,Data!$B:$B)>0)

I would sincerely appreciate any available assistance.

Thank you.

 

[cyrilbrd]

Try =AVERAGE(IF(FREQUENCY(IF($BB$2:$BB$400<>"",IF($AK$2:$AK$400="october",MATCH($BB$2:$BB$400,$BB$2:$BB$400,0))),ROW($BB$2:$BB$400)-ROW($BB$2)+1),$AD$2:$AD$400)) Ctrl + Shift + Enter not just enter on a PC or Command + Return on a MAC.

 

[cyrilbrd]

or =AVERAGE(IF(FREQUENCY(IF(AD2:AD31<>"",IF(AK2:AK31="jan",MATCH(BB2:BB31,BB2:BB31,0))),ROW(BB2:BB31)-ROW(BB2)+1),BB2:BB31))Ctrl + Shift + Enter not just enter on a PC or Command + Return on a MAC.

 

[In Cali 77]

This is perfect! Thank you so much as I have never had to create this type of formula. I will be using this as a reference to teach myself how to do them. I am so happy!

 

[cyrilbrd]

Glad it worked for you.
thanks for the feedback.