+ Reply to Thread
Results 1 to 5 of 5

Count enrty in column A show results

  1. 08-11-2016, 04:50 PM #1
    engie-123
    engie-123 is offline
    Registered User
    Join Date
    08-11-2016
    Location
    mold
    MS-Off Ver
    office Pro 2013
    Posts
    10

    Count enrty in column A show results

    Hi,

    I would like Column A to be counted for all it entries - then result as below -

    Column A Column B Column C
    g123 g123 3
    r467 r467 2
    e896 e896 1
    g123
    g123
    r456

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-11-2016, 05:33 PM #2
    shirleyxls
    shirleyxls is offline
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Count enrty in column A show results

    In D2 put:

    =COUNTIF($A$2:$A$18,$C2)

    Then copy down to the other cells in column D
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
    Reply With QuoteRegister To Reply
  3. 08-14-2016, 12:56 PM #3
    engie-123
    engie-123 is offline
    Registered User
    Join Date
    08-11-2016
    Location
    mold
    MS-Off Ver
    office Pro 2013
    Posts
    10

    Re: Count enrty in column A show results

    Hi,

    Thank you for your reply, it does the job but I would like the column C to be generated as well - this would correspond with the numbers in column D,

    Cheers
    Reply With QuoteRegister To Reply
  4. 08-14-2016, 01:08 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Count enrty in column A show results

    Try this:

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    1
    		 Item No
    Results
    2
    		 k123
    k123
    6
    3
    		 n234
    l345
    2
    Total
    17
    4
    		 l345
    n234
    1
    5
    		 t456
    t456
    4
    6
    		 y456
    y456
    4
    7
    		 k123
    8
    		 y456
    9
    		 t456
    10
    		 k123
    11
    		 k123
    12
    		 y456
    13
    		 k123
    14
    		 l345
    15
    		 k123
    16
    		 t456
    17
    		 y456
    18
    		 t456
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    1
    		 Item No
    Results
    2
    		 k123
    =IFERROR(INDEX($A$2:$A$30,MATCH(0,COUNTIF($A$2:$A$30,"<"&$A$2:$A$30)-SUM(COUNTIF($A$2:$A$30,$C$1:C1)),0)),"")
    =IF($C2="","",(COUNTIF($A$2:$A$18,$C2)))
    3
    		 n234
    =SUM(D:D)
    Sheet: Sheet1

    The formula in column C is an array formula: confirm it with CTRL+SHIFT+ENTER, not just ENTER. Do not type the curly brackets (braces) {} yourself - they will be added for you when you confirm the formula.
    Last edited by AliGW; 08-14-2016 at 01:19 PM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 08-14-2016, 03:14 PM #5
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,296

    Re: Count enrty in column A show results

    Or a simple pivot table will work also.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] CountIfs when you need to count two results in the same column
    By govcam in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-09-2016, 03:01 PM
  2. Count results to data column
    By BradHart in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2015, 12:42 PM
  3. Show column header values vertically vs. horizontally in pivot results
    By Scott1807 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-29-2015, 04:39 AM
  4. Show results in column if greater than 3 charcters
    By dominick1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2013, 01:38 PM
  5. Pivot Table: show column 1 count data as % of last column count data
    By kuraitori in forum Excel General
    Replies: 1
    Last Post: 02-09-2010, 06:16 PM
  6. Screen Prompt Data Enrty Requirement
    By Ant_Sky in forum Excel General
    Replies: 0
    Last Post: 07-25-2005, 11:23 AM
  7. How do I subtract column 1 from 2 and show results in 3?HELP!
    By ks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2005, 11:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1