title: Excel: Need to Generate IDs based on multiple criteria with repeating IDs
body: <p>Looking to create pricing groups bases on multiple criteria. Each group could have multiple items within the group. I'm struggling with the autocreation the naming of each group. I estimate there should be about 6.5K pricing groups out of 14K items.</p>
  <p>Below is the criteria -</p>
  <p>QTY per case - is the number of bottles in a case
  Size - size of the bottle
  Family Brand - contains a group of like items
  Code - CS1 - This is my unique code for each group that contains each of the above and lowest possible case price.</p>
  <p><a href="https://i.stack.imgur.com/ZFw6B.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>The &quot;Thinking&quot; column is how I want each group to look, but how do I do this with 14K items quickly?</p>