Results 1 to 1 of 1

Duplicate data after DropDown

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    Kathmadnu
    MS-Off Ver
    2010
    Posts
    15

    Duplicate data after DropDown

    First i select one option from drop down. On the base of that option excel shows relative data.

    For example i have different company in one client type, but one of them have multiple staff with multiple contact add.
    The problem is how to show only one contact that come first (alphabetically) ..

    Please download the attahced excel sheet. I am stocked on sheet 2 (data duplication when i select Commercial Builders.

    Thanks
    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. Data validation dropdown with in cell-dropdown?
    By OldManExcellor in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 08:14 AM
  2. Validation rule dropdown list without duplicate values
    By sakinen in forum Excel General
    Replies: 9
    Last Post: 05-08-2013, 08:56 AM
  3. [SOLVED] Duplicate Data in Filter Dropdown
    By tommyfernandez in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-29-2012, 05:05 PM
  4. Dropdown List without Duplicate Values
    By s_lemin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2007, 01:13 PM
  5. Duplicate values in Pivot table Page Field dropdown..
    By trippknightly@hotmail.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 10:50 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