T Tom22 Member Jun 7, 2021 #1 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 Book1.xlsx 10.6 KB · Views: 5
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
M Marcilio Member Jun 7, 2021 #2 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 07-06-2021_chandoo_Book1.xlsx 10.7 KB · Views: 9
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.
