Thread: How do I use a pivot table to present data, not sum or count it.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mallycat Mallycat is offline
external usenet poster
  
Posts: 1
Default How do I use a pivot table to present data, not sum or count it.

Assuming for each name, there is only one exam and 1 date, try using the
min or max option instead of count or sum. format the max of date field
to be a date.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561261

Reply With QuoteReply With Quote