HI
I have log of events in a spreadsheet (small example attached) with data arranged in several groups with a common reference for each group in Column A. Interspersed are single rows of data.
Column F contains dates and these are time stamps for an entry of data. I need to find the two smallest values in each group and deduct the smaller from the larger to get a response time with a 0 where a row has only a single value.
I have been trying to use the SMALL and IF functions, but am getting bogged down and suspect my approach is too simple.
Could anyone help please?
Eoin Joyce
Guess what? I solved my own problem. If I make a unique filter to A20 for column A, the formula to enter from B20 for the 2nd lowest value is:
=SMALL(IF($A$5:$A$18=A20,$F$2:$F$15,""),2)
I can easily adapt (use 1 as the last digit) to put a lowest value in column C and subtract to D get a response time. Just had to make sure the data in Col A is formatted as text. This is what stopped the calculation driving me to frustration.
Thanks to me this time!!
Eoin
Last edited by Eoin Joyce; 09-21-2011 at 06:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks