| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to autofil a formula that is not recognised?
ok here goes! I have data in 1 tab... in another tab i want to be able to
show the ratio of sets of columns in tab1 so in theory all i want to do is get show is B2/C2 D2/E2 F2/G2 H2/I2 AND SO ON.... If i try to autocomplet across the row (i have do do this to 400 sets) excel will auto using b2/c2 c2/d2 d/e..... is there a way i can get it to skip ? many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to autofil a formula that is not recognised?
Not sure if this is overkill, but you could try something like this.
=INDIRECT(ADDRESS(2,CELL("col",B2)+COLUMN(B2)-2))/INDIRECT(ADDRESS(2,CELL("col",B2)+COLUMN(B2)-1)) HTH, Paul -- "edroberts77" wrote in message ... ok here goes! I have data in 1 tab... in another tab i want to be able to show the ratio of sets of columns in tab1 so in theory all i want to do is get show is B2/C2 D2/E2 F2/G2 H2/I2 AND SO ON.... If i try to autocomplet across the row (i have do do this to 400 sets) excel will auto using b2/c2 c2/d2 d/e..... is there a way i can get it to skip ? many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to autofil a formula that is not recognised?
thanks will give it a wirl
"PCLIVE" wrote: Not sure if this is overkill, but you could try something like this. =INDIRECT(ADDRESS(2,CELL("col",B2)+COLUMN(B2)-2))/INDIRECT(ADDRESS(2,CELL("col",B2)+COLUMN(B2)-1)) HTH, Paul -- "edroberts77" wrote in message ... ok here goes! I have data in 1 tab... in another tab i want to be able to show the ratio of sets of columns in tab1 so in theory all i want to do is get show is B2/C2 D2/E2 F2/G2 H2/I2 AND SO ON.... If i try to autocomplet across the row (i have do do this to 400 sets) excel will auto using b2/c2 c2/d2 d/e..... is there a way i can get it to skip ? many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to autofil a formula that is not recognised?
This should work... put this in any cell and copy across (you can also copy
down)... =INDEX(Sheet1!2:2,1,2*(COLUMN(A1)))/INDEX(Sheet1!2:2,1,2*(COLUMN(A1))+1) The 2:2 reference is because you specified row 2 in your sample. Rick "edroberts77" wrote in message ... ok here goes! I have data in 1 tab... in another tab i want to be able to show the ratio of sets of columns in tab1 so in theory all i want to do is get show is B2/C2 D2/E2 F2/G2 H2/I2 AND SO ON.... If i try to autocomplet across the row (i have do do this to 400 sets) excel will auto using b2/c2 c2/d2 d/e..... is there a way i can get it to skip ? many thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to autofil a formula that is not recognised?
Here's another version
=INDEX(tab1!2:2,,COLUMNS($A$1:A1)*2)/INDEX(tab1!2:2,,COLUMNS($A$1:B1)*2-1) -- Regards, Peo Sjoblom "edroberts77" wrote in message ... ok here goes! I have data in 1 tab... in another tab i want to be able to show the ratio of sets of columns in tab1 so in theory all i want to do is get show is B2/C2 D2/E2 F2/G2 H2/I2 AND SO ON.... If i try to autocomplet across the row (i have do do this to 400 sets) excel will auto using b2/c2 c2/d2 d/e..... is there a way i can get it to skip ? many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel | Excel Worksheet Functions | |||
| Formating not recognised in lookup formula | Excel Discussion (Misc queries) | |||
| = not recognised as formula (sometimes) | Excel Discussion (Misc queries) | |||
| Autofil a cell in the same row. | Excel Worksheet Functions | |||
| Standard sumif formula not recognised | Excel Worksheet Functions | |||
Linear Mode
