Jul 05 2020 03:48 PM
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.
Jul 05 2020 04:52 PM
@lorigraf_LORIl60 , are you looking for something like this?
Jul 05 2020 11:08 PM - edited Jul 07 2020 09:34 PM
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!
Jul 05 2020 11:08 PM - edited Jul 07 2020 09:34 PM
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!