1. ## Unique List

Hi,

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

Thank you  Reply With Quote

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.  Reply With Quote

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

4. Could someone please check this solution?  Reply With Quote

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  Reply With Quote

6. Thank you kindly for your help.  Reply With Quote

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  Reply With Quote

#### Posting Permissions

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