0
votes
2answers
150 views

How can I check cells for number series?

I have a bit of a problem evaluating an excel cell. Example: M M M M M M M M M 1 2 3 4 5 6 7 8 9 2;5;7 1;9 3;5;7;9 I have a number of excel ...
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
1answer
74 views

Compare lists in excel [duplicate]

Possible Duplicate: Extract values from a range that are missing from another I have two vertical lists. I need to compare the two with each other and get the names that are NOT included in ...
0
votes
3answers
477 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 ...
0
votes
1answer
179 views

Find excel worksheet with vb script

Is there a way in windows vista to search for an excel 2007 workbook that contains a certain vbscript (or filter those files that contain any Vb script ?).
3
votes
1answer
944 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?