• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Eaches from Pack describtion

Mohandas

Member
I want a formula to get eaches from pack description for example 18 for kitkat,for polo 27. Can you help me
PACKEaches
KIT KAT 4 Finger 18(18x37.3g) N3 IN
18​
NESTLE CEREGROW BIB 24x300g IN
24​
CERELAC STAGE 1 Rice BIB 24x300g N3 IN
24​
CERELAC STA1 WheApp Poshan BIB24x300g IN
24​
CERELAC STA1 WheApp Poshan BIB24x300g IN
24​
CERELAC STA1 Wheat Poshan BIB24x300g IN
24​
CERELAC STA2 Rice Veg BIB 24x300g N3 IN
24​
CERELAC STA2 Whe Orange Poshan24x300g IN
24​
CERELAC STA4 MU & Frt Poshan 24x300g IN
24​
CERELAC STG4 MU Dal Veg Poshan24x300g IN
24​
LACTOGEN 2 FU InfFormulaBIB 24x400gN1 IN
24​
POLO Mint Roll 27(23x15g) IN
27
 
Mohandas
Is there clear logic how many letters or so do You uses per PACK to get needed?
Missing kitkat and polo ... hmm?
You could use eg Pivot-table to get those sums, without any formula with You data ...
 
Mohandas
Here is good link for You: How to get the Best Results at Chandoo.org
 
From the beginning , according to the forum’s instructions and laws, you had to upload a file backed by an adequate explanation of the requirement

but Result For Last Row
POLO Mint Roll 27(23x15g) IN
it Must be 23 not 27
***you can use this

Code:
=MID(A2,FIND("x",A2)-2,FIND("",A2)+1)
 
Back
Top