•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I search cells for a word, when that word is also part of other words?
I have a worksheet of results for a drug testing laboratory and they want to know how many cases contain amphetamine. Exporting the data returns cells with drug names separated by commas.
i.e.
cell B6 contains [amphetamine, methamphetamine, cocaine, opiates]
cell B7 contains [methamphetamine, cocaine, THC]
How can I set up a count function that will return me all the cells with 'amphetamine', but not also count cells with 'methamphetamine', since it contains the word amphetamine as well.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#amphetamine
#methamphetamine
#cocaine
#opioids
#drug testing
#laboratory
#cells
#count function
#results
#data export