#NA error on one System.

[tinferns]

The below is a perfectly fine hyperlink formula. On one system it works fine.. however on another system it throws an error. I believe there is some setting in EXCEL OPTIONS or WIN10 that I need to check or uncheck.

The below Hyperlink takes the cursor the last row containing data (TEXT or Numbers only)

=HYPERLINK("[Quickly jump to last row using hyperlinks.xlsx]Sheet1!$B$"&MATCH(CHAR(255),B1:B100,1)+1,"Hyperlink")

Please help.

Thanks

Martin

 

[steve the fish]

Looks to me like you will get that error if there is no text values in B1:B100.

 

[tinferns]

Hi Steve.. thanks for your reply. There is text between B1:B100.

I have tried the same formula on another system, with same content.. it works.. And on one system it gives #NA error.

Please help.

Thanks

Martin

 

[steve the fish]

Text or number? Type your name in b1. Does it still error?

 

[tinferns]

Thanks Steve for looking into this..

Created a File Named: Test File
Inserted this formula in Sheet1 - L3 : =HYPERLINK("[Test File.xlsx]Sheet1!$B$"&MATCH(CHAR(255),B1:B10,1)+1,"Hyperlink")
Typed tinferns in B1. And left cells from B2 - B10 blank.

L3 shows #NA

I wish i could take a screenshot and send.

Please help.

Thanks,

Martin

 

[steve the fish]

Its only this that can cause n/a:

=MATCH(CHAR(255),B1:B10,1)

What does it produce? What about this?

=LOOKUP(2,1/(B1:B10<>""),ROW(B1:B10))

 

[RoryA]

Which version of Windows and Office, and what regional settings are on the computer that doesn't work?

 

[tinferns]

Hi Steve.. This Hyperlink takes my cursor to the last updated cell +1 in that column. Its a huge file. Jumping to the top is easy... however jumping down is more helpful with this Hyperlink formula. Got this formula from LINK: https://www.get-digital-help.com/qu...in-a-data-set-using-excel-hyperlink-function/

I prefer a Hyperlink to get the job done. Can you think of another option ?

Please advise.

Thanks

Martin.

 

[tinferns]

Hi Rory.. I am using WIN10 for Home with MS office Home and Student 2019 students edition. I believe I have latest version of WIN10. Not sure about MS office. Lately I have updated both WIN10 and MS office and now Excel looks different and I seem to have lost Insert Comment right click option too. Is there something wrong here ?

Please advise

Thanks

Martin

 

[tinferns]

Hi Rory.. its a LICENCED MS Office home and student 2019 edition.