| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you look up a name in a worksheet
Hi there, I am currently working with alot of data in a excel spreadsheet,
roughly about 22,000 names and I want to know how you would look up a particular name if for example you are at row 100 and you can't remember what the row that name was in. So basically I want to know how to look up specific names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you look up a name in a worksheet
You could select the column that contains the names, press Ctrl + F and use
find to locate a specific name. -- Kevin Backmann "Joe" wrote: Hi there, I am currently working with alot of data in a excel spreadsheet, roughly about 22,000 names and I want to know how you would look up a particular name if for example you are at row 100 and you can't remember what the row that name was in. So basically I want to know how to look up specific names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you look up a name in a worksheet
CTRL+F ?
"Joe" wrote in message ... Hi there, I am currently working with alot of data in a excel spreadsheet, roughly about 22,000 names and I want to know how you would look up a particular name if for example you are at row 100 and you can't remember what the row that name was in. So basically I want to know how to look up specific names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc Many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you look up a name in a worksheet
Quickest way to do this is just to turn on the AutoFilter. Then, just click
the drop-down in that column to select the name. If you're looking to have Excel return a row number value, that would be a little different. "Joe" wrote: Hi there, I am currently working with alot of data in a excel spreadsheet, roughly about 22,000 names and I want to know how you would look up a particular name if for example you are at row 100 and you can't remember what the row that name was in. So basically I want to know how to look up specific names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc Many thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you look up a name in a worksheet
Are you sure that auto-filter will work with 22000 names?
I thought that it would only cope with the first 1000? http://www.contextures.com/xlautofilter02.html#Limits -- David Biddulph "jb_tenor1" wrote in message ... Quickest way to do this is just to turn on the AutoFilter. Then, just click the drop-down in that column to select the name. If you're looking to have Excel return a row number value, that would be a little different. "Joe" wrote: Hi there, I am currently working with alot of data in a excel spreadsheet, roughly about 22,000 names and I want to know how you would look up a particular name if for example you are at row 100 and you can't remember what the row that name was in. So basically I want to know how to look up specific names within an excel spreadsheet e.g mr joe bloggs in row 24 etc etc Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
