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 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
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 Read More
