Update old links to MrExcel with "board2"

[erik.van.geit]

Hi,

Some of my old links taken from previous MrExcel forum, do not get to the correct webpage anymore.
The following link pointed to a "last row formula" thread with Aladin Akyurek.

http :// www . mrexcel.com/ board2/viewtopic.php?t= 142787&start=6

Can something be done to get there?

kind regards,
Erik
PS: I had even trouble to paste the link; without spaces it converted to a "morefunc addin" thread.

Text was:

[1] If one is interested in the last numeric value in column A...
=LOOKUP(9.99999999999999E+307,Sheet1!A:A)
[2] If one is interested in the last text value (which can be a formula blank) in column A...
=LOOKUP(REPT("z",255),Sheet1!A:A)
Note that the lexical ordering is ASCII-based.
[3] If one is interested in any value (e.g., number, date, time, truth value (TRUE/FALSE), and error value...
=IF(ISBLANK(Sheet1!A65536),LOOKUP(2,1/(1-ISBLANK(Sheet1!A1:A65535)),Sheet1!A1:A65535),Sheet1!A65536)
This is a pretty expensive formula, so it should not be invoked in lieu if either [1] or [2].
What to invoke if column A consists of numbers (recall that dates and are also sumbers) and text like ""?
Obviously, [3] can be invoked. An alternative would be a set of fast formulas...
B1:
=MATCH(9.99999999999999E+307,Sheet1!A:A)
B2:
=MATCH(REPT("z",255),Sheet1!A:A)
B3:
=INDEX(Sheet1!A:A,CHOOSE(COUNT(B1:B2)+1,"",SUMIF(B1:B2,"<>#N/A"),MAX(B1:B2)))

 

[Aladin Akyurek]

Hi,

Some of my old links taken from previous MrExcel forum, do not get to the correct webpage anymore.
The following link pointed to a "last row formula" thread with Aladin Akyurek.

http :// www . mrexcel.com/ board2/viewtopic.php?t= 142787&start=6

Can something be done to get there?

kind regards,
Erik
PS: I had even trouble to paste the link; without spaces it converted to a "morefunc addin" thread.

Text was:

Dag Erik,

We have a big problem after the update. The links do not work.

I have looked for the one you mention using Google half hour long with different search terms... The following delivered the good:

site: mrexcel lexical ordering aladin

The result is Post #7 in:

http://www.mrexcel.com/forum/excel-questions/137803-display-last-entry-column.html

 

[erik.van.geit]

Dankjewel voor je antwoord, Aladin!
And thanks for the effort to find it: this si one of those useful posts you made here.

So it is a general problem which is not solved (yet).

Greatings from Belgium
Have a nice weekend!
Erik

 

[erik.van.geit]

It's a pain for links within threads. Users can get confused
Example: http://www.mrexcel.com/forum/mrexcel-mvps/186164-creating-deleting-comboboxes-involve-problems.html