hi,

try to use a Pivot table

hth
regards from Brazil
Marcelo

"varkeychaya" escreveu:


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