Thread: formula to identify top 3 times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default formula to identify top 3 times
Assuming that the top three times are the lowest three times and that the
times are in column A, in B1 thru B3 enter:

=SMALL(A:A,1)
=SMALL(A:A,2)
=SMALL(A:A,3)

--
Gary''s Student - gsnu200809
Reply With QuoteReply With Quote