En cours

excel duplicate/vlookup function

Hi all excel pro's,

For in the next couple of hours.

I want to merge data from cells in the 4th column ("fits on").

There are multiple rows.

Merging should occur only if there is a match for product name AND product id AND image no.

If TRUE, values in "fits on" column should be merged into 1 cell, SEPARATED by a comma.

Ideally, the copied rows should then be removed.

product name product ID image no. fits on

headlight A 16 1256 car D

headlight A 16 1256 car C

headlight P 11 1142 car M

headlight P 11 1142 car S

Should become:

product name product ID image no. fits on

headlight A 16 1256 car D, car C

headlight P 11 1142 car M, car S

Maybe some kind of combination of & function, countif and Vlookup???

thansk in advance guys!

Compétences : Excel

Voir plus : excel duplicate vlookup, excel vlookup duplicate, Excel pro, car id, advance excel+, excel duplicate function, vlookup duplicate function excel, excel advance, Vlookup, function, excel vlookup, excel function, excel duplicate, advance excel, car excel data, multiple car, multiple excel, excel cell, match merge excel, data merging, merged, excel duplicate values, excel duplicate merge, excel combination, excel data match

Concernant l'employeur :
( 15 commentaires ) Rotterdam, Netherlands

N° du projet : #1007650

Décerné à :

jaimetravail

I have got out and tested solutions to your problem. No programming will be used. Please refer to PM for details.

30 $ USD en 0 jours
(0 Commentaires)
0.0

44 freelance ont fait une offre moyenne de 35 $ pour ce travail

FINGERRPRINT

Thanks. Please see our PM.

50 $ USD en 1 jour
(58 Commentaires)
6.4
svet63

Excel developer since 1997. Can do. Regards, Svet.

90 $ USD en 1 jour
(51 Commentaires)
6.3
koolsidz

Please See PMB

35 $ USD en 0 jours
(92 Commentaires)
5.6
nagybatonyi

I'd complete this job with a simple macro in an hour including removing unnecessary rows. Regards!

30 $ USD en 0 jours
(47 Commentaires)
5.6
mrbrave

Ready to start now...

30 $ USD en 0 jours
(80 Commentaires)
5.4
agihcam

Please refer to your PMB for more details.

30 $ USD en 1 jour
(38 Commentaires)
5.1
binaryromel

########## Excel PRO here. Please check PM. ##########

30 $ USD en 0 jours
(41 Commentaires)
5.1
ineedWorkJob

sir plz check pm !

30 $ USD en 1 jour
(17 Commentaires)
4.7
microk

* * * Please See PMB * * *

30 $ USD en 1 jour
(17 Commentaires)
4.2
Chaitali2010

!! Expert Here !!

30 $ USD en 1 jour
(9 Commentaires)
3.5
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

30 $ USD en 0 jours
(10 Commentaires)
3.2
sjestuista

Let's do this

30 $ USD en 1 jour
(3 Commentaires)
3.1
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

30 $ USD en 1 jour
(3 Commentaires)
2.6
supportkumar

Hi see PM for details

40 $ USD en 1 jour
(4 Commentaires)
2.6
SilviaT

I can do it.

60 $ USD en 0 jours
(5 Commentaires)
2.4
IoliteTech

Hi, I could write you a macro to combine terms. Check the finished sammple file. Just enable macros and press ctrl+m. Merging data into a single cell is just as easy. I can do this very quickly for you. Why waste your Plus

30 $ USD en 0 jours
(2 Commentaires)
2.2
vbeh

Ready to start.

30 $ USD en 0 jours
(3 Commentaires)
2.1
guevanjr

Please check PM.

30 $ USD en 0 jours
(2 Commentaires)
1.9
emce75

could do this quickly :)

30 $ USD en 0 jours
(1 Commentaire)
1.8
kanadyanako

Dear Sir, Kindly read my PM.

30 $ USD en 0 jours
(1 Commentaire)
1.7