How to count the number of entries sorted or filtered in an Excel sheet
Thread poster: Klaus Urban

Klaus Urban  Identity Verified
Local time: 13:54
Member (2005)
English to German
+ ...
Aug 23, 2009

In connection with my various translations of English rose books into German, I have compiled a very comprehensice data base of rose names and synonyms, currently 25,000 entries. Printing out would result in 500 pages.
Filtering the column "breeder" shows a drop down menue of breeders in alphabetical order.

Can I sort or filter by breeder in decreasing order of roses introduced (some breeders have introduced 1000 or even more roses)?
I need this to select tho most important breeders by number of introductions.

Any help will be most welcome.
Klaus


 

Gianni Pastore  Identity Verified
Italy
Local time: 13:54
Member (2007)
English to Italian
Is there a standalone "number of roses" column? Aug 23, 2009

I think you don't need any filter. A simple Z-A order will do it.

If I got it right, you should try this:

- Cut the "number of roses" column and paste it at the right far side of the sheet (it must be the last column on the right)

- Click on the last cell of the "number of roses" (let's say cell M24256), drag the mouse towards left and than to the top to select the whole sheet.

- Click on the Z-A button in the main menu. You should see the breeders by number of introduction.

Hope this helps
Gianni

PS (Always make copy of the file!)icon_biggrin.gif

[Edited at 2009-08-23 08:51 GMT]


 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 13:54
English to Czech
+ ...
Subtotals Aug 23, 2009

Well, I suppose you do not have a "number of roses introduced" column. In that case you can use the Subtotals function in Excel.

A short how-to:
http://www.ehow.com/how_9702_subtotals-totals-excel.html

And a longer one with screenshots:
http://articles.techrepublic.com.com/5100-10878_11-1041751.html

Subtotals will not destroy your database, but make a backup copy anyway!


 

Klaus Urban  Identity Verified
Local time: 13:54
Member (2005)
English to German
+ ...
TOPIC STARTER
@ Gianni and Hynek Aug 24, 2009

Thank you for your suggestions.
Indeed, I do not have "number of roses introduced" column in my Excel sheet. I tried the "subtotal" solution, but it did not work.
What I have is one column with rose names and one column with the breeder name to each rose.Most breeders have introduced more than one rose, so their name appears again and again. When sorting by breeder, I want to count the number of roses introduced by that breeder that is how often this breeder´s name appears in the breeder column.
What I could do is copying this section of my Excel sheet into a blank Excel sheet and check the number of roses listed for that breeder.
There are 800 to 1000 breeders in my data base, therefore I was looking for a more elegant, automatic approach.
Hope this clarifies the situation.
Best regards
Klaus


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to count the number of entries sorted or filtered in an Excel sheet

Advanced search






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search