Unique List

T

Tech

New member
Joined
Jan 25, 2017
Messages
23
Reaction score
0
Points
0
Excel Version(s)
2010
Hi,

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

Thank you
 
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))),"")[/COLOR]

copied down and across the grid.
 
Last edited:
Thank you for replying but I do mean from N14:Q27 thanks. I put the data that matches the ID 106.
 
Could someone please check this solution?
 
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))),"")[/COLOR]

confirm with CTRL+SHIFT+ENTER.

The rest of the table uses previous formula
 
Thank you kindly for your help.
 
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
 
You must log in or register to reply here.
Back
Top