User Profile
AbtinS
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: How do I find multiple search terms in Excel?
JKPieterse This function wasn't available on Excel for Android version I was using. But I was able to get it to sort of work on Excel 2010. It worked fine in the sample data as you provided. But then I pasted my own date in the Data tab, and some test keywords in the Keywords tab, but then it kept showing hits to blank cells in the Data tab. Only correct hit I got was when the data cell and keyword were an exact match. I need it to pick out words that are parts of sentences in a Data cell. Also, I don't know why it keeps showing blank cells in Data page for keywords that are not blank.245KViews0likes12CommentsRe: How do I find multiple search terms in Excel?
That video didn't apply to what I need. Basically I have a sheet with several columns, and many rows. Most of what I need to search for are names that are in 2 or 3 particular columns, but would preferably like to search the entire sheet. In addition, I have many search terms in a list, let's say a list in a word doc, in a format like this: John Doe Coke Apple etc. I'm looking for a way to copy and paste that list into Excel and find out if I got a hit on any of the words, and if so where the hit is.250KViews0likes0CommentsHow do I find multiple search terms in Excel?
I often need to search a large list of search terms in an Excel sheet, but the search function is too tedious to do because I have to search for them individually. How do I search for these faster? I don't need to search a specific column or columns, just the entire sheet is fine. The list of search terms I get are not in any particular format, usually just a list typed up in Microsoft word or in PDF format, but I am able to copy and paste them. I'm normally using Excel for Android, free version, but also have a laptop with Office 2010.Solved266KViews0likes22Comments
Recent Blog Articles
No content to show