| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find only the required data in a list ?
Dear Sir,
I encounter some problem in using Find and Replace function. I highlight A1: A7 and type in BTH100 to search the listing. When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4 and A5 and finally returns to A1. In my opinion, BHT100 only occur twice in the listing, the cursor should only goes to cell A1 follow by A5 and finally return to A1 again. It should not go to other cells whereby its first six characters are BHT100 because all those references are diiferent from what I key to search at the menu. A 1 BTH100 2 BTH1006 3 BTH10086 4 BTH100065 5 BTH100 6 BTH206 7 BTH408 May I know how to make this function to do the right thing? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to find only the required data in a list ?
In the options select WHOLE
-- Don Guillett Microsoft MVP Excel SalesAid Software "Mr. Low" wrote in message ... Dear Sir, I encounter some problem in using Find and Replace function. I highlight A1: A7 and type in BTH100 to search the listing. When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4 and A5 and finally returns to A1. In my opinion, BHT100 only occur twice in the listing, the cursor should only goes to cell A1 follow by A5 and finally return to A1 again. It should not go to other cells whereby its first six characters are BHT100 because all those references are diiferent from what I key to search at the menu. A 1 BTH100 2 BTH1006 3 BTH10086 4 BTH100065 5 BTH100 6 BTH206 7 BTH408 May I know how to make this function to do the right thing? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to find only the required data in a list ?
You really want to match the *exact contents* of the cell, instead of
matching any cell that *contains* BTH100. In the Find and Replace window..... CHECK: Match entire cell contents That should fix your problem.... Does it? *********** Regards, Ron XL2002, WinXP "Mr. Low" wrote: Dear Sir, I encounter some problem in using Find and Replace function. I highlight A1: A7 and type in BTH100 to search the listing. When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4 and A5 and finally returns to A1. In my opinion, BHT100 only occur twice in the listing, the cursor should only goes to cell A1 follow by A5 and finally return to A1 again. It should not go to other cells whereby its first six characters are BHT100 because all those references are diiferent from what I key to search at the menu. A 1 BTH100 2 BTH1006 3 BTH10086 4 BTH100065 5 BTH100 6 BTH206 7 BTH408 May I know how to make this function to do the right thing? Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to find only the required data in a list ?
Hello Ron,
Yes, it works. Many thanks. Low -- A36B58K641 "Ron Coderre" wrote: You really want to match the *exact contents* of the cell, instead of matching any cell that *contains* BTH100. In the Find and Replace window..... CHECK: Match entire cell contents That should fix your problem.... Does it? *********** Regards, Ron XL2002, WinXP "Mr. Low" wrote: Dear Sir, I encounter some problem in using Find and Replace function. I highlight A1: A7 and type in BTH100 to search the listing. When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4 and A5 and finally returns to A1. In my opinion, BHT100 only occur twice in the listing, the cursor should only goes to cell A1 follow by A5 and finally return to A1 again. It should not go to other cells whereby its first six characters are BHT100 because all those references are diiferent from what I key to search at the menu. A 1 BTH100 2 BTH1006 3 BTH10086 4 BTH100065 5 BTH100 6 BTH206 7 BTH408 May I know how to make this function to do the right thing? Thanks Low -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to find only the required data in a list ?
I'm glad I could help......thanks for the feedback.
*********** Regards, Ron XL2002, WinXP "Mr. Low" wrote: Hello Ron, Yes, it works. Many thanks. Low -- A36B58K641 "Ron Coderre" wrote: You really want to match the *exact contents* of the cell, instead of matching any cell that *contains* BTH100. In the Find and Replace window..... CHECK: Match entire cell contents That should fix your problem.... Does it? *********** Regards, Ron XL2002, WinXP "Mr. Low" wrote: Dear Sir, I encounter some problem in using Find and Replace function. I highlight A1: A7 and type in BTH100 to search the listing. When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4 and A5 and finally returns to A1. In my opinion, BHT100 only occur twice in the listing, the cursor should only goes to cell A1 follow by A5 and finally return to A1 again. It should not go to other cells whereby its first six characters are BHT100 because all those references are diiferent from what I key to search at the menu. A 1 BTH100 2 BTH1006 3 BTH10086 4 BTH100065 5 BTH100 6 BTH206 7 BTH408 May I know how to make this function to do the right thing? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| formula required for excel 2002 | Excel Discussion (Misc queries) | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
| Help required - Data - Validation - List - Formula | New Users to Excel | |||
Hybrid Mode
