View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christmas May[_2_] Christmas May[_2_] is offline
external usenet poster
 
Posts: 63
Default Formula assistance

I'm given two columns. Column A is an object description. Column B is how
many of that object I have.

Steel blocks 3
Wood blocks 4
Plastic blocks 5
Aluminum blocks 3
Copper blocks 4
Graphite blocks 3

All the blocks are the same size and I have containers to hold specific
quantites of each.

3
4
5

I'm in need of a formula (preferrably not VBA) to populate column B with
which objects will be in which containers
3 Steel blocks, Aluminum blocks, Graphite blocks
4 Wood blocks, Copper blocks
5 Plastic blocks

Any assistance would be greatly appreciated.

Thanks in advance,

Christmas May