+ Reply to Thread
Results 1 to 9 of 9

Required Unique values based on if condition (array)

  1. 09-29-2014, 05:39 AM #1
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Required Unique values based on if condition (array)

    Hi Friends,

    Need you help in finding the Unique values from master sheet to subdata
    On satisfaction of If condition (In data validation) . (Preferred With Array)

    Please check the sheet Sub data sheet for more clarification .

    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-29-2014, 07:02 AM #2
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Required Unique values based on if condition (array)

    Hi ...
    Here is a short solution for Unique Manufacturers .. I think rest you can do yourself..
    You just have to change the index range and required column no...
    Have a look...
    Check the attached file..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  3. 09-29-2014, 08:03 AM #3
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Required Unique values based on if condition (array)

    HI Vikas_Gautam ,

    Thanks for the array function , help me to fulfill my point 4 , extract telephone numbers . i tried it works for single number Like "Tel" etc , but in case of
    more than one i am stuck.

    Punnam
    Reply With QuoteRegister To Reply
  4. 09-29-2014, 08:07 AM #4
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Required Unique values based on if condition (array)

    Okay
    Let me have a look..
    Reply With QuoteRegister To Reply
  5. 09-29-2014, 08:23 AM #5
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Cool Re: Required Unique values based on if condition (array)

    Have a look at Column K..
    I have assumed the telephone no. are at the end of your data..
    check the attached file...
    Attached Files Attached Files
    Last edited by Vikas_Gautam; 09-30-2014 at 05:51 AM.
    Reply With QuoteRegister To Reply
  6. 09-29-2014, 08:32 AM #6
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Required Unique values based on if condition (array)

    Hi Vikas,

    Thank You
    I have not given you best example , some cases they will not be in series , but located in different location
    I will upload a sample for you in few minutes .
    Punnam
    Reply With QuoteRegister To Reply
  7. 09-29-2014, 08:46 AM #7
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Required Unique values based on if condition (array)

    Bring it on..
    Reply With QuoteRegister To Reply
  8. 09-30-2014, 01:06 AM #8
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Required Unique values based on if condition (array)

    Hi Vikas,

    Check the attached sheet colored in Red & Yellow
    It has two things to be fixed .

    Punnam
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 09-30-2014, 01:09 AM #9
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Required Unique values based on if condition (array)

    I will be doing it , so wait for my reply..
    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. Counting unique values based on condition in a different column
    By rafuk73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2014, 02:59 PM
  2. [SOLVED] formula required to list cell values based on condition
    By kiranpat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 04:54 AM
  3. [SOLVED] counting unique values based on a condition with autofiltering
    By sammybr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2014, 06:27 PM
  4. Count unique values based on condition
    By pradeev in forum Excel General
    Replies: 4
    Last Post: 06-12-2012, 10:43 AM
  5. Extract Unique Values from an Array based on Criteria
    By ronleex324 in forum Excel General
    Replies: 1
    Last Post: 10-04-2011, 06:37 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