Results 1 to 7 of 7

Detect unique values in cell and find them in column to count them

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2014
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    3

    Detect unique values in cell and find them in column to count them

    Hi everyone!

    It's the first time I come in here to ask a question so first of all my apologies if I am missing something when I describe my question.

    I am trying to figure out a way to do the following:

    Newpic.JPG

    I want to create a function or something that allows me to detect the Project Numbers and see if they have previously been entered. If several projects are entered in one cell, they will be separated by a /. If project numbers have not been previously entered all should be counted in column "Number" as shown in the picture.

    Does someone have an idea on how to do such thing?

    Any help will be much appreciated.
    Thanks.
    Last edited by Ivancitomusic; 01-02-2015 at 05:12 AM. Reason: Image not fully descriptive

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. Replies: 11
    Last Post: 01-18-2013, 04:05 PM
  3. Count Unique Values In One Column Basis Unique Values in Another Column
    By shez_raz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2012, 01:55 AM
  4. Find and count unique values
    By famico78 in forum Excel General
    Replies: 8
    Last Post: 12-04-2009, 08:23 AM

Tags for this Thread

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