Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

returning a cell reference


  • Please log in to reply

#1
bemiddy

bemiddy

    New Member

  • Member
  • Pip
  • 5 posts
hey all
I would like to know if there is a function that would return the abosule cell reference (b3) of something. i would like to use it in another match as the start of a listing in the following context

match(5, xx:b,0)so that it starts in a specific place. the data i have is ordered by date and then by a line number so i would like it to look for the first line 5 starting at such and such a date which would start at cell XX

what can I use to give me a value for the XX??? i ahve used the match function in place of the XX but it obviously only returns the postion of the matched item in the list that it searched. what can i use to give me a cell reference?

thanks

edited for clarity

Edited by bemiddy, 03 August 2005 - 08:00 AM.

  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP