How to use Indirect function?

[Eric]

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

 

[Sheeloo]

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

This will add 1 to AC591

 

[Eric]

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

 

[Eric]

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]

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]

 

[Sheeloo]

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