Question

ruby怎样读取excel中的数值,并返回行列号

如图，怎样根据内容111查询到行列号并且输出来

Answer 1

=ADDRESS(SUMPRODUCT(($A$1:$C$5=111)*ROW($1:$5)),SUMPRODUCT(($A$1:$C$5=111)*COLUMN($A:$C)))

Answer 2

要用VBA的循环比对才能解决,
Sub asdf()
Dim aa

For Each aa In Range("A1:C5")
If aa.Value = "111" Then MsgBox aa.Address
Next
End Sub