+ Reply to Thread
Results 1 to 3 of 3

Referencing one cell to individual cells in a large set

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    kc, mo
    Posts
    25

    Referencing one cell to individual cells in a large set

    Is it possible to make an if statement look into an entire column and count every time that same cell matches. For example:

    I have a large list of names in column A and an even longer list of names in column C. Every time the name in A1 shows up in column C I want that count to show up in B1 (ie: if A1 shows up 20 times in Column C I want the number 20 to show up in B1).

    What formula whould I have to put in B1 to get this count?


    Thanks in advance!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Look at the COUNTIF function.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    07-24-2008
    Location
    Athome
    MS-Off Ver
    Excel 2013
    Posts
    127
    =countif(c:c,$a1)

    you can then copy that formula downwards in column b and it will read from each item in column a.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copy a range of cell values to another range of cells if one cell = 1
    By jamiepullen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2008, 10:26 AM
  2. Delete empty cells within row until you hit nonempty cell
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2008, 12:55 PM
  3. Referencing cell
    By DaveHan in forum Excel General
    Replies: 4
    Last Post: 06-10-2008, 12:28 PM
  4. Counting individual coloured cells that are merged.
    By JohnSan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2008, 01:11 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1