Countif to find Unique value based on another columm

[MaxMurphy13]

Good Morning,
I am having trouble with a formula to return unique results based on another column of data:

Any help is appreciated...thank you

<colgroup><col style="width:48pt" width="64" span="4"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> </colgroup><tbody>

Data		Results
Current	New		Currrent	Unique "New" Count
newjob1	betterjobA		newjob1	3
newjob1	betterjobB		newjob2	2
newjob1	betterjobB		newjob3	1
newjob1	betterjobC
newjob1	betterjobC
newjob2	betterjobA
newjob2	betterjobB
newjob3	betterjobA

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

</tbody>

 

[MaxMurphy13]

Data		Results
Current	New		Currrent	Unique "New" Count
newjob1	betterjobA		newjob1	3
newjob1	betterjobB		newjob2	2
newjob1	betterjobB		newjob3	1
newjob1	betterjobC
newjob1	betterjobC
newjob2	betterjobA
newjob2	betterjobB
newjob3	betterjobA

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:5046;width:104pt" width="138"> </colgroup><tbody>
</tbody>

 

[MaxMurphy13]

Sorry about that. My table does not appear. Basically I have a table with clothing types in column A. then in column B I have a list of actual clothing. I want to count how many different items in column b make up one of the types in column A.

 

[Gerald Higgins]

OK, so posting a small sample of your data, together with the expected results, would be helpful . . .

 

[Eric W]

Maybe:

	A	B	C	D	E
1	Current	New		Currrent	Unique "New" Count
2	newjob1	betterjobA		newjob1	3
3	newjob1	betterjobB		newjob2	2
4	newjob1	betterjobB		newjob3	1
5	newjob1	betterjobC			0
6	newjob1	betterjobC
7	newjob2	betterjobA
8	newjob2	betterjobB
9	newjob3	betterjobA

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet16​

Array Formulas Cell Formula D2 {=IFERROR(INDEX($A$2:$A$9,SMALL(IF(MATCH($A$2:$A$9,$A$2:$A$9,0)=ROW($A$2:$A$9)-ROW($A$2)+1,ROW($A$2:$A$9)-ROW($A$2)+1),ROWS($D$2:$D2))),"")} E2 {=SUM(SIGN(FREQUENCY(IF($A$2:$A$9=D2,MATCH($B$2:$B$9,$B$2:$B$9,0)),ROW($B$2:$B$9)-ROW($B$2)+1)))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>