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?
edited for clarity
Edited by bemiddy, 03 August 2005 - 08:00 AM.