hi,
I am trying to get excel to display the first number greater than 0 from one row into another row followed by the second number so on, so on. i.e. page 2- 2g=0, 2h= 0, 2i = 10, 2j= 11, 2k= 12 then page 1- b2= 10, c2= 11, c3= 12.
however page 2's first number location in the row can change i.e- page2 - 2g=10, 2h= 11, 2i= 12
Can anyone help please? hopefully his makes sense
Bookmarks