input and sample outputs are demonstrated in the excel along with this post. please check it and give me a solution. Because I want to separate data in the list as per the order sheet in my shop with formula in excel. experts please help me. https://docs.google.com/spreadsheets/d/1EgVxGlPhbh_385S2PKNL3YtGEol8RpSlSvQnolJ1gzE/edit?usp=sharing INPUT VALUES CUSTOMER NAMEVEHICLE NO OF BOXES CUSTOMER NAMEVEHICLENO OF BOXES A1 CHICKEN ( FORTKOCHI C/O RAJU )EICHER10 ALEX NANMA LINE - PICKUPPICKUP2 AFSAL POLAKANDAMsmall EICHER 2 ARUN PERUMPADAPPU - PICKUPPICKUP5 ALEENA C/O RAIU THOPPUMPADY - MorningEICHER25 BIBIN'S PALLURUTHYsmall EICHER 63 ALEX KANDHAKADAVUEICHER5 CLETUS PALLURUTHYEICHER4 sample OUTPUT MUST BE LIKE THE list given belowANIE PETER KOOVAPADAMEICHER6 HAMSA PALLURUTHYEICHER0 remove the entire row if the value is equal to 0.00ANTONY KANDHAKADAVUsmall EICHER 8 JABBAR PALLURUTHYsmall EICHER 2 ANTONY THOPPUMPADY - MorningEICHER12 JAIMI PALLURUTHY - PICKUPPICKUP56 LIST 1 : PICKUP LIST 2 : EICHER LIST 3: small EICHER ANTONY KANNAMALY - Morningsmall EICHER 84 JENSON EDAKOCHI (P) - PICKUPPICKUP4 1GEORGE SUNIL THOPPUMPADY1 1A1 CHICKEN ( FORTKOCHI C/O RAJU )10 1AFSAL POLAKANDAM2 GEORGE SUNIL THOPPUMPADYPICKUP1 JOB / LISSY XAVERPICKUP8 2JOLY THOPPUMPADY36 2ALEENA C/O RAIU THOPPUMPADY - Morning25 2ANTONY KANDHAKADAVU8 JOHNY MUNDHAMVELIEICHER0 JOHNSON PERUMBADAPPU - PICKUPPICKUP0 3POLY JOSEPH SOUDI PALLY ( JOSEPH THOPPUMPADY ) - PICKUP4 3ALEX KANDHAKADAVU5 3ANTONY KANNAMALY - Morning84 JOJO POLAKANDOMEICHER0 JOSI KUMBALANGYEICHER7 4RINSHAD POLAKANDAM68 4ANIE PETER KOOVAPADAM6 4LOUIS MUNDHAMVELI35 JOLY ISLAND - MorningEICHER2 JOY c/o ANTONY KOLLASSERY - PICKUPPICKUP0 5SHAJAHAN CHERLAYI KADAVU ( SHAJAHAN THOPPUMPADY )1 5ANTONY THOPPUMPADY - Morning12 5TELBIN THOPPUMPADY45 JOLY THOPPUMPADYPICKUP36 LAILA NISSAM PALLURUTHYPICKUP6 6SUSAN POLAKANDOM2 6JOLY ISLAND - Morning2 6BIBIN'S PALLURUTHY63 JOSEPH MUNDHAMVELIEICHER52 LISSIE XAVIOR PALLURUTHYsmall EICHER 3 7ALEX NANMA LINE - PICKUP2 7JOSEPH MUNDHAMVELI52 7JABBAR PALLURUTHY2 JUSTIN C/O JHONYEICHER12 MANSOOR PALLURUTHYEICHER0 8ARUN PERUMPADAPPU - PICKUP5 8JUSTIN C/O JHONY12 8LISSIE XAVIOR PALLURUTHY3 LOUIS MUNDHAMVELIsmall EICHER 35 MITHUN PMJ CHICKEN (P)small EICHER 1 9JAIMI PALLURUTHY - PICKUP56 9PETER NAVY MUNDHAMVELI23 9MITHUN PMJ CHICKEN (P)1 PETER NAVY MUNDHAMVELIEICHER23 NISSAR JABBAR PALLURUTHYEICHER0 10JENSON EDAKOCHI (P) - PICKUP4 10RAJU THOPPUMPADY - Morning5 10NIYAS PALLURUTY2 POLY JOSEPH SOUDI PALLY ( JOSEPH THOPPUMPADY ) - PICKUPPICKUP4 NIYAS PALLURUTYsmall EICHER 2 11JOB / LISSY XAVER8 11SANSON MUNDHAMVELI23 11PHILIP KUMBALANGY (P)23 RAJU THOPPUMPADY - MorningEICHER5 NOUSHAD PALLURUTHYEICHER6 12LAILA NISSAM PALLURUTHY6 12SELMA THOPPUMPADY2 12SUDHEER PALLURUTHY R.C5 RINSHAD POLAKANDAMPICKUP68 PETER PALLURUTHYPICKUP0 13ROBIN EDAKOCHI - PICKUP56 13SIMI THOPUMPADY3 SANSON MUNDHAMVELIEICHER23 PHILIP KUMBALANGY (P)small EICHER 23 14SABU PERUMBADAPPU - PICKUP49 14CLETUS PALLURUTHY4 SELESTIN KANNAMALYEICHER0 ROBIN EDAKOCHI - PICKUPPICKUP56 15SAINU JABBAR PALLURUTHY5 15JOSI KUMBALANGY7 SELMA THOPPUMPADYEICHER2 SABU PERUMBADAPPU - PICKUPPICKUP49 16SOUMYA KUMBALANGY2 16NOUSHAD PALLURUTHY6 SHAJAHAN CHERLAYI KADAVU ( SHAJAHAN THOPPUMPADY )PICKUP1 SAINU JABBAR PALLURUTHYPICKUP5 17THANKACHAN PALLURUTHY (P) - PICKUP3 SHYBU CHELLANAMEICHER0 SANU STORESsmall EICHER 0 SIMI THOPUMPADYEICHER3 SIYAD PALLURUTHY - PICKUPPICKUP0 TOTAL BOXES =308 TOTAL BOXES =197 TOTAL BOXES =273 SUSAN POLAKANDOMPICKUP2 SOUMYA KUMBALANGYPICKUP2 TELBIN THOPPUMPADYsmall EICHER 45 SUDHEER PALLURUTHY R.Csmall EICHER 5 VINOD PETER NAVY MUNDHAMVELIEICHER0 THANKACHAN PALLURUTHY (P) - PICKUPPICKUP3 THOMAS JANSON PALLURUTHYEICHER0

