Solve : MS Excel problem - please help?

1.	Solve : MS Excel problem - please help?
Answer» Good evening all, our tutor gives each of us an EXCEL file which contains hundreds of rows of data, and we are required to FIND which row contains a specific data, say the address of David Howard from the file. The excel file contains a few columns which headings are like these: Number Surname Lastname Addr1 Addr2 Tel I have tried the Find function in Excel but it only allows one word to be entered into the Find What Field. It seems to me that it is helpless to the user who wants to locate a specifc data across more than one column. Do you know if there is any tool in MS Excel which can help me out? Please help if you could!If the spreadsheet is set out as you described above all you would need to do is to type in the SEARCH field "David" or"Howard" being as there is only a few columns your information would be quite easy to find.are you allowed to export into MS Access?? i can definatly help from there Quote from: kwfine on April 29, 2008, 12:53:08 PM I have tried the Find function in Excel but it only allows one word to be entered into the Find What Field. I don't know where you got that notion, but it's not true. You can use multiple words in the Find What Field. Thanks all for your help!I think we're talking about two different things here. I'm not talking about the Find "Function", I'm talking about the Find command, which is found under Edit, or by hitting Ctrl/F. Does that make SENSE?I have just tried it and I can only enter one word....if I type more than one word it displays " Microsoft excel cannot find the data you are looking for" But if I just type in the one word then it will find thatGuys, I don't know what your problem is, but it works. ah the difference there is...I had set up my sheet as kwfine had...by having the first name and last name in different columns...i see you have both names in one column..I think what kwfine wanted was to be able to look for information that spanned more than one column.Arrgh! You're right davidoc. One approach here would be to sort the range on Lastname, then by Surname. i dunno which toad state your from but where im from surname and last name meant the same thing Quote from: NOT ADMIN :P on May 01, 2008, 06:35:07 PM i dunno which toad state your from but where im from surname and last name meant the same thing Yep, same here. I was merely referring to the fields he named in his first post: Quote from: kwfine on April 29, 2008, 12:53:08 PM The excel file contains a few columns which headings are like these: Number Surname Lastname Addr1 Addr2 Tel

Answer»

Good evening all,

our tutor gives each of us an EXCEL file which contains hundreds of rows of data, and we are required to FIND which row contains a specific data, say the address of David Howard from the file.

The excel file contains a few columns which headings are like these:
Number Surname Lastname Addr1 Addr2 Tel

I have tried the Find function in Excel but it only allows one word to be entered into the Find What Field. It seems to me that it is helpless to the user who wants to locate a specifc data across more than one column. Do you know if there is any tool in MS Excel which can help me out?

Please help if you could!If the spreadsheet is set out as you described above all you would need to do is to type in the SEARCH field "David" or"Howard" being as there is only a few columns your information would be quite easy to find.are you allowed to export into MS Access??

i can definatly help from there Quote from: kwfine on April 29, 2008, 12:53:08 PM

I have tried the Find function in Excel but it only allows one word to be entered into the Find What Field.

I don't know where you got that notion, but it's not true. You can use multiple words in the Find What Field. Thanks all for your help!I think we're talking about two different things here. I'm not talking about the Find "Function", I'm talking about the Find command, which is found under Edit, or by hitting Ctrl/F. Does that make SENSE?I have just tried it and I can only enter one word....if I type more than one word it displays " Microsoft excel cannot find the data you are looking for"
But if I just type in the one word then it will find thatGuys, I don't know what your problem is, but it works.

ah the difference there is...I had set up my sheet as kwfine had...by having the first name and last name in different columns...i see you have both names in one column..I think what kwfine wanted was to be able to look for information that spanned more than one column.Arrgh! You're right davidoc.

One approach here would be to sort the range on Lastname, then by Surname. i dunno which toad state your from but where im from surname and last name meant the same thing Quote from: NOT ADMIN :P on May 01, 2008, 06:35:07 PM

i dunno which toad state your from but where im from surname and last name meant the same thing

Yep, same here. I was merely referring to the fields he named in his first post:

Quote from: kwfine on April 29, 2008, 12:53:08 PM

The excel file contains a few columns which headings are like these:
Number Surname Lastname Addr1 Addr2 Tel

Solve : MS Excel problem - please help?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment