index count match

I need to convert many Bills of Material from an 'Indented Levels' list into a 'Parent-Component' list. That is, I want a formula on each row that reports the Parent part for the part on that current row. I have tried to use Index-Match, but can't get every row to return the correct answer...

I have the below formula, which runs fine but shows #N/A in all cells after the series has ran. How do I remove the #N/A output? I have tried If/Than, If Error, Etc. but I get too many arguments error. =(INDEX(glass2,MATCH(0,COUNTIF($D$6:D10,glass2&""),0)))...

Hi, I have a column that i need to count (cells contain text or numbers or both) but based on 4 criteria. I tried using the index and match based on 4 criteria with a counta element but was returning both #REF and #N/A. Example of formula used was: =INDEX(COUNTA(DATA!$T:$T),MATCH('PIVOT...

my setup: a(day) b(value) <tbody> 1 e 2 e 3 t 4 t 5 e 6 r 7 u 8 v 9 w 10 r </tbody> c1(repeated value) e d1(times repeated) 2 e1(value that appears after current streak of (d1) which is 2) t i am looking for a formula that...

Hi all Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 P&L VAT charge 3 -21 -50 -25 -60 -2 -78 -10 -36 -44 -99 -6 Quarterly Pmt -68 -87...

In a2 i have a for digit number 0234 I am trying to create a formula that will tell me if the four digit number in a2 has a "2" inside it. Answer in a3 Also a formula that will count how many 2 are inside the single cell