Results 1 to 3 of 3

Custom Data Validation Lists

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    Sunnyvale, CA, US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Custom Data Validation Lists

    Hi All,

    I do lot of data analysis related to Incidents worked by our team and generate reasons on why we missed or customer was not happy with helpdesk service. Basically may analysis will have two columns namely "Primary Reasons" and "Observations"
    Primary Reasons generally fall into one of the following like:
    1) Agent Mistake
    2) Communication Issue
    3) Outside GSD control
    4) Resolution Time
    5) No commnets provided

    I need assistance in building data list so when Agent Mistake is selected under primary reason, observation column should only reflect list related to Agent Mistakes like Misinterpret the issue
    Missed Call back
    Improper follow Up
    Incorrect KB followed
    Delay in Responding to user
    Probing Issue
    Missed basic troubleshooting
    Attachment Missing
    Incorrect Routing

    Similarily if Communication Issue is selected under Primary reasons, Observation should list one of the options to select like
    Accent Issue
    Active Listening
    Soft Spoken
    Difficult to understand
    Zargons / Technical terms used

    I am attaching file so that I could assistance. Data Validation sheet has above values selected and drop down list to be generated in Sample Work Sheet.
    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] Data Validation with 4 different lists
    By serged20 in forum Excel General
    Replies: 3
    Last Post: 05-02-2012, 01:46 PM
  2. Replies: 3
    Last Post: 09-02-2010, 03:04 AM
  3. Sub lists within data validation
    By di22y in forum Excel General
    Replies: 2
    Last Post: 08-19-2009, 02:54 PM
  4. data validation with two lists
    By krt777 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-28-2008, 07:26 PM
  5. Custom Lists in Excel where data contains a Comma....
    By konquistador in forum Excel General
    Replies: 5
    Last Post: 03-15-2007, 09:36 AM

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