mxgarrison
New Member
- Joined
- Jul 5, 2023
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hi. I have 2 sets of data in one excel spreadsheet tab. One is unique PN's (aka Column G). Other is duplicate PN's with unique locations (aka Columns A1-C10). Below is my formula I'm working on.
=IFERROR(INDEX($A$1:$C$10,SMALL(IF($G$1=$A$1:$A$10,ROW($A$1:$A$10)-ROW($A$1)+1), COLUMN($I$1)),3),"???")
All I'm getting back in column I1 is ???. Below is my data:
I've been working on this forever and I'm just stuck. Please help.
Thanks
-Mark
=IFERROR(INDEX($A$1:$C$10,SMALL(IF($G$1=$A$1:$A$10,ROW($A$1:$A$10)-ROW($A$1)+1), COLUMN($I$1)),3),"???")
All I'm getting back in column I1 is ???. Below is my data:
A | B | C | D | E | F | G |
123456-0001 | Widget 1 | A01A | 789123-0015 | |||
123456-0001 | Widget 1 | A01D | 456789-0002 | |||
123456-0001 | Widget 1 | A02C | 123456-0001 | |||
123456-0001 | Widget 1 | A05D | ||||
123456-0001 | Widget 1 | B04D | ||||
123456-0001 | Widget 1 | B06A | ||||
456789-0002 | Widget 2 | B05C | ||||
456789-0002 | Widget 2 | B14A | ||||
789123-0015 | Widget 3 | A05D | ||||
789123-0015 | Widget 3 | A04D |
I've been working on this forever and I'm just stuck. Please help.
Thanks
-Mark