1. Unique List

Hi,

Can someone derive formulas to fill list based on ID Number please?

Thank you

2. Do you mean in O14:

=IFERROR(IF(\$N14="","",INDEX(Table146[HRS],MATCH(1,INDEX((Table146[[INV]:[INV]]=\$H\$3)*(Table146[[CODE]:[CODE]]=\$N14),0),0))),"")

copied down and across the grid.

3. Thank you for replying but I do mean from N14:Q27 thanks. I put the data that matches the ID 106.

4. Could someone please check this solution?

5. Ok, in N14 enter this array formula copied down:

=IFERROR(INDEX(Table146[CODE],SMALL(IF(Table146[INV]=\$H\$3,ROW(Table146[INV])-ROW(B\$14)+1),ROWS(N\$14:N14))),"")

confirm with CTRL+SHIFT+ENTER.

The rest of the table uses previous formula

6. Thank you kindly for your help.

7. OR

N14=IFERROR(HLOOKUP(N\$13,Table146[[#All],[CODE]:[UOM]],SMALL(IF(Table146[INV]=\$H\$3,ROW(Table146[INV])-12,"/"),ROW(A1)),),"")

CONTRO,SHIFT,ENTER THNE COPY TO Q27

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•