• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Last Description needed for every code

Tom22

Member
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
 

Attachments

Marcilio

New Member
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.
 

Attachments

Top