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

 

[jorismoerings]

Hi,

You can't because Excel will not except multiple Table1 as a table name.

 

[sksanjeev786]

Hello sir,

I have give an example.

we have the same table with the multiple time name as "Country" (consider as the starting point) multiple time and end point we have "Code" which is same end of each country

Please refer screen shot.

Thanks.

Regards,
Sanjeev

 

[sksanjeev786]

anyone help on above formula

 

[sksanjeev786]

help me out in above query

 

[jasonb75]

Try providing more information and a clearer example. In post 1 you mention USA, Australia and India but there is nothing in your sheet to identify the data.

When posting examples, please use XL2BB (link in my signature below), not screen captures.

Have you asked for help on this question anywhere else?

 

[sksanjeev786]

Try providing more information and a clearer example. In post 1 you mention USA, Australia and India but there is nothing in your sheet to identify the data.

When posting examples, please use XL2BB (link in my signature below), not screen captures.

Have you asked for help on this question anywhere else?

 

[sksanjeev786]

Try providing more information and a clearer example. In post 1 you mention USA, Australia and India but there is nothing in your sheet to identify the data.

When posting examples, please use XL2BB (link in my signature below), not screen captures.

Have you asked for help on this question anywhere else?

Hi Jason,

As per your suggestion I have tried to download XL2BB and look like it is an excel file but where to upload and unable to add in excel sheet

Please help me with this. I have added my querying here 1st time

Thanks.

Regards,
Sanjeev

 

[jasonb75]

It is an excel add-in. The link contains full instructions for it.

 

[sksanjeev786]

Thanks Jason

Here is data in below

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

It is an excel add-in. The link contains full instructions for it.