Seperation of prime and sub inventory units
 

Good afternoon,

I'm looking to seperate inventory items into PRIME and SUB units..

Example: Sodas have are in cases of 24 so the PRIME unit would be 1. If you had 26 cans total it would then be 1 PRIME(cases) and 2 SUB(cans). I need the prime and sub units in seperate cells.

Hope i explained what i needed so you understand..

Thanks

Geoff

Seperation of prime and sub inventory units
 

With a look up table for your categories like so:
Category Prime
Sodas 24
Apples 48
Oranges 50
Pencils 10
And your data like so:
Inventory Amount I Prime I Unit
Sodas 26 1 2
Pencils 7 0 7
Oranges 105 2 5
Apples 252 5 12
The following formulas appear to do what you ask. Note, there is no error
checking on the vlookup so you could get errors if there was no match like so:
Apple 252 #N/A #N/A
But, that may be what you want so that you know you need to either correct
the spelling or add a new category.
INT(B8/VLOOKUP($A8,$A$2:$B$6,2,FALSE))
MOD($B8,VLOOKUP($A8,$A$2:$B$6,2,FALSE))



"Novice" wrote:


Good afternoon,

I'm looking to seperate inventory items into PRIME and SUB units..

Example: Sodas have are in cases of 24 so the PRIME unit would be 1. If
you had 26 cans total it would then be 1 PRIME(cases) and 2 SUB(cans). I
need the prime and sub units in seperate cells.

Hope i explained what i needed so you understand..

Thanks

Geoff


--
Novice