Find Latest Alpha Character Associated with Variable

[Tucker2008]

All,

Is there a formula in Excel that can search for the Part Number in COL A, find the latest Alpha instance in Column B and Tag in Col C. Result would be below. Part #12345....C is latest Letter in Alphabet, Tag in Col C as such????? Any, all help would be greatly appreciated.

	A	B	C
	Part Number
1	12345	A
2	12345	B
3	12345	C	Latest

 

[Fluff]

What version of Excel are you using?
Please update you account details to show this, as it affects what functions you have available.

Also will the latest letter always be the last row for that part number?

 

[gaz_chops]

If Col B is only a single character, then try

=IFERROR(IF(CODE(B2)=MAX(IF($A$2:$A$11=A2,CODE($B$2:$B$11))),"Latest",""),"")
Enter as an array with Ctrl, Shift & Enter

 

[gaz_chops]

Or this as a non array formula

=IFERROR(IF(CODE(B2)=AGGREGATE(14,6,CODE($B$2:$B$9)*($A$2:$A$9=A2),1),"Latest",""),"")

 

[Tucker2008]

What version of Excel are you using?
Please update you account details to show this, as it affects what functions you have available.

Also will the latest letter always be the last row for that part number?

Will do and no, it will not.

 

[gaz_chops]

Did you try either of my suggestions?

 

[Fluff]

Will do

Did you scroll down & click "save" when you changed your profile.

 

[Tucker2008]

Did you scroll down & click "save" when you changed your profile.

I did now!!!!!!!

 

[Fluff]

Thanks for that.
As you are on 2013, try the two suggestions from gaz_chops