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

    Highlight Duplicates by two column Values

    Thanks a lot for your formulas @p45cal it is working excellent.
  2. A

    Highlight Duplicates by two column Values

    Dear All, Is there any other shorter formula than the below one? to find the duplicates in more than 300 column values? =Countifs(E8:E18,E8,F8:F18,F8.........................................KQ8:KQ18,K8)>1
  3. A

    Highlight Duplicates by two column Values

    @pecoflyer As per your suggested link, I found the duplicate value where the two columns are having data. But Now the actual data got increased up to 300 columns. For example, I have added some small data like the below picture. As per the below picture Products, 2 and 10 are duplicates as...
  4. A

    Date format not getting assigned in all rows.

    @pecoflyer Your idea also working good. Thanks a lot for your information.
  5. A

    Date format not getting assigned in all rows.

    Dear Excel Genius, I have exported massive data from a table of MySql .MDF to Excel. After opening excel sheet the date format is not getting the same in all the rows. I have more than 25000 rows of data. I need to convert all 3 columns' format as "DD-MMM-YYYY HH:MM:SS" See below the snapshot...
  6. A

    .Undo code need to perform after accept Vbokonly

    @Marc L Thanks for your code. In my actual sheet Intersect reference in another sheet "Sheet2.range("E10:G11") I don't know how to change the below code line from If Not Intersect([K16:M17], Target) Is Nothing Then to if not intersect(. ) is nothing then. I attached the sample...
  7. A

    .Undo code need to perform after accept Vbokonly

    Dear Excel Genius As per the below snapshot, if row 15 gets negative values when I change the values in rows 16 and 17, then I get the pop-up message. If I press OK then it has to do ".Undo" to get back the previous positive values in row 15. I used the below code for the pop-up message...
  8. A

    Using Sumproduct in Multiple Columns

    Dear Excel Genius, I use the Sumproduct function in the alternate cells to calculate the RM Purchase cost. 3 sample formulas and their snapshot are below. =SUMPRODUCT(Purchase[Price RM1],Purchase[Qty RM1]) =SUMPRODUCT(Purchase[Price RM2],Purchase[Qty RM2]) =SUMPRODUCT(Purchase[Price...
  9. A

    Data Validation not POP-UP a message

    Yes, I found the mistake in what I did. Actually, I applied data validation only in the "K15" Now I understood and applied the data validation in the input cells too, which is trigger the pop-up messages promptly. Once again thanks a lot for your valuable reply @pecoflyer
  10. A

    Data Validation not POP-UP a message

    Thanks @pecoflyer
  11. A

    Data Validation not POP-UP a message

    The attachment is here.
  12. A

    Data Validation not POP-UP a message

    @pecoflyer Thanks a lot for your reply The Data Validation pop-up comes when I edit the cells and not the value gets negative as per its formula. See below GIF I have added custom data validation with the formula. Find the attached sheet FYI. I am not preferred to use Conditional Format as...
  13. A

    Data Validation not POP-UP a message

    Dear Excel Genius I want to pop up a message when the cells have negative values. To achieve that I used Data Validation > Decimal > Between > Error Message like below snapshot. After applying the data validation, I got pop up when I entered the negative values manually like below snapshot...
  14. A

    Highlight Duplicates by two column Values

    Dear Excel Genius In the below values, Many Names and F1 to F6 are repeated and duplicates exist. But I want to highlight the duplicates with both the columns, not just in one. For Example, Anbu F1 is the real duplicates, but if I apply Conditional Formates to find the duplicates, it...
  15. A

    Adding a row in excel table need to add a row in next tables

    Dear Excel Genius I have a excel workbook having 3 tables in one sheet name called "Production" Table 1, Product_Formulation Table 2 Consumption Table 3 Cost_Calcu Table 2 and Table 3 data updated from table1 with formulas. But I don't know how to activate them. For example, As per below...
  16. A

    Expect Excel formula to find the product price by FIFO Method

    Excellently working!!! Thanks again @Excel Wizard
  17. A

    Expect Excel formula to find the product price by FIFO Method

    @Excel Wizard I have transferred your suggested formula into my real working sheet where I have 34 RM (18 is Active) and above 40 products. all it is in Table format. I did some mistakes while transferring the formula. please see the below image and the attached file for the modification...
  18. A

    Expect Excel formula to find the product price by FIFO Method

    @Peter Bartholomew Thank you so much for your post and the lambda function in detail. I will create the real data with an example set of data. then I will transfer the lambda to there. if I get stuck somewhere then I will ask the question by posting here. Once again thanks for the lambda...
  19. A

    Expect Excel formula to find the product price by FIFO Method

    Working perfectly. Thanks a lot for your support.
  20. A

    Expect Excel formula to find the product price by FIFO Method

    @Peter Bartholomew I have observed and added the naming of RM2 to RM10 and I got the desired results in the sample file. But I don't know how to transfer the same to my actual file as it is having some kind of code inside the name manager. Sorry for my inability in the same. Thanks again...
Top