Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column reference and column count
I have a 240 column row (row 1) with zeros except for one cell 0. I need a
formula in 240 columns of row 2 that will: if cell in row 1 0 then begin column count for # of columns specified (a variable) and display another varaible until column count = # of columns specified else the cell =0 I think the key is creating an absolute reference from the cell in row 1 0, but I cannot find the right mix of column / index and ? functions. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column reference and column count
I came up with a simple solution that I tried to post but it abended. Tahnks
to all who noodled on this. "Steve-in-austin" wrote: I have a 240 column row (row 1) with zeros except for one cell 0. I need a formula in 240 columns of row 2 that will: if cell in row 1 0 then begin column count for # of columns specified (a variable) and display another varaible until column count = # of columns specified else the cell =0 I think the key is creating an absolute reference from the cell in row 1 0, but I cannot find the right mix of column / index and ? functions. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Maintain Relative Reference After Inserting a Column | Excel Worksheet Functions | |||
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions |