| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a lookup on data containing duplicate entries?
I'm using Excel 2007. I'm trying to sort data retrieved from a large data
dump that combines both numbers and text. Can I use the V-Lookup function if the data contains duplicate entries? Or would another formula be more adequate? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I use a lookup on data containing duplicate entries?
Yes you can.
Please hit Yes if my comment has helped. Thanks. "City6" wrote: I'm using Excel 2007. I'm trying to sort data retrieved from a large data dump that combines both numbers and text. Can I use the V-Lookup function if the data contains duplicate entries? Or would another formula be more adequate? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I use a lookup on data containing duplicate entries?
Vlookup or any of the lookup type functions will return a match if a match is
found. If you have duplicate entries then it will return one of the entries but you will have no way of knowing which one you got. What exatcly are you wanting to do? Did you want a single total of all of the matching entries or did you want a listing of the matching entries... -- HTH... Jim Thomlinson "City6" wrote: I'm using Excel 2007. I'm trying to sort data retrieved from a large data dump that combines both numbers and text. Can I use the V-Lookup function if the data contains duplicate entries? Or would another formula be more adequate? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate data entries | Excel Worksheet Functions | |||
| Data Validation /w Duplicate Entries | Excel Discussion (Misc queries) | |||
| how do I compare two data files for duplicate entries in Excel | Excel Worksheet Functions | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
Linear Mode
