Max Reference func?

[Joe Blow]

Hi,

I need a func to find a max reference.

I have up to 52 references, ie wk1, wk2, wk3, ..... up to wk52.
However, they are defined periodically, not all at once or on a
regular basis. I want to have a function that returns the max or last
one added reference.

Any help would be greatly appreciated!

Regards,
Joe

 

[Ken Wright]

Assuming data is in row 4, then the following will return the last value in row
4:-

=LOOKUP(REPT("z",255),4:4)

 

[Joe Blow]

Assuming data is in row 4, then the following will return the last value in row
4:-

=LOOKUP(REPT("z",255),4:4)

Hi Ken,

the data is not in any row or column. The reference is a name for a x
number of rows and x number of columns

Any ideas,
Joe

 

[Joe Blow]

Hi Ken,

the data is not in any row or column. The reference is a name for a x
number of rows and x number of columns

Any ideas,
Joe

I am still in the need of some assistance...

I have some number of names, ie wk2, wk6, wk8, wk9 & wk10, the list
of named references could go out to wk52

I have 1,2,3,...52 in rows b3:b54

I am trying to determine the last named reference.

I have been looking at some thing like
=if(isref(indirect("wk"&(b3:b54))),1,0) but that doesn't work

What is need is the last number, in this case 10, for the last valid
reference.

Any help would be appreciated.

Joe

 

[Aladin Akyurek]

Are you saying that you have the sequence 1,2,...,52 in B3:B54 and you have
corresponding entries in C3:C54 like wk1, wk2, etc.
And that you want the last entry in C and return the value associated from
B3:B54?

 

[Frank Kabel]

Hi Joe
see your replies in your other post