I have a sheet on excel 2007, where initial 420 rows have 8 columns of data, then subsequent 1600 rows have 9 columns. The 1600 rows include the initial 420 rows (ie duplicated, but are missing the 9th column). Please help me identity these duplicates & have the data from the 9th column added to them.
I have attached a sample resembling my requirements
Thanks
I would be tempted to concatenate the data in the first 8 columns into a long string and then use VLOOKUP to pull in the values.
Please see the attachment.
Martin
How can we concatenate the data from 8 columns into 1 string?
Suggest using the CONCATENATE function (see Help for details) or something like =A1&B1&C1&D1.......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks