Column References

[bigbadlee]

Hi all

Is it possible for a column to have 2 columns as a reference

Like this:-
Book1.xlsx

I would like this to be dynamic and not done with cut and paste. So as values are entered into Columns A and B then Column C is updated.

Any help is greatly appreciated

Thanks

[shg]

I n C2 and copy down as far as necessary,

=IF(COUNT($A$2:$B$65536) < ROWS(C$1:C2) - 1, "", INDEX($A$2:$B$65536, INT(ROWS(C$1:C2)/2), MOD(ROWS(C$1:C2), 2) + 1) )

[bigbadlee]

Hi shg,

Thanks for the reply, however when I've put the formula in C2 and copied down I get this result when column B is yet to have data input

Book1.xlsx

Is it something I've done ?

Thanks again for the help

[shg]

So your first example was incomplete?

What's the next one?

[bigbadlee]

No,No, Don't get me wrong. The formula is great!. I was only wondering why the zeroes appear?

[shg]

It's the blank values in column B converted to a number (0).