+ Reply to Thread
Results 1 to 3 of 3

using cells with combination of values

Hybrid View

  1. 04-09-2016, 08:17 AM #1
    amritram
    amritram is offline
    Registered User
    Join Date
    04-09-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    using cells with combination of values

    One column of my data sheet has data for various health issues ( person x1 has diabetes, hypertension; person X2 has diabetes, hypothyroidism; person X3 has hypertension and arthritis; etc.) for about 3000 people. Another column has data for their side effect of their treatment (like headache, nausea, giddiness, insomnia, etc.) again in one column.
    I would like to know if there is a way, in excel, to analyse how many diabetics had nausea, or how many hypertensives had insomnia an other relationships.
    I have basically tried to create separate columns for each and give a yes no response but I somehow am not able to combine all these comparisons. Does pivot tables help? and could I do this without VBA as I am an absolute VBA illeterate?
    Thanks in advance for any help.
    Regards
    Amrt
    Reply With QuoteRegister To Reply
  2. 04-09-2016, 09:17 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: using cells with combination of values

    you can setup some formuals

    =COUNTIFS(A:A, "*diabetes*",B:B, "*Nausea*")


    With E3 =diabetes
    and F3 = Nausea
    =COUNTIFS(A:A, "*"&E3&"*",B:B, "*"&F3&"*")

    No sure if it can be done in a pivot table as you need the wildcards to each the cells
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-09-2016, 09:18 AM #3
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,706

    Re: using cells with combination of values

    Perhaps use the =countifs function.

    Here is a tutorial: http://www.techonthenet.com/excel/formulas/countifs.php
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Determine if range of cells is already merged cells, all unmerged or combination
    By Mitchw82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2015, 05:03 PM
  2. P&C method: comFor adding the cells using combination of cells to give a specified value
    By myself4u58 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 05:56 AM
  3. Percentile values with different combination
    By Santhoshhrishi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2014, 01:06 AM
  4. Finding a unique combination of values
    By bassiere in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-27-2013, 10:20 AM
  5. get all possible combination of values
    By malikaouenza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2013, 07:21 AM
  6. count of combination of some values
    By yasar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 04:36 AM
  7. Excel 2007 : Checking values in columns C and D,are right combination?
    By ALEZI in forum Excel General
    Replies: 2
    Last Post: 10-28-2010, 04:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1