Results 1 to 4 of 4

How to show the calculations if the matching values exists in the selection series of list

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    75

    Post How to show the calculations if the matching values exists in the selection series of list

    Hi All,

    I am able to show the calculated values based on the selected cell contains only one value.

    But how can i do this if the cell contains multiple values separated with commas.

    Ex:

    Q1=Q1 ->Showing the values for Q1 column only.
    Q2=Q2 ->Showing the values for Q1 column only.
    etc............................................................

    But i need like this

    If the selection contains multiple values in a single cell like

    Q1,Q2,Q3 ->In this series 3 individual columns are there at that time i want to show the values for all those columns.
    Like this my selection contains single value or multiple values they will exist in single cell.

    Hope you understand the problem.

    Here i am attaching the sample file.Please look at this.

    Thanks in advance.

    Regards
    Rav
    Attached Files Attached Files

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