View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Find unique value in list (TIME), not working

Hello Michael,

Sounds like a rounding issue to me. Round your time values as well as
your search value to the second or sort them and match"guess" your
searchvalue, I suggest.

Change the time format of your time values and your search to General
for a moment and look how precise they are given...

Regards,
Bernd