J
jee22
Good morning Ladies and Gentlemen
I have a list as below of components. You will note that 5 are of the same
value and C4 C5 are the same value
A B
C1 0.1uf
C2 0.1uf
C3 0.1uf
C6 0.1uf
C9 0.1uf
C4 12pF
C5 12pF
What I would like to do is have them displayed thus
A B
C1,C2,C3,C6,C9 0.1uF
C4,C5 12pF
There are of course other values like R1 V1 TR1 and so on, and they all are
place on a new row even though their B value is the same.
I would be grateful for any help. I have tried using VLOOKUP but cannot get
it to work and I am sure that's the wrong approach anyway
--
_____________________________________________
_____________________________________________
Mr J E Ellis
University of Cambridge
Department of Materials Science & Metallurgy
Pembroke Street
Cambridge
CB2 3QZ
England
Tel + 44-(0) 1223 334346
Fax + 44-(0) 1223 334567
E-mail (e-mail address removed)
_____________________________________________
I have a list as below of components. You will note that 5 are of the same
value and C4 C5 are the same value
A B
C1 0.1uf
C2 0.1uf
C3 0.1uf
C6 0.1uf
C9 0.1uf
C4 12pF
C5 12pF
What I would like to do is have them displayed thus
A B
C1,C2,C3,C6,C9 0.1uF
C4,C5 12pF
There are of course other values like R1 V1 TR1 and so on, and they all are
place on a new row even though their B value is the same.
I would be grateful for any help. I have tried using VLOOKUP but cannot get
it to work and I am sure that's the wrong approach anyway
--
_____________________________________________
_____________________________________________
Mr J E Ellis
University of Cambridge
Department of Materials Science & Metallurgy
Pembroke Street
Cambridge
CB2 3QZ
England
Tel + 44-(0) 1223 334346
Fax + 44-(0) 1223 334567
E-mail (e-mail address removed)
_____________________________________________