Dear Experts ,
I have a excel table with many values , I want the SIMPLEST FORMULA to list the row number(s) of this match.
[TABLE="width: 192"]
[TD="width: 64"]Row
[/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="align: right"]1
[/TD]
Name
[/td][td]Age
[/td][/tr][tr]
[TD="align: right"]2[/TD]
A
[/td]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
B
[/td]
[TD="align: right"]78[/TD]
[TD="align: right"]4[/TD]
C
[/td]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
A
[/td]
[TD="align: right"]51[/TD]
[TD="align: right"]6[/TD]
D
[/td]
[TD="align: right"]13[/TD]
[TD="align: right"]7[/TD]
A
[/td]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
K
[/td]
[TD="align: right"]13[/TD]
value
[/td][td]A
[/td]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[/TABLE]
Thanks,