vba needed

  • Thread starter Thread starter alistair01
  • Start date Start date
A

alistair01

I have a worksheet which is linked to Access providing me with a
database which produces a variety of stats etc. What i would like to
do is to look in a column of this database and when two rows of data
match record the time difference between the two occurances. The data
is based on alarms and response times. a pair of matching cells will
have a unique id number. Im not sure where to start tho some sort of if
statement and some coping and pasting may be involved.The date time is
in column b the alarm id is in column M with various other data in
between. Thank you in advance for any suggestions!
 
You could sort the spreadheet on the ID number and make another column
with a formula that says if this row id =next row id then this row time
minus next row time - otherwise zero. Format the column as time.

Something like :-
=IF(M1=M2,B1-B2,0)
 
Back
Top