Results 1 to 4 of 4

Counting the various name in the one column of excel and writing the related number

Threaded View

Mary22 Counting the various name in... 09-24-2015, 09:49 AM
JBeaucaire Re: Counting the various name... 09-24-2015, 10:15 AM
Mary22 Re: Counting the various name... 09-24-2015, 11:16 AM
JBeaucaire Re: Counting the various name... 09-24-2015, 01:05 PM
  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    76

    Counting the various name in the one column of excel and writing the related number

    Hi friends,

    I have a large excel file containing the various name in the one column, which some names may exist several times. Please take a look at the attached file as a small example. I was wondering if there is any way to count different name and generate a output like this:

    Citrus sinensis 8
    Vitis vinifera 3
    so on,

    Looking forward to hearing from you soon. Thanks so much for your help in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. counting related to time values in a column
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2014, 04:24 PM
  2. Replies: 3
    Last Post: 01-27-2014, 07:17 AM
  3. Writing random number in column
    By love_sick7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2013, 10:30 PM
  4. Counting number of repetitions of a number in a column?
    By festacc77 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2013, 11:13 AM
  5. Number Format when writing data from VB to excel on a Userform
    By Nathan44 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2013, 05:32 AM
  6. [SOLVED] Counting the number of consecitive number 1's in a column
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 09:35 PM
  7. Replies: 7
    Last Post: 03-12-2012, 11:32 PM
  8. writing page number in excel
    By hoopes in forum Excel General
    Replies: 1
    Last Post: 10-17-2007, 05:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1