Hi,
I want to extract consecutive Data from B3:B15 if H2 is in C3:D15 (C3:C15 OR D3:D15)
Thanks for help...
Hi,
I want to extract consecutive Data from B3:B15 if H2 is in C3:D15 (C3:C15 OR D3:D15)
Thanks for help...
Last edited by ionelz; 10-19-2020 at 08:19 PM.
Please try at G4
=IFERROR(INDEX(Table1[Cable],AGGREGATE(15,6,ROW(Table1)/((Table1[Con1]=$H$2)+(Table1[Con2]=$H$2)>0),ROWS(G$4:G4))-ROW(Table1[#Headers])),"")
or
=IFERROR(INDEX(Table1[Cable],AGGREGATE(15,6,ROW(Table1)/(MMULT(N(Table1[[Con1]:[Con2]]=$H$2),{1;1})>0),ROWS(G$4:G4))-ROW(Table1[#Headers])),"")
Like always, work great, thank yo Bo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks