How to find Row number and column number

[Farooqui Noor]

I have some numbers in sheet No.1 and in sheet No. 2 i want to write Row number and column number of each number present in sheet No.1 by formula. is it possible.

nn.xlsx
	H
11
Sheet1

nn.xlsx
	A	B	C	D
1
2	Number	Row Number	Column Number
3	1	6	3
4	2	?	?
5	3	?	?
6	4	?	?
7	5	?	?
8	6	?	?
9	7	9	5
10	8	?	?
11	How to find row number and column number by formula
12
Sheet2

nn.xlsx
	A	B	C	D	E	F	G	H	I	J
1	1	2	3	4	5	6	7	8	9	10
2
3
4
5
6			1				4
7
8			6			2
9					7		5
10
11			3				8
12
13
14
15
16
Sheet1

 

[Farooqui Noor]

the answer in the form of cell number and column number of unique number is correct. No problem. But the answer of the number used twice in the sheet is wrong. in above sheet 320 number is written two times and it is mandatory. So answer of first 320 number should be cell number 16 and column number should be 12. and answer of second 320 number should be cell number 28 and column number should be 13. But after using the formula the answer of 320 number displayed is cell number 42 and column number 25, which is wrong.

 

[Fluff]

Maybe

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1	1	2	3	4	5	6	7	8	9	10
2
3
4					4
5
6			1				4
7
8			6			2
9					7		5
10		3
11			3				8
Sheet1

Fluff.xlsm
	A	B	C
1
2	Number	Row Number	Column Number
3	1	6	3
4	2	8	6
5	3	10	2
6	4	4	5
7	5	9	7
8	6	8	3
9	7	9	5
10	8	11	7
11	4	6	7
12	3	11	3
Sheet2

Cell Formulas
Range	Formula
B3:B12	B3	=AGGREGATE(15,6,ROW(Sheet1!$A$2:$A$11)/(Sheet1!$A$2:$J$11=A3),COUNTIFS(A$3:A3,A3))
C3:C12	C3	=MATCH(A3,INDEX(Sheet1!$A$2:$J$11,B3-1,0),0)

 

[Farooqui Noor]

Fluff Sir I am very much thankful for your cooperation and your valuable time. My query has been resolved with the formula provided by you sir. thanks once again.​

 

[Fluff]

You're welcome & thanks for the feedback.