Last Description needed for every code

[Tom22]

Hi,

I need help to find out last description of every code.

Data is very huge and I am trying to find a way , how we can find out it.

Example- code 4646 has 8 descriptions but we only need last one "yy" and same for other codes.

File attached for your reference.

Many thanks

 

[Marcilio]

Tom22, Good morning.

Try to use:

Selecting CODE: D2 --> =IFERROR(INDEX($A$2:$A$67;MATCH(0;INDEX(COUNTIF($D$1:D1;$A$2:$A$67); ); ));"")

Selecting DESCRP: E2 --> =LOOKUP(2;1/($A$2:$A$67=D2);$B$2:$B$67)

Please, tell us if it worked for you.

I hope it helps.

 

[Tom22]

Yes it is working fine....thank you very much

 

[Marcilio]

Tom22, Good afternoon.

Thanks for the feedback.

Glad to help you.