+ Reply to Thread
Results 1 to 2 of 2

How can I filter a column to have only one instance of repeating values?

  1. #1
    Registered User
    Join Date
    01-13-2005
    Posts
    1

    Question How can I filter a column to have only one instance of repeating values?

    Thanks to any who can help...

    I have a set of weekly reports that I concatenate into one monthly report. Because individuals may appear in one weekly report or in all of the weekly reports, there may be from one to five rows with their data.

    I need to know how many individuals are listed in the weekly reports at the end of the month but I need to weed out the duplicate info from the concatenated report.

    Each individual has a unique id number.

    How can I filter the id column and cause it to keep only the first instance of each unique id?

  2. #2
    Registered User
    Join Date
    04-23-2004
    Posts
    38
    This only works with numbers (I think) Assuming your ID numbers are in column A

    =COUNT(IF(FREQUENCY(A:A,A:A),1))


    Hope this Helps,
    Michael

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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