jumbo1210 A partial solution is available in the attached workbook, on the Order Lists worksheet. See the _Info worksheet for notes and references.

sorry , your solution is not working. i tried to edit the values in column "NO OF BOXES". its not working

jumbo1210 See the attached file (Sheet2) for the solution.

your excel file is also not working. please try to change the input values and check the output values of the system by changing the number of boxes.

jumbo1210

Copper Contributor

May 28, 2024

need guidance for excel formula

input and sample outputs are demonstrated in the excel along with this post. please check it and give me a solution. Because I want to separate data in the list as per the order sheet in my shop with formula in excel. experts please help me. https://docs.google.com/spreadsheets/d/1EgVxGlPhbh_385S2PKNL3YtGEol8RpSlSvQnolJ1gzE/edit?usp=sharing



INPUT VALUES

CUSTOMER NAME	VEHICLE	NO OF BOXES	CUSTOMER NAME	VEHICLE	NO OF BOXES
A1 CHICKEN ( FORTKOCHI C/O RAJU )	EICHER	10	ALEX NANMA LINE - PICKUP	PICKUP	2
AFSAL POLAKANDAM	small EICHER	2	ARUN PERUMPADAPPU - PICKUP	PICKUP	5
ALEENA C/O RAIU THOPPUMPADY - Morning	EICHER	25	BIBIN'S PALLURUTHY	small EICHER	63
ALEX KANDHAKADAVU	EICHER	5	CLETUS PALLURUTHY	EICHER	4		sample OUTPUT MUST BE LIKE THE list given below
ANIE PETER KOOVAPADAM	EICHER	6	HAMSA PALLURUTHY	EICHER	0		remove the entire row if the value is equal to 0.00
ANTONY KANDHAKADAVU	small EICHER	8	JABBAR PALLURUTHY	small EICHER	2
ANTONY THOPPUMPADY - Morning	EICHER	12	JAIMI PALLURUTHY - PICKUP	PICKUP	56	LIST 1 : PICKUP			LIST 2 : EICHER			LIST 3: small EICHER
ANTONY KANNAMALY - Morning	small EICHER	84	JENSON EDAKOCHI (P) - PICKUP	PICKUP	4	1	GEORGE SUNIL THOPPUMPADY	1		1	A1 CHICKEN ( FORTKOCHI C/O RAJU )	10	1	AFSAL POLAKANDAM	2
GEORGE SUNIL THOPPUMPADY	PICKUP	1	JOB / LISSY XAVER	PICKUP	8	2	JOLY THOPPUMPADY	36		2	ALEENA C/O RAIU THOPPUMPADY - Morning	25	2	ANTONY KANDHAKADAVU	8
JOHNY MUNDHAMVELI	EICHER	0	JOHNSON PERUMBADAPPU - PICKUP	PICKUP	0	3	POLY JOSEPH SOUDI PALLY ( JOSEPH THOPPUMPADY ) - PICKUP	4		3	ALEX KANDHAKADAVU	5	3	ANTONY KANNAMALY - Morning	84
JOJO POLAKANDOM	EICHER	0	JOSI KUMBALANGY	EICHER	7	4	RINSHAD POLAKANDAM	68		4	ANIE PETER KOOVAPADAM	6	4	LOUIS MUNDHAMVELI	35
JOLY ISLAND - Morning	EICHER	2	JOY c/o ANTONY KOLLASSERY - PICKUP	PICKUP	0	5	SHAJAHAN CHERLAYI KADAVU ( SHAJAHAN THOPPUMPADY )	1		5	ANTONY THOPPUMPADY - Morning	12	5	TELBIN THOPPUMPADY	45
JOLY THOPPUMPADY	PICKUP	36	LAILA NISSAM PALLURUTHY	PICKUP	6	6	SUSAN POLAKANDOM	2		6	JOLY ISLAND - Morning	2	6	BIBIN'S PALLURUTHY	63
JOSEPH MUNDHAMVELI	EICHER	52	LISSIE XAVIOR PALLURUTHY	small EICHER	3	7	ALEX NANMA LINE - PICKUP	2		7	JOSEPH MUNDHAMVELI	52	7	JABBAR PALLURUTHY	2
JUSTIN C/O JHONY	EICHER	12	MANSOOR PALLURUTHY	EICHER	0	8	ARUN PERUMPADAPPU - PICKUP	5		8	JUSTIN C/O JHONY	12	8	LISSIE XAVIOR PALLURUTHY	3
LOUIS MUNDHAMVELI	small EICHER	35	MITHUN PMJ CHICKEN (P)	small EICHER	1	9	JAIMI PALLURUTHY - PICKUP	56		9	PETER NAVY MUNDHAMVELI	23	9	MITHUN PMJ CHICKEN (P)	1
PETER NAVY MUNDHAMVELI	EICHER	23	NISSAR JABBAR PALLURUTHY	EICHER	0	10	JENSON EDAKOCHI (P) - PICKUP	4		10	RAJU THOPPUMPADY - Morning	5	10	NIYAS PALLURUTY	2
POLY JOSEPH SOUDI PALLY ( JOSEPH THOPPUMPADY ) - PICKUP	PICKUP	4	NIYAS PALLURUTY	small EICHER	2	11	JOB / LISSY XAVER	8		11	SANSON MUNDHAMVELI	23	11	PHILIP KUMBALANGY (P)	23
RAJU THOPPUMPADY - Morning	EICHER	5	NOUSHAD PALLURUTHY	EICHER	6	12	LAILA NISSAM PALLURUTHY	6		12	SELMA THOPPUMPADY	2	12	SUDHEER PALLURUTHY R.C	5
RINSHAD POLAKANDAM	PICKUP	68	PETER PALLURUTHY	PICKUP	0	13	ROBIN EDAKOCHI - PICKUP	56		13	SIMI THOPUMPADY	3
SANSON MUNDHAMVELI	EICHER	23	PHILIP KUMBALANGY (P)	small EICHER	23	14	SABU PERUMBADAPPU - PICKUP	49		14	CLETUS PALLURUTHY	4
SELESTIN KANNAMALY	EICHER	0	ROBIN EDAKOCHI - PICKUP	PICKUP	56	15	SAINU JABBAR PALLURUTHY	5		15	JOSI KUMBALANGY	7
SELMA THOPPUMPADY	EICHER	2	SABU PERUMBADAPPU - PICKUP	PICKUP	49	16	SOUMYA KUMBALANGY	2		16	NOUSHAD PALLURUTHY	6
SHAJAHAN CHERLAYI KADAVU ( SHAJAHAN THOPPUMPADY )	PICKUP	1	SAINU JABBAR PALLURUTHY	PICKUP	5	17	THANKACHAN PALLURUTHY (P) - PICKUP	3
SHYBU CHELLANAM	EICHER	0	SANU STORES	small EICHER	0
SIMI THOPUMPADY	EICHER	3	SIYAD PALLURUTHY - PICKUP	PICKUP	0		TOTAL BOXES =	308			TOTAL BOXES =	197		TOTAL BOXES =	273
SUSAN POLAKANDOM	PICKUP	2	SOUMYA KUMBALANGY	PICKUP	2
TELBIN THOPPUMPADY	small EICHER	45	SUDHEER PALLURUTHY R.C	small EICHER	5
VINOD PETER NAVY MUNDHAMVELI	EICHER	0	THANKACHAN PALLURUTHY (P) - PICKUP	PICKUP	3
			THOMAS JANSON PALLURUTHY	EICHER	0

excel

Formulas and Functions

Forum Discussion

need guidance for excel formula

10 Replies

Resources