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

Klaus Urban  Identity Verified
Local time: 09:11
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


Direct link Reply with quote
 

Gianni Pastore  Identity Verified
Italy
Local time: 09:11
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!)

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


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 09:11
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!


Direct link Reply with quote
 

Klaus Urban  Identity Verified
Local time: 09:11
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


Direct link Reply with quote
 


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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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