View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dnereb
 
Posts: n/a
Default Show top five records based on meeting multiple criteria


It is possible in Excell but Access is far better for this (or any other
database)

to find the top 5 of something in a database youy can use a SQL query
like

"SELECT TOP 5 Table.Asset FROM Table"

BTW 1000 or more records of data should be stored in a database anyways


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=486512