Results 1 to 20 of 20

How to extract list of unique individuals from the master data set - Reg.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    How to extract list of unique individuals from the master data set - Reg.

    Hello good morning everyone,

    Kindly help me in generate only unique list from the data set. The model data set have been attached for your reference. The data set is a dynamic data entry sheet, which has list of persons to visit counseling center and aims to cover daily visitors.

    Requirement as below:

    1. Need to find out only unique individuals from the data set. I have created a helper column, which shows result of number of visit by each individual. Based on that, i have done the count value also. . I have used this formula "=COUNTIFS($G$2:$G$28,1)" in "K2 column".

    2. Now, i want to generate only those unique individual list between two dates in the table "I5:M5". I have tried the following formula in "I5" column.

    =IFERROR(SMALL(IF(C2:C32=Helper,IF(B2:B32>=I2,IF(B2:B32<=J2,ROW(B2:B32)-1))),ROW(B1)),"")

    Kindly help me.

    Thanks 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. [SOLVED] How to extract list of individuals from master document between two dates
    By bala04msw in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-21-2016, 03:24 AM
  2. Replies: 4
    Last Post: 01-31-2014, 06:22 AM
  3. Replies: 15
    Last Post: 11-11-2013, 08:21 PM
  4. extract data from a master list
    By indesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2013, 12:27 AM
  5. [SOLVED] Auto extract data from master list into other sheets based off of month
    By dsklein85 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2013, 06:23 PM
  6. Email merge unique messages to groups and individuals
    By RagingWahoo in forum Excel General
    Replies: 3
    Last Post: 10-12-2012, 01:15 PM
  7. Extract Data From a list with unique value
    By sunflowers in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-22-2011, 08:47 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