| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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] |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect Function | Excel Worksheet Functions | |||
| using the INDIRECT function | Excel Discussion (Misc queries) | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Need help on Indirect function | Excel Discussion (Misc queries) | |||
| Help with Indirect function ? | Excel Worksheet Functions | |||
Hybrid Mode
