Using SMALL with IF possibly??

[Eoin Joyce]

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

[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