Any Excel experts?

[Big Mike]

At work here, we use an Excel spreadsheet to keep track of the drawing numbers we assign to certain customers or projects.

It's up to around 3500 entires, so we use the Auto filters to quickly seach the columns.

We just found out that the auto filters are not searching the whole data base. For example, each line has a number cell, If I click the autofilter pull down above the number collumn, it only shows me the first 1000 numbers or so.

 

[Rob]

Yep, it's limited to 1,000 numbers. There are work arounds.

http://www.contextures.com/xlautofilter02.html

Rob

 

[Big Mike]

Thanks :thumbsup: