Simple but I can't find it.
First Column are the date of a whole year and that every average 10 min
2nd column are times, every 10 min with exeptions of intermitend times with highest/lowest value of the 3th column
3th colum A hight ( number 0 which belong to the second column.
I made a macro but the problem is that the nummer of cels down, is never te same as some times I have a high or low value at for example 0:23. This makes the counting of a day mith more cels.
Ik have to work with MATCH, IF or a LOOKUP but cant find it for the moment.
Iff someone has a solution.
To make it short, I need daily a printed sheet with only the needed day and not the whole year.
Yes I could do a copy paste manualy to an other sheet, but I would like to have easy way.
First Column are the date of a whole year and that every average 10 min
2nd column are times, every 10 min with exeptions of intermitend times with highest/lowest value of the 3th column
3th colum A hight ( number 0 which belong to the second column.
I made a macro but the problem is that the nummer of cels down, is never te same as some times I have a high or low value at for example 0:23. This makes the counting of a day mith more cels.
Ik have to work with MATCH, IF or a LOOKUP but cant find it for the moment.
Iff someone has a solution.
To make it short, I need daily a printed sheet with only the needed day and not the whole year.
Yes I could do a copy paste manualy to an other sheet, but I would like to have easy way.
24-04-24 | 0:00:00 | 1.703 |
24-04-24 | 0:10:00 | 1.737 |
24-04-24 | 0:20:00 | 1.768 |
24-04-24 | 0:30:00 | 1.796 |
24-04-24 | 0:40:00 | 1.821 |
24-04-24 | 0:50:00 | 1.842 |
24-04-24 | 1:00:00 | 1.859 |
24-04-24 | 1:10:00 | 1.872 |
24-04-24 | 1:20:00 | 1.882 |
24-04-24 | 1:30:00 | 1.887 |
24-04-24 | 1:37:00 | 1.888 |
24-04-24 | 1:40:00 | 1.887 |
24-04-24 | 1:50:00 | 1.884 |
24-04-24 | 2:00:00 | 1.877 |
24-04-24 | 2:10:00 | 1.865 |
24-04-24 | 2:20:00 | 1.849 |
24-04-24 | 2:30:00 | 1.829 |
24-04-24 | 2:40:00 | 1.806 |
24-04-24 | 2:50:00 | 1.778 |
24-04-24 | 3:00:00 | 1.747 |
24-04-24 | 3:10:00 | 1.713 |