item2

  1. M

    Count and concatenate strings.

    Hello guys, I am using xl since years but I am stuck at one point which I can not give a solution. I have cells as below: Item1, Model1 Item1, Model2 Item1, Model3 Item2, Model2 Item2, Model4 I need to result as below: Item1, Model1;Model2;Model3 Item2, Model2;Model4 I have tried countif to...
  2. J

    Classify items by number sold

    Hello, I would like to rate each item to find out why my "bread and butter" items are. e.g. ITEM1 would get something like CC and ITEM2 CA and ITEM14 AA. what formula can look at all items and score according to preset rules (e.g. top 10% = A and so on) <colgroup><col width="64" span="3"...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top