Search returning ans in terms of Rows & Columns
If your answer is in A2, then
=ADDRESS(1,MATCH($A$2,A1:F1,0),4,1)
gives C1.
Regards,
Stefi
€˛Will€¯ ezt Ć*rta:
Hi,
Can excel search which cells my answers belong to?
example:
A B C D E F
4 2 3 6 7 9
Lets say my ans is "3"
it will show "number 3 belong to (C,1)"
|