Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative addressing
Hi
What I want to do is as follows. In an EXCEL file which I get every month with a changing number of lines in it, at the top of the file in any 2 cells, I want to put the beginning row number in one and the ending row number in the second, i.e., 4 in P1 and 688 in P2. Then in a blank column I want to use the TEXT function =TEXT(A4,€ť000€ť) to convert a number like 4 to text 004. (in the past I have done a cut and paste down the entire column). It would be easier to be able to use the P1 and P2 cells as relative addresses in the TEXT function, but I cant seem to convince EXCEL of that. I would also like to be able to use the CONCATENATE function to combine columns A, B, C, G, H, and I into one column also using the relative addresses of the beginning and ending rows. I am hoping to put this into a MACRO to make it a €śquicker clicker€ť. Thanks, Dot |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative addressing
DOGMA-DOT wrote:
Hi What I want to do is as follows. In an EXCEL file which I get every month with a changing number of lines in it, at the top of the file in any 2 cells, I want to put the beginning row number in one and the ending row number in the second, i.e., 4 in P1 and 688 in P2. Then in a blank column I want to use the TEXT function =TEXT(A4,"000") to convert a number like 4 to text 004. (in the past I have done a cut and paste down the entire column). It would be easier to be able to use the P1 and P2 cells as relative addresses in the TEXT function, but I can't seem to convince EXCEL of that. I would also like to be able to use the CONCATENATE function to combine columns A, B, C, G, H, and I into one column also using the relative addresses of the beginning and ending rows. I am hoping to put this into a MACRO to make it a "quicker clicker". Thanks, Dot Hi Dot, I think I don't understand what you're trying to do, but I think you can try to use the INDIRECT function... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
How to convert relative to absolute addressing instantly in Excel | Excel Discussion (Misc queries) | |||
Relative Addressing | Excel Discussion (Misc queries) | |||
Offset() relative addressing Row parameter | Excel Worksheet Functions | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |