View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jball jball is offline
external usenet poster
 
Posts: 1
Default Highest Date based on a number of criteria

Hi all,

Say I sell ice creams from different stores and want to know the most recent
date a sale was made from a specified store and flavour.

Flavour Store Date
Chocolate A 1/09/2009
Chocolate B 1/09/2009
Vanilla A 1/09/2009
Vanilla A 2/09/2009

Eg, If Flavour = Vanilla, If Store = A, what is the most recent date a sale
was made.
I wish this to be a formula. Any suggestions?
Thanks.