Position code to be extract based on multiple criteria

  • 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


    [cp]*[/cp]


    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.