Thread: How to get the latest data from a workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How to get the latest data from a workbook
Hi,

Have a go with following array formula : (to be entered with
Control+Shift+Enter)

=MAX(IF(($A$1:$A$4000=A1),$D$1:$D$4000))

Provided your items in column A and your dates in column D

HTH
Cheers
Carim

Reply With QuoteReply With Quote