Forum Discussion
LaurenMcDonald
Aug 27, 2021Copper Contributor
Highlighting Certain Words
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 ...
LaurenMcDonald
Aug 27, 2021Copper Contributor
I've pulled this data already in chart form. Using the countifs formula. The exact formula I used was =COUNTIFS(Hall, "100", site1, "UTI", Hall, "<>*"). It would just be very helpful to have it in a map.
Riny_van_Eekelen
Aug 27, 2021Platinum Contributor
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.