Position code to be extract based on multiple criteria

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hi,



    In the attachment, there is Sample data from A column to D column. Summary begins from G column. I want to extract Position code based on "Recruiter name" and "Submission month". Pls help.


    Explanation about Sample Data: Recruiters are working on Position code. They will call the right candidates for interview based on position code. After that they will fill the candidates details in excel. Based on this data i want to find out Monthly recruiter wise submission count. For this , First I want unique position code based on Criteria (Criteria: we need to consider "Recruiter Name" and "Submission Month"). If we filter Recruiter name as "Taylor" and Submission month as "Oct" then two position code should be reflect in G4 and G5 Cells. Bcoz "Taylor" worked on two positions (position) in "October" month.


    Note: I need formula in "G" Column (in G4,G5,G6... Cells) to get unique "Postion Code" based on criteria. No Filter / Advanced filter/Pivot options.


    Thank you in Advance.


    Regards
    Raj

    Re: Position code to be extract based on multiple criteria


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *


    2 threads on this forum, both not in accordance with the forum rules (Also are not in accordance with the rules of the other forum as well). Might suggest you read this and then update your threads on both forums - and please do not simply ignore this request as you have on the other forum.

    Re: Position code to be extract based on multiple criteria


    Got to do the lottery this week. I'm psychic!


    Please add links to your posts on other boards for this issue. Do the same for your other thread.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login