Results 1 to 145 of 145

Show working-instructions depending on GHS-hazard-pictograms

Threaded View

  1. #11
    Forum Contributor
    Join Date
    08-31-2022
    Location
    Swiss
    MS-Off Ver
    365
    Posts
    138

    Re: Show working-instructions depending on GHS-hazard-pictograms

    Good morning Hans,

    thank you again for your help!
    I've just implemented your formulas to my worksheet - it looks great so far! I really like the IFERROR for the special requirements. I have changed the "-" to "no B-Terms necessary" and it seems to be quite professional already

    The only thing missing which would make it perfect is, if we are able to add multiple safety precautions for one room and one safety precaution.
    For now if we look for example at room two and try to handle "Organische Peroxide CD" we can do this, but we have two additional safety precautions:

    - 5: not allowed to be warmed
    - 7: need to be in room 9

    As long as my database contain these to numbers as "5,7" excel thinks that this is one number and not two.
    So we get room 2 with no additional safety precautions because 5,7 is not existing (although 5 and 7 is in the database)

    Is there a way to fix this? Maybe if we us a combination of numbers and letters to differentiate between for example 5 and 7?

    Thank you again for your tremendous support,

    David
    Last edited by mrdaave; 10-09-2023 at 01:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Spot the hazard picture - reveal with click
    By fastcar in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 02-04-2021, 12:47 PM
  2. [SOLVED] Building a hazard table
    By jordana309 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-18-2019, 10:13 AM
  3. [SOLVED] show 0,0.5,1 depending on various condition
    By anilpatni1234 in forum Excel General
    Replies: 19
    Last Post: 10-20-2018, 08:15 AM
  4. [SOLVED] Show data depending on a yes or no.
    By TrickDave in forum Excel General
    Replies: 4
    Last Post: 10-23-2017, 07:40 AM
  5. [SOLVED] Instructions show in Cell until Data is entered
    By swvogt in forum Excel General
    Replies: 5
    Last Post: 09-22-2017, 04:31 PM
  6. Replies: 0
    Last Post: 06-15-2011, 10:36 AM
  7. [SOLVED] How can I graph using pictograms in excel?
    By madrabbit7 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2005, 09:25 PM

Tags for this Thread

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