| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
using another file for vlookup
New user Excel 2003, Windows Professional 2000. I have a file 2900 rows but
just for 100 people - it repeats a name / code every entry. I want to use this file for a vlookup on another file that just has a name and extract the code. How do I reduce the 2900 rows to just 100. Hope I explained this correctly. tia |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
using another file for vlookup
data/filter/advanced filter
check Unique values checkbox Copy to another location, and speficy a new location on that sheet. Use the results as your table for looking up values. HTH "dp" wrote: New user Excel 2003, Windows Professional 2000. I have a file 2900 rows but just for 100 people - it repeats a name / code every entry. I want to use this file for a vlookup on another file that just has a name and extract the code. How do I reduce the 2900 rows to just 100. Hope I explained this correctly. tia |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
using another file for vlookup
Perfect! Thanks for your time.
"Bob Umlas, Excel MVP" wrote: data/filter/advanced filter check Unique values checkbox Copy to another location, and speficy a new location on that sheet. Use the results as your table for looking up values. HTH "dp" wrote: New user Excel 2003, Windows Professional 2000. I have a file 2900 rows but just for 100 people - it repeats a name / code every entry. I want to use this file for a vlookup on another file that just has a name and extract the code. How do I reduce the 2900 rows to just 100. Hope I explained this correctly. tia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP with a reference to a different file... | Excel Worksheet Functions | |||
| vlookup on close file | Excel Worksheet Functions | |||
| Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
| vlookup file specification | Excel Worksheet Functions | |||
| VLOOKUP from a file on another server | Excel Worksheet Functions | |||
Linear Mode
