Tenspeed39355
03-26-2006, 06:19 AM
Good morning guys. I am having a problem getting the rows to move using the following. =ADDRESS(2,MATCH(A2, A2:H2,0)+2,4)
There is no problem in getting the correct ADDRESS or MATCH. I have learned to use the +2 to get the correct cell. The problem is I have a number of rows. After I get the correct cell and row I do a pull down to get the next column and row. The cell will come up correctly but the row will stay the same. Example. B2,C2, H2. I should be seeing the following
B2,C3,H4. What am I doing wrong? I also see that when I do a pull down
all the number change to the corosponding row except the 2 before the MATCH command. Thanks for you time with this
Max
There is no problem in getting the correct ADDRESS or MATCH. I have learned to use the +2 to get the correct cell. The problem is I have a number of rows. After I get the correct cell and row I do a pull down to get the next column and row. The cell will come up correctly but the row will stay the same. Example. B2,C2, H2. I should be seeing the following
B2,C3,H4. What am I doing wrong? I also see that when I do a pull down
all the number change to the corosponding row except the 2 before the MATCH command. Thanks for you time with this
Max