In Cali 77
New Member
- Joined
- Mar 26, 2014
- Messages
- 2
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.
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.
Last edited: