Extract Unique Position code based on multiple criteria

**ajaypal.sp** · 09-12-2016, 12:12 AM

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 candidates based on position. 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.

Thank you in Advance.

Regards
Raj

**teylyn** · 09-12-2016, 02:26 AM

Hello,

maybe somebody will write a long, convoluted array formula, but, really, why bother. This can easily be done with a few clicks using a pivot table.

Life can be so much easier if you work WITH Excel, not against it.

2016-09-12_18-24-01.png

cheers, teylyn

**shukla.ankur281190** · 09-12-2016, 03:06 AM

Try

H4=SUMPRODUCT(($B$2:$B$55=$G4)*($C$2:$C$55=$J$2)*(TEXT($A$2:$A$55,"MMM")=$L$2)) and drag down!!!...

As you requested for Formula, but Pivot is best and fastest instead of formula.

**ajaypal.sp** · 09-12-2016, 09:34 AM

Hi,

I don't want submission count. first i need to extract unique position code. Pls share the formula for
Unique Position code based on "Recruiter name" and "Submission Month".

Regards
Raj

**ajaypal.sp** · 09-18-2016, 01:15 PM

Hi,

Still i did not get the appropriate formula. Pls help anyone.

Note: I need formula (in G column) to extract position code in based on "Recruiter Name" and "Submission Month"

thank you in advance

regards
Raj

**teylyn** · 09-19-2016, 09:37 PM

What I said above. Very difficult with a formula. Easy as with a pivot table. Take your pick.

**soledad** · 09-19-2016, 11:16 PM

You can apply this formula for cell G4

Formula:

Please Login or Register  to view this content.

confirm it by holding CTRL+SHIFT then hit ENTER button

Extract Unique Position code based on multiple criteria

LinkBack

Thread Tools

Rate This Thread

Display

Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Re: Extract Unique Position code based on multiple criteria

Thread Information

Users Browsing this Thread

Similar Threads

Extract Unique data based on multiple criteria

[SOLVED] Extract unique items based on criteria

Extract unique items based on criteria

extract data based on four criteria in excel sheet or VBA code to extract

[SOLVED] Extract Unique Text Values based on Multiple Criteria

Extract Unique Field Based on Criteria

Extract Unique Value Based on Criteria

Bookmarks

Bookmarks

Posting Permissions