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]

Post 14, second line.

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

Hi Jaason,

I have looked in post 14 and unable to find any solution. if you don't mind can you please provide the formula? if possible

for the file I have attached earlier.

Sorry for multiple post

thanks in advance.

Regards,
Sanjeev

 

[jasonb75]

Post 14 was not a solution it was telling you the information that you need to provide before we can write the formula.

The example that you provided was nothing like the one that I asked you for in the second line of post 14 which was why I directed you back to it.

 

[sksanjeev786]

Post 14 was not a solution it was telling you the information that you need to provide before we can write the formula.

The example that you provided was nothing like the one that I asked you for in the second line of post 14 which was why I directed you back to it.

Hi Jasonb,

As per my understanding, i have only sent to the statement with the same wording, so now how you want us to send you data without formula.

Sorry if I misunderstood anything.

I hope you can able to understand what I want exactly with that file.


Regards,
Sanjeev.

 

[jasonb75]

Your example in post 10 shows data on the left and the results based on your formulas on the right.

What you need to show us is how you want the part on the right to look when it is finished.

 

[sksanjeev786]

Your example in post 10 shows data on the left and the results based on your formulas on the right.

What you need to show us is how you want the part on the right to look when it is finished.

Hi Jason

Just to be more clear I am posting my query in a simple way. if we write match function can I get result 2,11,19 with match function?

As is I have the same name multiple time in my data file

MR Excel.xlsx
	A	B
1		Using match function
2	Q.BE2A Familiarity - India
3
4
5
6
7
8
9
10
11	Q.BE2A Familiarity - India
12
13
14
15
16
17
18
19	Q.BE2A Familiarity - India
Sheet4

 

[jasonb75]

That is not what I asked you to post. By trying to simplify it you are making it more complicated!

This is what you have asked for, good luck making it work. I give up!

Book1
	A	B	C
2	Q.BE2A Familiarity - India		2
3			11
4			19
5
6
7
8
9
10
11	Q.BE2A Familiarity - India
12
13
14
15
16
17
18
19	Q.BE2A Familiarity - India
Sheet8

Cell Formulas
Range	Formula
C2:C4	C2	=AGGREGATE(15,6,ROW($A$2:$A$19)/($A$2:$A$19=$A$2),ROWS(C$2:C2))

 

[sksanjeev786]

That is not what I asked you to post. By trying to simplify it you are making it more complicated!

This is what you have asked for, good luck making it work. I give up!

Book1
	A	B	C
2	Q.BE2A Familiarity - India		2
3			11
4			19
5
6
7
8
9
10
11	Q.BE2A Familiarity - India
12
13
14
15
16
17
18
19	Q.BE2A Familiarity - India
Sheet8

Cell Formulas
Range	Formula
C2:C4	C2	=AGGREGATE(15,6,ROW($A$2:$A$19)/($A$2:$A$19=$A$2),ROWS(C$2:C2))

Hi Jason,

Sorry for the multiple queries I have posted. but as per this post formula definitely I will try from my end. and I get a solution I will share with you.

But thanks for your patients and give all response politely.

I know it very tough to understand what we demand.

but thanks for your time.

Will post on this once I get the solution how I want..

Regards,
sanjeev.

 

[sksanjeev786]

Hi Jason,

Sorry for the multiple queries I have posted. but as per this post formula definitely I will try from my end. and I get a solution I will share with you.

But thanks for your patients and give all response politely.

I know it very tough to understand what we demand.

but thanks for your time.

Will post on this once I get the solution how I want..

Regards,
sanjeev.

Hey Jason,

Glad to inform you that I got the solution with help of Match function I able to differentiate the row number column.

But sure I would like to appreciate your effort on formula.

Here we go..

=MATCH($H$2,OFFSET($A$1,C1,0,1000,1),0)+C1


Thanks
Regards,
Sanjeev

 

[jasonb75]

If you post a section if the finished product (similar to post 10) then we could see if there is a better way to do what you want.

 

[sksanjeev786]

Sure

If you post a section if the finished product (similar to post 10) then we could see if there is a better way to do what you want.

Sure Jason,

Will post in better ways for our further queries

But thanks again for your great support

Regards,
Sanjeev