Hello mostafa.elnazer and Welcome to Excel Forum.
In the attached file columns G:I fill in the missing rules, days and times then columns J:L match the temp, dewpt, and RH
The formula that populates column G is: =IF(ROW()=2,0,MOD(G1+1,24))
The formula that populates column H is:
Formula:
=IF(ROW()=2,B2,IF(COUNTIFS(H$1:H1,H1)<24,H1,H1+1))
The formula that populates column I is: =TIME(G2,0,0)
The formula that populates columns J:L is:
Formula:
=IFERROR(INDEX(D$2:D$605,AGGREGATE(15,6,(ROW($2:$605)-1)/($C$2:$C$605=$I2)/($B$2:$B$605=$H2),1)),"")
Let us know if you have any questions.
Bookmarks