Results 1 to 9 of 9

need formula to get unique values through lookup from adjacent column extent range

Threaded View

  1. 08-05-2016, 03:14 AM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    need formula to get unique values through lookup from adjacent column extent range

    Dear expert

    I have list of Quarter and month. under Quarter there are multiple months nos like 1,2,3,5,12,24,36...etc so if pick Q1-13 I want list out only unique values of adjacent column of month

    for example if Q1-15 month 1,3,12,24,36 coming 12 times in i want list out one time only.

    find the attachment raw data is in mis sheet if possible work in vba help me out.
    Attached Files Attached Files
    Last edited by breadwinner; 08-05-2016 at 03:17 AM. Reason: attachment
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Look for duplicated & unique values in adjacent column. Perform math on result. . .
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 12:04 PM
  2. [SOLVED] Count Unique Values in a Column that are not in adjacent Column
    By sskgintl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2013, 03:18 PM
  3. Formula for counting number of unique values in multiple non-adjacent columns with blanks
    By mbandet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2013, 01:46 AM
  4. Average range of cells in column if values in adjacent column are equal
    By RyNye in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 10:12 AM
  5. Match values in a range with another range and copy the adjacent column
    By xelmac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2012, 01:42 PM
  6. Pull unique values based on adjacent column
    By freud1 in forum Excel General
    Replies: 9
    Last Post: 07-02-2012, 11:36 AM
  7. Number of values above x in column B, for each unique value in adjacent column A.
    By Test123Test in forum Excel General
    Replies: 3
    Last Post: 03-17-2012, 11:32 PM
  8. Lookup formula question:adjacent column
    By waternut in forum Excel General
    Replies: 4
    Last Post: 10-01-2009, 09:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1