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
|