+ Reply to Thread
Results 1 to 4 of 4

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

  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

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

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

    Hi Rav,


    I am not able to understand...when you select the drop down options in G8 and H8, what should change in which location? please highlight.. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

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

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

    Hi Dilip,

    Sorry for the late reply,

    SeeImage.png
    Please see the attached image.
    If i select Q_1 or Q_2 or Q_3 or Q_4 that means any one value the corresponding columns shows the values(Weight,Score).

    But if my selection contains multiple values how can i show the values.

    Thanks for the reply

    Regards
    Rav

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

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

    any one value the corresponding columns shows the values(Weight,Score).
    Where?.. which corresponding column?
    Sorry..I am still not able to get this..

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

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