ExcelBanter - EXCEL AUTOFILTER

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - EXCEL AUTOFILTER (https://www.excelbanter.com/excel-worksheet-functions/7197-excel-autofilter.html)

Aaron Neunz

EXCEL AUTOFILTER

Hello,
I have an Excel spreadsheet with 5657 records. When I use the autofilter
feature to filter by, for example, the last name column I only receive 1586
records in the drop down box. What gives?

Frank Kabel

Hi
see:
http://www.contextures.com/xlautofilter02.html#Limits

--
Regards
Frank Kabel
Frankfurt, Germany

"Aaron Neunz" schrieb im Newsbeitrag
...
Hello,
I have an Excel spreadsheet with 5657 records. When I use the
autofilter
feature to filter by, for example, the last name column I only
receive 1586
records in the drop down box. What gives?

All times are GMT +1. The time now is 06:27 AM.