Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Searching in Excel

Jul 29, 2005 12:31AM PDT

I had a different username...forgot it and changed email since.

Anyway...

I am wanting to have a page in a workbook to seach.

I wand to be able to add a few letters of a name, have the search return all names that has the first few letters and all info in the columns relating to the name.

colA Name ColB Phone ColC Address etc...

Mike

Discussion is locked

- Collapse -
In Excel, I think, ...
Jul 29, 2005 4:09AM PDT

the best you can do is sort on the name, then page down until you're there.

A trick would be to have a column with a formula with, say, the first 3 characters of the name (using the left-function). Then you can put an autofilter on the table, and select the appropiate value.
You might like to make separate columns with 2, 3, 4 and 5 letters.

I won't annoy you by telling how I should do it in Access.

Kees

- Collapse -
Thanks
Jul 29, 2005 4:38AM PDT

Thanks Kees,

I am just scratching the surface of excel. I know Access would be better for what we do....but....we don't know Access.

Trying to learn a little of Excel and Access. Everytime I run into a snag I find that a VB script would do what I need. Don't know anything about VB.

Damn the bad luck.

Mike