EXCEL search help!!

Villain · 2003-07-14 19:50:51

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??

14-07-2003 07:50PM

#1

Villain

Registered Users, Registered Users 2 Posts: 15,744 ✭✭✭✭

Join Date: November 2002

Posts: 15112

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??

0

Comments

#2 15-07-2003 01:09PM

Boberto

Registered Users, Registered Users 2 Posts: 353 ✭✭

Join Date: December 2002

Posts: 319

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.

0