How to use Indirect function?
 

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to use Indirect function?
 

Use this in cell AC593
=INDIRECT("R591C"&COLUMN(),FALSE) + 1
and copy across

This will add 1 to AC591
"Eric" wrote:

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to use Indirect function?
 

Thank you very much for suggestions
Could you please interpret what INDIRECT("R591C"&COLUMN(),FALSE) is doing?
I don't understand what "R591C" is about.
Thank you for any suggestions
Eric

"Sheeloo" wrote:

Use this in cell AC593
=INDIRECT("R591C"&COLUMN(),FALSE) + 1
and copy across

This will add 1 to AC591
"Eric" wrote:

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to use Indirect function?
 

Do you have any suggestions on converting following codes into your specific
format?
=CONFIDENCE(0.05,2,INDIRECT("AB"&591-AB595+1):AB591)
Thank you very much for any suggestions
Eric

"Sheeloo" wrote:

Use this in cell AC593
=INDIRECT("R591C"&COLUMN(),FALSE) + 1
and copy across

This will add 1 to AC591
"Eric" wrote:

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to use Indirect function?
 

False implies R1C1 style reference

In case you don't know,
A1 would be R1C1 [Row 1 Col 1 i.e. Col A]
D4 would be R4C4 [Row 4 Col 4 i.e. Col D]

How to use Indirect function?
 

I am not clear on what do you want INDIRECT("AB"&591-AB595+1):AB591 to
represent? What is the range you want?

"Eric" wrote:

Do you have any suggestions on converting following codes into your specific
format?
=CONFIDENCE(0.05,2,INDIRECT("AB"&591-AB595+1):AB591)
Thank you very much for any suggestions
Eric

"Sheeloo" wrote:

Use this in cell AC593
=INDIRECT("R591C"&COLUMN(),FALSE) + 1
and copy across

This will add 1 to AC591
"Eric" wrote:

Does anyone have any suggestions on how to use Indirect function?

Under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, does anyone have any
suggestions on keeping the "AC" changing based on located column?
This is what I want under column AD, INDIRECT("AD"&591+1) in cell AC593.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric