0
votes
1answer
1k views

Check if a Row Range Contains another Row Range values in Excel

I have an Excel file that contains two different columns having Customer Numbers (let's say CustomerA and CustomerB columns). What I would like to do to check which of the CustomerA values match the ...
1
vote
1answer
194 views

Find and return sheet name

I am looking for help in finding a string within a workbook and returning the sheet name (Address) or where the same can be found, e.g. Let's look for Lisbon which is located in sheet Portugal (sheet ...
0
votes
0answers
53 views

Find match in Excel 2010 from 2 sheets & copy corresponding contents from sheet 2 to sheet 1

I have 2 worksheets: Worksheet 1 with Column H need to find a match on Worksheet 2 with Column F If a match is found, I need to copy the contents of worksheet 2 column g to worksheet 1 column E. ...
2
votes
1answer
1k views

How to find hyperlinks in Excel 2010 and de-activate them?

When opening my Excel sheet using Excel 2010, I get a yellow bar at the top from Excel informing me that it has de-activated the automatic update of hyperlinks. To my best knowledge, I do not know ...
1
vote
5answers
5k views

Find, match whole word only workaround

I just noticed, there is no option in Excel Find, to "match whole word only" (I am not talking about "match entire cell content") e.g. searching for "part" should not match "partner". MS Word has this ...
0
votes
2answers
21k views

If an Excel row contains particular words, return that row, highlight that row, or give Y/N for that row

I have a sheet containing thousands of cells in a column. These cell contains names of different securities. Some names of these securities contains a particular string such as "C/O". How can I use ...
11
votes
2answers
10k views

How to search for ? (question mark) in Excel

When I try to find the question mark character (?) in an Excel sheet, Excel cannot locate the cells containing them. How can I search for ? in Excel?
0
votes
3answers
465 views

Why does Find in Excel give unexpected results?

I would like to find all cells containing the number 18 in an Excel 2007 worksheet where the numbers are in a column with entries in General format (both numbers and strings). When I use the Find ...
2
votes
1answer
915 views

Need a rule that searches for * in Excel

I need a simple rule that checks if a cell contains the char *. If i put * in the rule, it matches the entire string so i figured * is a wildcard. Is it possible to make it search for the char ? I ...
3
votes
1answer
941 views

How do I set search option defaults in MS Excel 2007?

I'm using Excel 2007. Every time I do a search I have to set the options to search within 'Workbook' and look in 'Values'. Is there a way to permanently set the default search behaviour?
2
votes
2answers
797 views

Find more than one string with Excel?

How to Find more than one string with Microsoft Office Excel? For example, I am looking for the cells which is contained both strings Paul and John? How to avoid to perform several finds by ...
1
vote
2answers
305 views

find in windows (batch files)

Does the find command in windows (command line) work to search inside of excel files?