Max Reference func?

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

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
 
Assuming data is in row 4, then the following will return the last value in row
4:-

=LOOKUP(REPT("z",255),4:4)
 
Assuming data is in row 4, then the following will return the last value in row
4:-

=LOOKUP(REPT("z",255),4:4)
Click to expand...

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
 
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
Click to expand...

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
 
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?
 
Back
Top