Formula Excel/VBA

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3070102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EFormula%20Excel%2FVBA%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3070102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3Eif%20BOM%20%3D%201%20then%20SPI%2C%20if%20BOM%20%3D%2010%20then%20CPI%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ewhen%20we%20disptach%20the%20item%20from%20warehouse%20to%20store%20then%20first%20prority%20goes%20to%20CPI%20and%20then%20SPI.%3CBR%20%2F%3EBut%20due%20to%20some%20technical%20issue%2C%20in%20many%20cases%20SPI%20went%20to%20store%20first%20and%20then%20CPI.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ENow%2C%20I%20have%20to%20find%20out%20that%20if%20system%20sent%20any%20style%20%22123%22%20to%20branch%20%22456%22%20then%20was%20it%20a%20SPI%20or%20CPI.%20Basically%20did%20SPI%20went%20first%20or%20CPI%20based%20on%20date.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3070102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMacros%20and%20VBA%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

if BOM = 1 then SPI, if BOM = 10 then CPI

when we disptach the item from warehouse to store then first prority goes to CPI and then SPI.
But due to some technical issue, in many cases SPI went to store first and then CPI.

Now, I have to find out that if system sent any style "123" to branch "456" then was it a SPI or CPI. Basically did SPI went first or CPI based on date.

1 Reply
When we disptach the item from warehouse to store then first prority goes to CPI (complex pack which is 10 BOM) and then SPI(simple pack, which has 1 BOM).
But due to some technical issue, in many cases system is sending Simple pack to to store first and then complex pack.

if BOM = 1 then SPI, if BOM = 10 then CPI

Now, I have to find out if system is sending any style "123" to branch "456" (based on date)
1) both SPI and CPI on same date (together).
2) SPI first
3) CPI first