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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Line Up Two Columns In Excel 2
Search two columns in list for first and last name and return Id 4
Finding the next same rank in data 4
how to match matched ID and name columns to organized ID column 1
VBA- IF statement to replace cell contents 0
Need help on formula. 6
Need formula to add cells with same group 1

Back
Top