Jon Peltier question: use of MATCH
I am trying to use the match command. From the Excel help file I built this
line of code
test_variable = MATCH(39000,B2:B8,1)
I added "test_variable =" to what I copied from the Excell file.
Excel does not like the colon between the B2 and B8 saying it wants a
separator.
The line from Jon's original note was
Name: ET
Refers To: =MATCH("Elapsed Time",Sheet1!$1:$1,0)
Excel doesn't like either one. How do I get this match to work?
--
Bryan Kelly
Time is the medium we use to express out priorities.
|