Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

EXCEL search help!!

Options
  • 14-07-2003 8:50pm
    #1
    Villain
    Registered Users Posts: 15,946 ✭✭✭✭


    Hi I have a excel workbook with over 20,000 entries I need to be able to find the top ten Id's occuring in the workbook but the number is in a cell containg text i.e.

    User "mx\B018" ..........

    I need to be able to search the cells and find the top ten occuring id's.

    Any idea's??


Comments

  • Options
    #2
    Boberto
    Registered Users Posts: 353 ✭✭Boberto


    Hmm, if you select all cells you want to browse including their headings and then go to Data/Filter and AutoFilter it will add drop down buttons to let you see the top 10 occuring entries in that column or you can select each particular entry and it will change the spreadsheet to list each occurence of that entry. That should work fine.

    I'd advised that you save it first in case anything goes wrong. Let me know if that works out.


Advertisement