In cell A52 enter =MATCH(215,A3:A51,0)
Then copy this formula from B52 through Z52.
If there is only one instance of 215 in the data area, then all the formulae
will show #N/A except one.
For example, if the 215 is in cell C15, then C52 will show 13. Thus we know
that the 215 is in column C and is in the thirteenth row of the data block
(fifteenth row of the worksheet.
--
Gary's Student
"Mr. Snrub" wrote:
yes
|