vba needed

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!
 
B

BrianB

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)
 
Top