Any Excel experts?

Discussion in 'Off Topic Chat' started by Big Mike, Mar 16, 2006.

  1. Big Mike

    Big Mike I am Big, I am Mike Staff Member Supporting Member

    Joined:
    Dec 16, 2003
    Messages:
    33,821
    Likes Received:
    1,811
    Location:
    Edmonton
    Can others edit my Photos:
    Photos NOT OK to edit
    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.
     
  2. Rob

    Rob TPF Noob!

    Joined:
    Jan 29, 2005
    Messages:
    6,217
    Likes Received:
    134
    Location:
    London
  3. Big Mike

    Big Mike I am Big, I am Mike Staff Member Supporting Member

    Joined:
    Dec 16, 2003
    Messages:
    33,821
    Likes Received:
    1,811
    Location:
    Edmonton
    Can others edit my Photos:
    Photos NOT OK to edit
    Thanks :thumbsup:
     

Share This Page