Loop? to count missing data from work with several columns and with column names which change names between the analysis (dates)
I have a question that I hope this community can help me with. I wish to add a column showing the consecutive days missing from the last day and backwards. I also wish to add a column counting the days where the result is higher than 0.02 from 7 columns.I have found a solution for both by using a series of if statements but wish to learn if it can be done in a more elegant way, maybe by using a lo...