On Mon, 04 Aug 2008 14:22:03 GMT, Lars-Åke Aspelin
wrote:

On Mon, 04 Aug 2008 07:43:10 -0600, Howard Brazee
wrote:

On Fri, 1 Aug 2008 14:20:07 -0700 (PDT), GTVT06
wrote:

On Aug 1, 4:17*pm, GTVT06 wrote:
Hello, try this in cell C37

=INDIRECT("$C$"&ROW(INDEX($B$2:$B$36,MAX(($B$2:$B$ 36=$C$37)*ROW($B$2:$B
$36))-ROW(OFFSET($B$2:$B$36,0,0,1,1))+1)))

I got a circular reference.

Forgot to tell you this has to be entered in as an array using Ctrl
+Shift+Enter after you put in the formula. this should encase the
formula in { } brackets when entered in correctly.

I'm not familiar with this, but I copied the formula to a text editor,
moved it to one line, then copied it to cell C37, pasted it, hit
Ctl/Shift/Enter and it put brackets around it. But it displayed a
zero.

Could you explain what this did, so that I can try to debug it?
Thanks.


Try changing the $C$37 to $B$36 in the formula above.
(The formula should still be in cell C37)

Lars-Åke

Sorry, I meant, "change $C$37 to $B$37"