M
Miguel
I have two columns one is time and the other force values. I want to look for
two diferent times and get the average of the forces in that range of time. I
thought I could generalize this for several spreedsheets that I have. I
believe if I use the MATCH function to get the row position of the different
times and then simply use the average function with MATCH may work straight
away. I get a problem because the format average somehow does not recognice
MATCH. For instance my formule looks like:
forceaverage=AVERAGE(RMATCH(time1,R1C1:R5000C1,0)C3:RMATCH(time2,R1C1:R5000C1,0)C3).
time1 and time2 are my time values and R is row and C is column (the
absolute format used by excel). C3 is the column were the forces are. C1 is
the column of the time.R5000 is the last row value.
two diferent times and get the average of the forces in that range of time. I
thought I could generalize this for several spreedsheets that I have. I
believe if I use the MATCH function to get the row position of the different
times and then simply use the average function with MATCH may work straight
away. I get a problem because the format average somehow does not recognice
MATCH. For instance my formule looks like:
forceaverage=AVERAGE(RMATCH(time1,R1C1:R5000C1,0)C3:RMATCH(time2,R1C1:R5000C1,0)C3).
time1 and time2 are my time values and R is row and C is column (the
absolute format used by excel). C3 is the column were the forces are. C1 is
the column of the time.R5000 is the last row value.