Following on from my previous question: How to calculate an average value based on duplicate groups?
I am trying to create a column "Data for Standard Time" which will contain values matching a certain time associated with the column "Rounded Time". E.g. I want to match the time in A2
with the same time in the D
column and then get the data from the I
column:
The formula I use in K2
is:
=INDEX($I$2:$I$19,MATCH(A2,$D$2:$D$19,0))
But I receive an error and unfortunately, I cannot see why. I tested this by making sure all cells contained values but it made no difference.
Type = 1
which should be numbers. I cannot see what else is wrong, I will try and upload this on a public server.A2
andD2
exactly the same. Then recalculate the sheet. Does your formula work then? (FYI; we don't like to download files from questions for security reasons)