• 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

M

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:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
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)
 
You must log in or register to reply here.
Back
Top