View Single Post
  #4   Report Post  
Gary's Student
 
Posts: n/a
Default

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