MIS Tricks Q29 Lookup on Each Duplicate Value in Excel

Name: MIS Tricks Q29 Lookup on Each Duplicate Value in Excel
Uploaded: 2023-04-14T09:06:32+00:00
Duration: 8 min 27 s
Channel: RAKESH KUMAR
Description: Lookup on Each Duplicate Value in Excel =IFERROR(INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8=H2,ROW($A$1:$A$8)),ROW()-1)),"") Supporting File Link https://docs.google.com/spreadsheets/d/1ZQRkxkzS9NkBBZ6qVlu9uuUXZWMMYQBJ/edit?usp=share_link&ouid=108365514073073043927&rtpof=true&sd=true

RAKESH KUMAR

Lookup on Each Duplicate Value in Excel  =IFERROR(INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8=H2,ROW($A$1:$A$8)),ROW()-1)),"")  Supporting File Link  https://docs.google.com/spreadsheets/d/1ZQRkxkzS9NkBBZ6qVlu9uuUXZWMMYQBJ/edit?usp=share_link&ouid=108365514073073043927&rtpof=true&sd=true

Category

Recommended