need help in excel formula

[sksanjeev786]

if we have multiple tables with the same table name. i,e "Table 1" 1 USA data , "Table 1"= Aus data, "Table 1"= India data. can we write with the help of the match function? and we have endpoint after each table name

 

[sksanjeev786]

Thanks Jason

Here is data in below

So I need data from 10-17 then 18-24 but we have same starting point "Q.BE2A Familiarity - India" so basically i change manually like Q.BE2A Familiarity - India1,2 or 3 to get data. please help me on this

MR Excel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Q.BE2A Familiarity - India								Sheet2
2	Base: Total
3		TOTAL	Aug'19 (Total(18-54 yo)) (B)										2	3
4	Base	2241	696			Filter	Q.BE2A Familiarity - India	1	- Column Proportions:	9		AWARE (NET)	98%	99%G		Q.BE2A Familiarity - India
5	AWARE (NET)	98%	99%G				Q.BE2A Familiarity - India	1	- Column Proportions:	9		EVER TRIED (SUBNET)	87%	89%FG		Q.BE2A Familiarity - India
6	EVER TRIED (SUBNET)	87%	89%FG				Q.BE2A Familiarity - India	1	- Column Proportions:	9		REGULAR TRIAL (SSN)	47%	48%FG		Q.BE2A Familiarity - India
7	REGULAR TRIAL (SSN)	47%	48%FG
8
9	- Column Proportions:
10	Q.BE2A Familiarity - India
11		TOTAL	Aug'19 (Total(18-54 yo)) (B)
12	Base	2241	696
13	AWARE (NET)	87%	89%FG
14	EVER TRIED (SUBNET)	52%	54%FG
15	REGULAR TRIAL (SSN)	10%	10%
16
17	- Column Proportions:
18	Q.BE2A Familiarity - India
19	Base	224100%	696
20	AWARE (NET)	100%	100%
21	EVER TRIED (SUBNET)	96%	96%
22	REGULAR TRIAL (SSN)	69%	68%F
23
24	- Column Proportions:
Sheet2

Cell Formulas
Range	Formula
H4:H6	H4	=MATCH($G4,$A:$A,0)
M4:N6	M4	=INDEX(INDIRECT("'"&$I$1&"'!A"&$H4&":IV"&$J4&""),MATCH($L4,INDIRECT("'"&$I$1&"'!A"&$H4&":A"&$J4&""),0),M$3)
G5:G6	G5	=$G$4
J4:J6	J4	=MATCH($I$4,INDIRECT("'"&$I$1&"'!A"&$H4&":A900000"),0)+$H4-1

Cells with Data Validation
Cell	Allow	Criteria
G4	List	=$P$4:$P$6

 

[jasonb75]

What results do you want to see? (try using copy and paste to create the end result that you want, then we can use that do decide which formula will be best).

Why do you have "Sheet2" in I2? Do you want one summary sheet for many sheets of data?

 

[sksanjeev786]

What results do you want to see? (try using copy and paste to create the end result that you want, then we can use that do decide which formula will be best).

Why do you have "Sheet2" in I2? Do you want one summary sheet for many sheets of data?

Hi Jason

I need the result from 10-17or 18-24 but since the name are the same in row 1 ,row 10 and Row 18 so by default I will get score from row 1-7

for Sheet 2 i just kept for example as I will huge date in 1 sheet so I pull my data in other sheet .

Let me know if you need more information

Thanks in Advance.

Regards,
Sanjeev

 

[jasonb75]

I need the result from 10-17or 18-24 but since the name are the same in row 1 ,row 10 and Row 18 so by default I will get score from row 1-7

So how will you decide if you want the results from row 1, row 10 or row 18? Or do you want all at once?

As I suggested above, using copy and paste to create your expected results, then posting that gives us a better idea of what you want. Don't include anything that is just there to help your formulas work, only what you need to see when it is finished.

Descriptions don't always work well, tiny details are easily lost or or misunderstood.

 

[sksanjeev786]

So how will you decide if you want the results from row 1, row 10 or row 18? Or do you want all at once?

As I suggested above, using copy and paste to create your expected results, then posting that gives us a better idea of what you want. Don't include anything that is just there to help your formulas work, only what you need to see when it is finished.

Descriptions don't always work well, tiny details are easily lost or or misunderstood.

Hi Jason,

I need data from score from 5-7,13-15, and 20-22 so we have a start and ending point 1,10,18 so basically, i change manually "Q.BE2A Familiarity - India1,2 and 3 to get
5-7,13-15, and 20-22 row data so do we have any option .

Thanks in Advance.
Thanks

 

[jasonb75]

so do we have any option

One option would be to read my last reply properly and provide what I asked you to.

 

[sksanjeev786]

One option would be to read my last reply properly and provide what I asked you to.

Hi Jason,

"" So how will you decide if you want the results from row 1, row 10 or row 18? Or do you want all at once? ""

I hope you are asking above note

So we pulling data from ETAB Enterprise and we have Table (T1,T2,T3) so based on that we pull data .


To simplify in a better way please see below screen shot

So I need match formula in B column so that I will get 2,11,19 instead of 2 in all column

MR Excel.xlsx
	A	B	C	D	E	F
1		Match function	Need data with Match Funciton			Manually name change
2	Q.BE2A Familiarity - India	2	2		Q.BE2A Familiarity - India1	2
3
4
5
6
7
8
9
10
11	Q.BE2A Familiarity - India	2	11		Q.BE2A Familiarity - India2	11
12
13
14
15
16
17
18
19	Q.BE2A Familiarity - India	2	19		Q.BE2A Familiarity - India3	19
Sheet3

Cell Formulas
Range	Formula
B2,B19,B11	B2	=MATCH($A2,$A:$A,0)
F2,F19,F11	F2	=MATCH($E2,$E:$E,0)

Let me know if you need more information

Thank you

Regards,
Sanjeev.

 

[sksanjeev786]

Hi Jason,

"" So how will you decide if you want the results from row 1, row 10 or row 18? Or do you want all at once? ""

I hope you are asking above note

So we pulling data from ETAB Enterprise and we have Table (T1,T2,T3) so based on that we pull data .


To simplify in a better way please see below screen shot

So I need match formula in B column so that I will get 2,11,19 instead of 2 in all column

MR Excel.xlsx
	A	B	C	D	E	F
1		Match function	Need data with Match Funciton			Manually name change
2	Q.BE2A Familiarity - India	2	2		Q.BE2A Familiarity - India1	2
3
4
5
6
7
8
9
10
11	Q.BE2A Familiarity - India	2	11		Q.BE2A Familiarity - India2	11
12
13
14
15
16
17
18
19	Q.BE2A Familiarity - India	2	19		Q.BE2A Familiarity - India3	19
Sheet3

Cell Formulas
Range	Formula
B2,B19,B11	B2	=MATCH($A2,$A:$A,0)
F2,F19,F11	F2	=MATCH($E2,$E:$E,0)

Let me know if you need more information

Thank you

Regards,
Sanjeev.

Hi Team,

Can anyone help me on the above query?

Thanks in advance

Regards,
Sanjeev

 

[sksanjeev786]

Hi Team,

Can anyone help me on the above query?

Thanks in advance

Regards,
Sanjeev

Hi Team,

Can anyone help on above formula solution

Regards,
Sanjeev

 

[jasonb75]

Post 14, second line.

BTW, you don't need to repeat the previous post every time you answer.