• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Simple Excel problem

ThrottleWorks

Excel Ninja
Hi @NARAYANK991 sir, is it a puzzle, I thought for a while.
But could not think anything simpler than Control + G.

Hyperlink ? But that would be more complex than reference box.

Have a nice day ahead.
 

GraH - Guido

Well-Known Member
You use a very large screen? :DD
But you may not type the cell address anywhere. Not in the name box neither? (That field besides the formula bar)
Like this I mean: upload_2018-1-12_17-31-52.png
 

NARAYANK991

Excel Ninja
Hi John ,

I will go with #2.

I never knew that we could enter formulae in the GoTo Reference box.

My trial was by entering ZZ100000 in any worksheet cell , say A1 , and then using a formula :

=INDIRECT(A1)

in the CTRL G Reference box.

This also works if we create a named range GoToRef and assign it the text string ZZ100000 , and then use a formula :

=INDIRECT(GoToRef)

in the CTRL G Reference box.

Narayan
 

GraH - Guido

Well-Known Member
Hi, Narayank!

Some options:
1. In name box (with A1 selected):
R[99999]C[701] and hit Enter

2. In name box (or Reference box), type:
INDEX(A:ZZ,100000,702) or
OFFSET(A1,99999,701) and hit Enter

3. Alt + F11, Ctrl + G (Inmediate Window), put:
[ZZ100000].Select and hit Enter

Blessings!
Hi John,
Learning some new tricks here. Just wondering: you happen to know that ZZ is column 702?
 

GraH - Guido

Well-Known Member
Hi John ,

I will go with #2.

I never knew that we could enter formulae in the GoTo Reference box.

My trial was by entering ZZ100000 in any worksheet cell , say A1 , and then using a formula :

=INDIRECT(A1)

in the CTRL G Reference box.

This also works if we create a named range GoToRef and assign it the text string ZZ100000 , and then use a formula :

=INDIRECT(GoToRef)

in the CTRL G Reference box.

Narayan
Rather indirect solutions wouldn't you say, Naranyan?
 

GraH - Guido

Well-Known Member
Just put in any cell this:
=COLUMN(ZZ1)

Blessings!
Yes I knew about this. ;)
Hi ,

I wouldn't call it a solution ; what interested me was the fact that we could enter a formula in the GoTo Reference box , something that I did not know.

I wanted to pass on this learning.

Narayan
Obviously... I just had a hard time figuring out what you were after with your challenge. But I dig it.
I expected something more spectacular, that's all. But, like I said to John, did learn a new trick.:)
 
Top