SgtBadManners
New Member
- Joined
- Nov 22, 2016
- Messages
- 1
I have 2 formulas that both work separately and I am wondering how I would go about combining them.
=IFERROR(INDEX('Edges & Hinderances'!$B$2:$B$95,SMALL((LEN('Edges & Hinderances'!$A$2:$A$95)>0)*ROW('Edges & Hinderances'!$A$2:$A$95)-MIN(ROW('Edges & Hinderances'!$A$2:$A$95))+1,ROW(A1)+ROWS('Edges & Hinderances'!$A$2:$A$95)-COUNTA('Edges & Hinderances'!$A$2:$A$95))),"")
=(TRIM(LEFT('Edges & Hinderances'!$B$2,SEARCH("(",'Edges & Hinderances'!$B$2&"(")-1))&""&'Edges & Hinderances'!$A$2&"")
So right now my result looks like Absolute Direction (1/3)
I am trying to have it pull Absolute Direction 1.
1 being the indicator that determines if it is pulling or not in the first formula.
I tried just putting them together and it gave me an error.=IFERROR(INDEX((TRIM(LEFT('Edges & Hinderances'!$B$2,SEARCH("(",'Edges & Hinderances'!$B$2&"(")-1))&""&'Edges & Hinderances'!$A$2&"")
TRIM(LEFT('Edges & Hinderances'!$B$95,SEARCH("(",'Edges & Hinderances'!$B$95&"(")-1))&""&'Edges & Hinderances'!$A$95&""),SMALL((LEN('Edges & Hinderances'!$A$2:$A$95)>0)*ROW('Edges & Hinderances'!$A$2:$A$95)-MIN(ROW('Edges & Hinderances'!$A$2:$A$95))+1,ROW(E1)+ROWS('Edges & Hinderances'!$A$2:$A$95)-COUNTA('Edges & Hinderances'!$A$2:$A$95))),"")
Thank you for your time.
=IFERROR(INDEX('Edges & Hinderances'!$B$2:$B$95,SMALL((LEN('Edges & Hinderances'!$A$2:$A$95)>0)*ROW('Edges & Hinderances'!$A$2:$A$95)-MIN(ROW('Edges & Hinderances'!$A$2:$A$95))+1,ROW(A1)+ROWS('Edges & Hinderances'!$A$2:$A$95)-COUNTA('Edges & Hinderances'!$A$2:$A$95))),"")
=(TRIM(LEFT('Edges & Hinderances'!$B$2,SEARCH("(",'Edges & Hinderances'!$B$2&"(")-1))&""&'Edges & Hinderances'!$A$2&"")
So right now my result looks like Absolute Direction (1/3)
I am trying to have it pull Absolute Direction 1.
1 being the indicator that determines if it is pulling or not in the first formula.
I tried just putting them together and it gave me an error.=IFERROR(INDEX((TRIM(LEFT('Edges & Hinderances'!$B$2,SEARCH("(",'Edges & Hinderances'!$B$2&"(")-1))&""&'Edges & Hinderances'!$A$2&"")
TRIM(LEFT('Edges & Hinderances'!$B$95,SEARCH("(",'Edges & Hinderances'!$B$95&"(")-1))&""&'Edges & Hinderances'!$A$95&""),SMALL((LEN('Edges & Hinderances'!$A$2:$A$95)>0)*ROW('Edges & Hinderances'!$A$2:$A$95)-MIN(ROW('Edges & Hinderances'!$A$2:$A$95))+1,ROW(E1)+ROWS('Edges & Hinderances'!$A$2:$A$95)-COUNTA('Edges & Hinderances'!$A$2:$A$95))),"")Thank you for your time.
