Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing by 1 in every other column
Cells L3 and M3 are merged cells. The formula in cell L3 is:
=IF(Period_End=COLUMN(L1)-11,VLOOKUP(COLUMN(L1)-11,Period_End_Lookup,2),"") = May 2007 Cells N3 and O3 are also merged cells. The formula in cell N3 is: =IF(Period_End=COLUMN(N1)-12,VLOOKUP(COLUMN(N1)-12,Period_End_Lookup,2),"") = Jun 2007 Notice that I had to hard-code 11 in the 1st formula, and 12 in the second formula in order for the dates to come out correctly. Rather than hard-code any numbers, I would prefer to use an algorithm within the existing formulas that would increment the count by 1 even though the formulas are located in every other column. Any help/guidance would be greatly appreciated. Thanks, Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing by 1 in every other column
Try substituting this for the number 11. When copied, it should increment as
you want. (INT(COLUMN(L1)/2)+5) HTH, Elkar "Bob" wrote: Cells L3 and M3 are merged cells. The formula in cell L3 is: =IF(Period_End=COLUMN(L1)-11,VLOOKUP(COLUMN(L1)-11,Period_End_Lookup,2),"") = May 2007 Cells N3 and O3 are also merged cells. The formula in cell N3 is: =IF(Period_End=COLUMN(N1)-12,VLOOKUP(COLUMN(N1)-12,Period_End_Lookup,2),"") = Jun 2007 Notice that I had to hard-code 11 in the 1st formula, and 12 in the second formula in order for the dates to come out correctly. Rather than hard-code any numbers, I would prefer to use an algorithm within the existing formulas that would increment the count by 1 even though the formulas are located in every other column. Any help/guidance would be greatly appreciated. Thanks, Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing by 1 in every other column
Elkar,
Your formula segment did the trick. Thanks a million! Bob "Elkar" wrote: Try substituting this for the number 11. When copied, it should increment as you want. (INT(COLUMN(L1)/2)+5) HTH, Elkar "Bob" wrote: Cells L3 and M3 are merged cells. The formula in cell L3 is: =IF(Period_End=COLUMN(L1)-11,VLOOKUP(COLUMN(L1)-11,Period_End_Lookup,2),"") = May 2007 Cells N3 and O3 are also merged cells. The formula in cell N3 is: =IF(Period_End=COLUMN(N1)-12,VLOOKUP(COLUMN(N1)-12,Period_End_Lookup,2),"") = Jun 2007 Notice that I had to hard-code 11 in the 1st formula, and 12 in the second formula in order for the dates to come out correctly. Rather than hard-code any numbers, I would prefer to use an algorithm within the existing formulas that would increment the count by 1 even though the formulas are located in every other column. Any help/guidance would be greatly appreciated. Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
incrementing | Excel Discussion (Misc queries) | |||
Incrementing a hexidecimal column | Excel Discussion (Misc queries) | |||
sorting and incrementing down | Excel Discussion (Misc queries) | |||
Variable Incrementing | Excel Discussion (Misc queries) | |||
incrementing column symbols orthogonally? | Excel Worksheet Functions |