joms
02-23-2009, 12:59 AM
help on how to group data with same value to another cell.
col a - data to be group
col b - reference value
col c - grouped data with same value
like:
Col A Col B
C1 10uF
C2 100uF
C3 10nF
C4 100pF
C5 10uF
c6 100uF
C7 10nF
C8 100pF
C9 100uF
C10 10nF
C11 10uF
C12 100uF
so i want to group in col c the data with same value
so it would look like this:
C1, C5, C11 --> All is 1OuF
C3, C7, C10 --> All is 10nF
any idea how to achieve this in macro.. thanks..
col a - data to be group
col b - reference value
col c - grouped data with same value
like:
Col A Col B
C1 10uF
C2 100uF
C3 10nF
C4 100pF
C5 10uF
c6 100uF
C7 10nF
C8 100pF
C9 100uF
C10 10nF
C11 10uF
C12 100uF
so i want to group in col c the data with same value
so it would look like this:
C1, C5, C11 --> All is 1OuF
C3, C7, C10 --> All is 10nF
any idea how to achieve this in macro.. thanks..