• 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.

Search results

  1. S

    Looking for the excel formula to calculate attached rate

    Hello Excel Gurus, I need help developing an Excel formula in the below sheet (Attached). I want to calculate the attached rate for an Accessory as compared to various Finished Goods. Here Accessory ACC1 is going into 2 different finished goods FG1 and FG2. Typically the attached rate for an...
  2. S

    To populate the number of occurrence in a column based on values in another column

    Hi All, Is there a way to populate column E with the occurrence of the value in column B as per the below screenshot (i.e. 1st occurrence, 2nd occurrence and so on) Regards, Siddharth
  3. S

    Sorting of data as groups as per the second column

    Hello , I have 2 columns a. Material , b. Resources. I want to group Material , which use same set of resources . Eg material X uses Resources 1 , 2 and 3. Material Y uses Resources 1, 2 ,4. Material Z uses Resources 1 , 2 and 3. So I want to identify Material X and Z together and Material Y as...
  4. S

    Convert values from one unit to another using VBA

    Hello Gurus , PFA the sample file. We need to convert the values highlighted in YELLOW to the Sales Unit of measurement from Base unit of measurement using VBA IF sales UoM = Base UoM , do nothing to the values of the corresponding row IF Sales UoM = GAL and Base UoM = L , values =...
  5. S

    Calculation of a value every Fiscal Year

    Hi Gurus, I have a requirement as below: The calculation for the cumulative shortfall is equal to the sum of Shortfall values of Previous + Current month of the Fiscal year 14-15 ( April 2014 - March 2015). I want the calculation of Cumulative Shortfall to be restricted for the same fiscal...
  6. S

    Add numeric columns for duplicate entries according to some key fields

    Hi All, I have an excel sheet with columns which might have duplicate records when comparing some key fields which I have marked as green. Now the rest of the fields are numeric fields. I want that columns with numeric values of the duplicate records should get added(total) and only unique...
  7. S

    How to append 0s before a set field of 10 characters when the characters inserted are 4

    Hello , How to append 0s before a set field of 10 characters when the characters inserted are 4 . Eg. the field accepts the character length 10 , so , if the value is 12345 , for the remaining spaces should pe appended by 0s resulting in 0000012345 . ab = 00000000ab monkey = 0000monkey...
  8. S

    extracting data from string

    Hi Guys , I am in a crunch situation. I want to extract data from a set of strings. Eg. Product A123 does not exist in plant 111 Product B123 does not exist in plant 222 Product C123 does not exist in plant 333 so i should be able to extract Products. A123 ,B123 & C123 in one sheet...
Back
Top