need help in excel formula

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
 

Attachments

  • with same table number.jpg
    with same table number.jpg
    235.6 KB · Views: 22

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

help me out in above query
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,922
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

ADVERTISEMENT

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

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Dec 30, 2008
Messages
11,922
Office Version
  1. 365
Platform
  1. Windows
It is an excel add-in. The link contains full instructions for it.
 

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thanks Jason

Here is data in below


MR Excel.xlsx
ABCDEFGHIJKLMNOPQ
1Q.BE2A Familiarity - IndiaSheet2
2Base: Total
3TOTALAug'19 (Total(18-54 yo)) (B)23
4Base2241696FilterQ.BE2A Familiarity - India1- Column Proportions:9AWARE (NET)98%99%GQ.BE2A Familiarity - India
5AWARE (NET)98%99%GQ.BE2A Familiarity - India1- Column Proportions:9EVER TRIED (SUBNET)87%89%FGQ.BE2A Familiarity - India
6EVER TRIED (SUBNET)87%89%FGQ.BE2A Familiarity - India1- Column Proportions:9REGULAR TRIAL (SSN)47%48%FGQ.BE2A Familiarity - India
7REGULAR TRIAL (SSN)47%48%FG
8
9- Column Proportions:
10Q.BE2A Familiarity - India
11TOTALAug'19 (Total(18-54 yo)) (B)
12Base2241696
13AWARE (NET)87%89%FG
14EVER TRIED (SUBNET)52%54%FG
15REGULAR TRIAL (SSN)10%10%
16
17- Column Proportions:
18Q.BE2A Familiarity - India
19Base224100%696
20AWARE (NET)100%100%
21EVER TRIED (SUBNET)96%96%
22REGULAR TRIAL (SSN)69%68%F
23
24- Column Proportions:
Sheet2
Cell Formulas
RangeFormula
H4:H6H4=MATCH($G4,$A:$A,0)
M4:N6M4=INDEX(INDIRECT("'"&$I$1&"'!A"&$H4&":IV"&$J4&""),MATCH($L4,INDIRECT("'"&$I$1&"'!A"&$H4&":A"&$J4&""),0),M$3)
G5:G6G5=$G$4
J4:J6J4=MATCH($I$4,INDIRECT("'"&$I$1&"'!A"&$H4&":A900000"),0)+$H4-1
Cells with Data Validation
CellAllowCriteria
G4List=$P$4:$P$6


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

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,474
Members
414,070
Latest member
DuncanLucas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top