LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic swap of x- and y - axis (for John Peltier) Johannes Charts and Charting in Excel 1 April 4th 09 01:41 PM
For Jon Peltier dee Charts and Charting in Excel 2 July 25th 07 02:28 PM
Attn John Peltier Steve Charts and Charting in Excel 1 February 16th 06 03:24 AM
Jon Peltier Speedometer Chart thoemmes Excel Discussion (Misc queries) 6 June 7th 05 11:32 PM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 01:48 AM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"