Hello All !
I am trying to find a formula that will index down a column that has multiple duplicate values and pull out per say one set of duplicates. Looking below, is there any way that I can extract only the rows that have K2-4 and related Part# and create a separate list?
Loc | Part#
K2-4 | 022-08863-000
K4-3 | 024-30900-001
K4-4 | 024-30907-000
K2-3 | 025-28663-001
K2-4 | 025-29139-001
K2-4 | 025-29583-000
K2-4 | 025-29583-001
K2-2 | 025-29964-000
K3-3 | 025-29964-000
K2-7 | 025-30919-000
K2-8 | 025-32906-000
C2-7 | 025-33280-000
C2-7 | 025-33282-000
K2-5 | 025-37857-000
Thanks !
Bookmarks