How to display row and column numbers in excel??

[cherhuang098]

Hi,

If you have a table array that consists of 13 rows and 7 columns and each of the 91 cells of the array contain a unique numerical value, how can I locate the correct row and column numbers for any given value? Please help thanks!

	1	2	3	4	5	6	7
1	1.02	2.32	3.62	4.92	6.22	7.52	8.82
2	1.17	2.47	3.77	5.07	6.37	7.67	8.97
3	1.32	2.62	3.92	5.22	6.52	7.82	9.12
4	1.47	2.77	4.07	5.37	6.67	7.97	9.27
5	1.62	2.92	4.22	5.52	6.82	8.12	9.42
6	1.77	3.07	4.37	5.67	6.97	8.27	9.57
7	1.92	3.22	4.52	5.82	7.12	8.42	9.72
8	2.07	3.37	4.67	5.97	7.27	8.57	9.87
9	2.22	3.52	4.82	6.12	7.42	8.72	10.02
10	2.37	3.67	4.97	6.27	7.57	8.87	10.17
11	2.52	3.82	5.12	6.42	7.72	9.02	10.32
12	2.67	3.97	5.27	6.57	7.87	9.17	10.47
13	2.82	4.12	5.42	6.72	8.02	9.32	10.62

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=7 width=47><TBODY>
</TBODY>

 

[Weazel]

if I'm understanding correctly then maybe something like....


Excel 2012

	A	B	C	D	E	F	G	H	I	J
1		1	2	3	4	5	6	7		4.82
2	1	1.02	2.32	3.62	4.92	6.22	7.52	8.82
3	2	1.17	2.47	3.77	5.07	6.37	7.67	8.97		row 9 column 3
4	3	1.32	2.62	3.92	5.22	6.52	7.82	9.12
5	4	1.47	2.77	4.07	5.37	6.67	7.97	9.27
6	5	1.62	2.92	4.22	5.52	6.82	8.12	9.42
7	6	1.77	3.07	4.37	5.67	6.97	8.27	9.57
8	7	1.92	3.22	4.52	5.82	7.12	8.42	9.72
9	8	2.07	3.37	4.67	5.97	7.27	8.57	9.87
10	9	2.22	3.52	4.82	6.12	7.42	8.72	10.02
11	10	2.37	3.67	4.97	6.27	7.57	8.87	10.17
12	11	2.52	3.82	5.12	6.42	7.72	9.02	10.32
13	12	2.67	3.97	5.27	6.57	7.87	9.17	10.47
14	13	2.82	4.12	5.42	6.72	8.02	9.32	10.62

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula J3 ="row "&SUMPRODUCT((B2:H14=J1)*ROW(A2:A14))-1&" "&"column "&SUMPRODUCT((B2:H14=J1)*COLUMN(B1:H1))-1 <tbody> </tbody>

<tbody>
</tbody>

 

[mumps]

Try this macro:

Sub FindAddress()
    Application.ScreenUpdating = False
    Dim foundVal As Range
    Dim searchVal As String
    searchVal = InputBox("Please enter the value to find.")
    Set foundVal = Range("A1:G13").Find(searchVal, LookIn:=xlValues, LookAt:=xlWhole)
    If Not foundVal Is Nothing Then
        MsgBox ("The value " & foundVal & " is in cell " & foundVal.Address(0, 0))
    Else
        MsgBox ("Value not found.")
    End If
    Application.ScreenUpdating = True
End Sub