Thread: A Search Engine inside Excel Spreadsheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default A Search Engine inside Excel Spreadsheet
Autofilter will work for more than 1000 unique entries. But the list under the
dropdown is limited to 1000 unique entries. You can use a custom filter and
type in the value, though.

gjcase wrote:

Have you tried using an Autofilter on the namelist? It wwill work for
up to 1000 entries.

---GJC

--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527619

--

Dave Peterson
Reply With QuoteReply With Quote