Hi - I have a spreadsheet that contains mutliple entries that is giving me an issue when I'm trying to use a vlookup. Can I combine these entries at all? In the spreadsheet I could have up to 5 entries that are exactly the same and I only want the one. Using Excel 2003
Hi
Which one do you need?
Can you upload a small sample workbook?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi - I need to combine the attached sheets entries - this is a small sample - cheers. All the info follows this vain
why would vlookup fail,if they are all the same it will only pick the first one anyway, also does each place have only one id?
either way you can count then filter and delete all those that have duplicates like this.
or you could use advanced filter to get an unique list
select columns a:b then data/filter/advanced filter
select copy to another location
the list range should already be filled in
leave criteria field blank
select unique values only
in the copy to field select say j1
click ok
Last edited by martindwilson; 07-05-2012 at 05:04 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There were a few glitches sorry! I'll drill through and sort that - cheers for the assistance I'll look into that because I'm sure it will help once I've sorted the doc to a better standard - much appricated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks