+ Reply to Thread
Results 1 to 9 of 9

Creating a Chart/table with with available set of data

  1. #1
    Registered User
    Join Date
    01-06-2018
    Location
    alex
    MS-Off Ver
    2007
    Posts
    26

    Question Creating a Chart/table with with available set of data

    Hello everyone,
    I'm trying to get this final result.
    iv-drug-incompatibilities-19-638.jpg

    I have the data for each individual drug, but it would be painful to do it one by one,
    Can excel speed up the process somehow?

    Hope you can give me some pointers.

    Thanks alot.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,287

    Re: Creating a Chart/table with with available set of data

    Have a look here: https://www.excelforum.com/excel-for...e-of-data.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    01-06-2018
    Location
    alex
    MS-Off Ver
    2007
    Posts
    26

    Re: Creating a Chart/table with with available set of data

    Quote Originally Posted by AliGW View Post
    Thanks for the link, but i think my case is different!
    I'm having multiple tables of drug compatibility and i'm not trying to count the occurances, but i'm trying to find the value corresponding to each drug.
    Ive tried vlookup but couldn't figure i out to work
    can you please take a look at the updated sample? and tell me of a why to return the data of each cell?! and ignoring errors as well?

    Thanks alot in advance.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-09-2018
    Location
    Calgary, Canada
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Creating a Chart/table with with available set of data

    Hello,

    Please see attached. I hope this works for you.

  5. #5
    Registered User
    Join Date
    01-06-2018
    Location
    alex
    MS-Off Ver
    2007
    Posts
    26

    Talking Re: Creating a Chart/table with with available set of data

    Thanks for that.
    It did exactly what i wanted.
    thread resolved

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,287

    Re: Creating a Chart/table with with available set of data

    Angie90 - for the benefit of all here, please give some explanation of the solution you have offered in your post. Have a look at the link I posted above to see the sort of thing I mean (where I offered a solution). Thank you.

  7. #7
    Registered User
    Join Date
    03-09-2018
    Location
    Calgary, Canada
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Creating a Chart/table with with available set of data

    Hi Ali,

    I tried to reply to your private message, but I don't think it went through.

    I simply used the INDEX/MATCH function here to return the values and used IFERROR to cover up the #N/A error messages. I'm new to the forum and not an advanced user of Excel. I don't think I can explain the INDEX/MATCH function clearly. I would appreciate your help on this.

    Deskbright.com has a very useful and detailed tutorial on INDEX/MATCH. Sorry I can't post the link here.
    Last edited by AliGW; 03-15-2018 at 02:08 PM. Reason: Unnecessary quotation removed.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,287

    Re: Creating a Chart/table with with available set of data

    We don't need a link. What is the actual formula that you used? Post that here, please.

    I replied to your message about five minutes ago.

  9. #9
    Registered User
    Join Date
    03-09-2018
    Location
    Calgary, Canada
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Creating a Chart/table with with available set of data

    =IFERROR(INDEX(Table3[#All],MATCH(Sheet6!B1,Table3[[#All],[COMP WITH MED10]],0),1),"")

+ 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