View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cloud
 
Posts: n/a
Default find the second value if it is a tie

suppose 23 degrees fall on 1st of jan and 31st of jan.

how do i use match,index so tat the answer will show 31st jan instead of
23rd jan and i am not allowed to use sorting.