ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   1 word search (https://www.excelbanter.com/new-users-excel/58675-1-word-search.html)

brandi

1 word search
 
I have 59,000 people with all of their info on my sheet.
can i do a one word search to find a certain name or address, etc and how?

George Gee

1 word search
 
brandi

On the top toolbar, click 'Edit' Find
Type your word in 'Find what'.
Click 'Find next'.

George Gee


brandi wrote:
I have 59,000 people with all of their info on my sheet.
can i do a one word search to find a certain name or address, etc and
how?




Peo Sjoblom

1 word search
 
59000 is quite a lot, ever thought of migrating the list to Access, then you
can query from excel
A large list like that in excel using formulas will probably slow down the
workbook quite a bit?

--
Regards,

Peo Sjoblom

(No private emails please)


"brandi" wrote in message
...
I have 59,000 people with all of their info on my sheet.
can i do a one word search to find a certain name or address, etc and how?



Laura \( '_' \)

1 word search
 
Ctrl - F

Then type the word you want to find!

--
@---}--
Laura..... :)
Liverpool, England

"Do you know where you're going to?"
"brandi" wrote in message
...
: I have 59,000 people with all of their info on my sheet.
: can i do a one word search to find a certain name or address, etc and how?




All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com