segrigation of data in 2 cell

[lathish]

Agaram	0
	55712
	63218
	64023
	65680
	77505
	87426
Agrahara Dasarahalli	0
	33781
	41899
	43793
	47209
	52903
	55021
	77701
	78606
	86772
	88212
	88880
Anjanapura	0
	39902
	42271
	44409
	44411
	53203
	60584
	66704
	70210
	71236
	77731
	78736
	78876
	82186
	85897
	86714
	88605
	88898
	90533
	90856

<colgroup><col><col></colgroup><tbody>
</tbody>

so i want get answer like
in one column 67654 and next column agaram , Anjanapura

 

[Peter_SSs]

so i want get answer like
in one column 67654 and next column agaram , Anjanapura

In your sample data I cannot see any connection between 67654, agaram and Anjanapura

I think you will need to spell it out more clearly.

 

[lathish]

In your sample data I cannot see any connection between 67654, agaram and Anjanapura

I think you will need to spell it out more clearly.

in agaram 1234
4567
7890
in anjanpura 1234
7654
7868

sir i expect the answer like in one columu 1234 next column agaram and anjanapura

 

[Peter_SSs]

in agaram 1234
4567
7890
in anjanpura 1234
7654
7868

sir i expect the answer like in one columu 1234 next column agaram and anjanapura

OK, in that sample I can see the link but in the first post 67654 was nowhere to be seen.

Now, to further clarify, could there be multiple values that occur in more than one list and if, so, do you want them all listed or are we being given a specific number like 1234 and asked which groups it is in?

For example, can you give and explain the expected results for this data if it is relevant data.

BTW, if you could provide data samples like this where we can clearly see what rows and columns the data is in it would mean that people could help you much easier. My signature block below has help on that.

Excel 2016
	A	B
1	Agaram	0
2		56987
3		12345
4		65324
5		98765
6	Agrahara Dasarahalli	0
7		65324
8		88888
9	Anjanapura	0
10		12345
11		78878
12		65324
13		74215
14		88888
Sheet1