Dear All,
I am facing a problem where I need to concatenate one text string and a number with leading zeros to form an ID. I am attaching the excel with a sample and desired output. Could you please help. I am using MS Office 2010.
Regards,
Santanu
Hi ETAF,
I am using MS Office Professional Plus 2010. Its very unlikely to get equal counts in multiple parameters unless the size of data is too big. As of now, I can make do with this formula.
Thanks for your help.
Regards,
Santanu
Dear All,
I would request you to help me out with a formula to identify the text corresponding to the highest number in a row. I am attaching an excel file for your understanding.
Regards,
Santanu
Dear All,
I have come by a situation where I need to identify and flash the names of the column headers for the blank cells in the respective columns existing in the same row. I am attaching a sample excel for your reference. Please guide me how to accomplish the task.
Regards,
Santanu
Dear all,
I have a text string within which there are a few IDs that I need to extract and make a stack of data. I am attaching a sample where you will find a field called "metadata" in which a text string is present where a few IDs are mentioned. Those IDs within quotes need to be extracted...
Dear All,
I need a help with a situation where I need to create a variable drop down based on input in other fields. I am trying to map the airlines that operate in the morning hours & afternoon hours based on an input of "Slot" (Morning/Afternoon),"City" (Kolkata/Delhi) and "Connection mode"...
Dear All,
Could you please help me with this problem. I have the first name and last name in one cell with a space in between. I would like to extract the first two letters from the first name and first two letters from the last name. How do I do that?
Regards,
Santanu
Dear All,
This is one use case where we receive orders from customers, pick up the orders from the restaurants ordered from, bring them back to the distribution center in the city, package the food and hand it over to the logistics partner who then delivers the food to the customer in his city...
Dear All,
I was doing a Kano Survey where there is a requirement to automate the results. I am attaching a file herewith where you will find the explanation inside. Please help me out with the same.
The prototype of the kind of output has been provided in the excel.
Regards,
Santanu Chatterjee
Thanks Fluff13. While checking you formula, I found a suffix as "_xlfn." befor each function that you have used in the formula and the formula is also coming as an array formula within {}...is it a formula to be applied with CSE?
Regards,
Santanu
Hi Fluff13,
Thanks for guiding me. However, could you please apply it in the excel sheet provided in my mail so that I can properly understand how to go about it?
Regards,
Santanu
Dear All,
In a array of cells in a column there are five names of places and there is a need to create all sorts of permutations that can happen between these places in regard to origin and destination. Each of the places can be a destination and an origin. How to create such a permutation...
I have been trying to figure out a way by which I would be able to identify a number of packaging boxes based on surface volume, that will fit into a bigger box i.e how many of the smaller boxes (if one calculates by surface volume) would fit in a bigger box with a certain surface volume...
Dear Vletm,
I have been working with the formula you had set. Tried to improvise on that within my limitation but could not succeed which is why wrote to you again. May be I failed to explain you the requirement vividly last time which is why I again wrote to you. In the last message that you...