multiple record to single with frequent change in string at forward slash

[cruise.alter]

hi all,

I want to count the below records to two single records (based on cts and ibm). Each string should repeated only once

finance/economy/boy/cts=12

finance/economy/girl/cts=3

finance/economy/boy/cts=6

education/economy/boy/cts=2

commerce/non-economy/girl/cts=3

finance/economy/boy/cts=6

finance/economy/girl/ibm=2

finance/economy/boy/ibm=4

Output should be like this "education/finance/commerce/economy/non-economy/boy/girl cts=32"

"finance/economy/boy/girl/ibm=6"

Please note that data string are frequently changed at respective to the left and right of forward slash and record are in dynamic range.

[JBeaucaire]

I can't see an easy way to get the string ordered the way you demonstrate, but this will put each code into the string one time and collect the totals at the end.

Assuming the data is in column A, run this:

Please Login or Register  to view this content.

[cruise.alter]

Thanks JBeaucaire for spending your valuable time in checking this query.
Its working fine. When I used the same in another sheet (another requirement) by changing cts and ibm to CTs and SRs,
I am getting run time error. Could you please check the data in attached sheet.

Is it possible that I want only two records (based on CTs and SRs) only in same column(A:A) replacing the records which are used

[JBeaucaire]

I've edited the code above to highlight the parts of the code you would need to adapt. Give that a try.

Your new data has the word "cases" at the end of every string, the macro wasn't designed for uncontrolled variations to be thrown in on every version. Do a search/replace on that data to remove the " Cases" before running the macro.

[cruise.alter]

Thanks a lot for checking the error.