Forum Discussion
Deleted
Jul 10, 2018copy cell to from different column using condation
Hello,
could you help me, I need to copy data from the date and value column from each row into one column only those have value using cell formula that loop until 1st cell the last column is not = date
it should work as follows
if cell in value 1 > 0 then copy date1 and value1 to dateAll and ValueAll else loop to do this for date2 and value2 until no date.
Date1 | Value1 | Date2 | Value2 | Date3 | Value3 | DateAll | ValueAll | |
28-Feb-2017 | 583 | 23-May-2018 | 691 | 05-Sep-2016 | 729 | 28-Feb-2017 | 583 | |
31-Mar-2017 | 583 | 23-Jun-2018 | 691 | 05-Oct-2016 | 729 | 31-Mar-2017 | 583 | |
30-Apr-2017 | 583 | 23-Jul-2018 | 0 | 05-Nov-2016 | 729 | 30-Apr-2017 | 583 | |
31-May-2017 | 0 | 23-Aug-2018 | 0 | 05-Dec-2016 | 729 | 23-May-2018 | 691 | |
30-Jun-2017 | 0 | 23-Sep-2018 | 0 | 05-Jan-2017 | 729 | 23-Jun-2018 | 691 | |
31-Jul-2017 | 0 | 23-Oct-2018 | 0 | 05-Feb-2017 | 0 | 05-Sep-2016 | 729 | |
31-Aug-2017 | 0 | 23-Nov-2018 | 0 | 05-Mar-2017 | 0 | 05-Oct-2016 | 729 | |
30-Sep-2017 | 0 | 23-Dec-2018 | 0 | 05-Apr-2017 | 0 | 05-Nov-2016 | 729 | |
31-Oct-2017 | 0 | 23-Jan-2019 | 0 | 05-May-2017 | 0 | 05-Dec-2016 | 729 | |
05-Jan-2017 | 729 |
No Replies