View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
varkeychaya varkeychaya is offline
external usenet poster
 
Posts: 1
Default Sorting to get the latest of a kind


Hi

I want to sort a table which contains the names of customers, dates and
transactions, such that when filtered it will contain only the latest
transaction of each customer. Customers should not be repeated.

any solutions???


--
varkeychaya
------------------------------------------------------------------------
varkeychaya's Profile: http://www.excelforum.com/member.php...o&userid=36590
View this thread: http://www.excelforum.com/showthread...hreadid=563321