I am doing a Vlookup(match()) combo using this formula:
=VLOOKUP($H2,$B$1:$F$17731,MATCH($I$2,$C$1:$C$17731,0)+2,0)
where $H$2(col b) is the Date and $I$2 is the Time (col c).
This works for the first case of each date, but not for any duplicates after. There are a lot of repeats of the date because its a string of recorded data over a week. How would I avoid this issue?
Thank you for your time.
=VLOOKUP($H2,$B$1:$F$17731,MATCH($I$2,$C$1:$C$17731,0)+2,0)
where $H$2(col b) is the Date and $I$2 is the Time (col c).
Code:
b c d
07.29.2011 13.29 21.3559
07.29.2011 13.3 1.3814
07.29.2011 13.31 2.2505
07.30.2011 13.32 0
07.30.2011 13.33 2.3854
07.31.2011 13.45 -0.1838This works for the first case of each date, but not for any duplicates after. There are a lot of repeats of the date because its a string of recorded data over a week. How would I avoid this issue?
Thank you for your time.
