Aug 27 2021 02:43 PM
I'm very new to excel and I need a little help. I've created this table that tracks infections in the facility that I work in. I'm trying to get excel to map the data for me. I cant quite figure out a formula or what conditional highlighting to use. I have attached a screenshot of my infection control log along with the sheet of the map that I am trying to create.
Aug 27 2021 03:08 PM
Aug 27 2021 03:11 PM
Aug 27 2021 03:34 PM - edited Aug 27 2021 03:37 PM
I guess I understood and I have some ideas on how to assist you.
To be more practical, is possible you just provide some sample like the data of your screenshots?
Aug 27 2021 04:04 PM
I'm attaching some screenshots where I have gone in and highlighted it myself. I can continue to do it manually but I was really looking for a formula to do it faster.
I'm pulling the data from the room # column and the site column
Aug 27 2021 04:11 PM
Aug 27 2021 09:49 PM
@LaurenMcDonald Could you upload relevant parts of the workbook, including the formulae that you already created? Screenshots aren't very helpful in this case. Make sure to remove/replace any private or confidential information.
Aug 29 2021 11:53 AM