SOLVED

FORMULA NEEDED PLEASE.

Copper Contributor

In column B I have numbers from cell B6 on down just in the even numbered cells. Odd numbered cells are empty. I need to bring these numbers over to column C without the first and last numbers but with a zero at the end. I need a formula starting......=IF(J7="XYZ", etc. to be placed in C6. Example ,  the numbers 2 , 4 , 6 , 8 , 10 are in cells B6 , B8 , B10 , B12 and B14 and I want to get 4 , 6 , 8 , 0 into C6 , C8 , C10 and C12. Any help greatly appreciated.

3 Replies

@lorigraf_LORIl60 , are you looking for something like this?

best response confirmed by lorigraf_LORIl60 (Copper Contributor)
Solution

@lorigraf_LORIl60 Alternatively in C6 and copied down every other row, until you reach 0:

 

=IF(B10<>"",B8,0)

 

.... provided that you are aiming to copy the values on even numbered rows in column B.

See example attached!

Thanks so much.
1 best response

Accepted Solutions
best response confirmed by lorigraf_LORIl60 (Copper Contributor)
Solution

@lorigraf_LORIl60 Alternatively in C6 and copied down every other row, until you reach 0:

 

=IF(B10<>"",B8,0)

 

.... provided that you are aiming to copy the values on even numbered rows in column B.

See example attached!

View solution in original post