I have data in 4 cloumns. Starting from column A the numbers are: 10, 20,30, 40
I want to create a named range which will give me the first, and third numbers meaning it would give me numbers, 10 and 30. This is the formula I have:
=MOD(COLUMN(A1:A4),2). I called the named range "Actual"
I want this array so I can graph it on a line chart.
I want to create a named range which will give me the first, and third numbers meaning it would give me numbers, 10 and 30. This is the formula I have:
=MOD(COLUMN(A1:A4),2). I called the named range "Actual"
I want this array so I can graph it on a line chart.