Results 1 to 3 of 3

How to use value in cell after filtering data, using data validation list method

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    23

    How to use value in cell after filtering data, using data validation list method

    how can i get a value in cell after selecting criteria from coloum type1, type2, type3, using data validation list method. also list value behave like filtering, only m,n value should be list in type 2 if I select a in type1

    type1 type2 type3 Value
    a m o 21
    a n p 22
    b m q 23
    b n o 24
    c m p
    c n q

    type1 type2 type3 Value
    List a m o 21 "=21x some function.

    Thanks for your valuable time.
    Attached Files Attached Files
    Last edited by SAGAR KHOLLAM; 06-18-2012 at 04:30 AM. Reason: File uploaded

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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