• 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

    Yes, I am using the formula that you provided. Thank you.
  3. S

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

    Thanks a lot, AliGW for the prompt reply. Yes, this is working correctly. I even used the formula '=IF(B2=B1,E1+1,1)' in the meanwhile, it gave the same result.
  4. 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
  5. S

    Sorting of data as groups as per the second column

    Hi Srinidhi and AVK , Thanks for the reply , but this is normal sorting . I require the grouping of materials , which have same set of resources. Lets say I have a group of 5 resources for a material , so I want the grouping to be done for the bunch of materials , which share those 5 particular...
  6. 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...
  7. S

    Convert values from one unit to another using VBA

    Hi , Thanks for your reply . Issues in the solution you provided : 1) We need the conversion to be done for individual entries of the row , not the row total. 2)All the quantities are in Base UoM , so , if Sales UoM = Base UoM , then no conversion is needed . Regards Sid
  8. 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 =...
  9. S

    Calculation of a value every Fiscal Year

    Hello Gurus , Please find attached the description of the issue in the spreadsheet. Regards Sid
  10. S

    Calculation of a value every Fiscal Year

    Hello Gurus , Please find attached the description of the issue in the spreadsheet. Regards Sid
  11. 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...
  12. S

    Add numeric columns for duplicate entries according to some key fields

    I was able to do it via pivot tables. Thanks.
  13. 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...
  14. 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...
  15. S

    extracting data from string

    Thanks a lot for your prompt help Luke and Faseeh :)
  16. 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