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

    Looking for data across sheets

    I need populate the data from lactogen1,lactogen2 to praveen sheet
  2. M

    I am not able to select a file in the upload file

    Iam not able to select a file in the upload file
  3. M

    Conditional Formating

    8-10 =400 11-15= 675 16-20= 950 21-25 =1200 There are four small slabs in one column Less than 7 for 400 slab should be marked in red Less than 11 for 675 slab should be marked in red Less than 16 for 950 slab should be marked in red Less than 21 for 1200 slab should be marked in red...
  4. M

    Need Short way to do it

    Data Source is the first Sheet YGTTFC031 (14) Regards Mohandas
  5. M

    Need Short way to do it

    I used right function to get the pack code to normal pack code which is max of eight digits I used to advance to filter to remove the duplicates pack code and used sum if to add up data of duplicate codes. Is there any way to reduce the time and work Regards Mohan
  6. M

    Summing up as per the text

    In that file i have lead pack and normal pack i want to total lead pack and normal pack. For example Milk maid retail lead pack is 10 and normal pack is 10 the naswer should be 20
  7. M

    Summing up as per the text

    Hope u guys understood
  8. M

    Summing up as per the text

    This is the Desired output
  9. M

    Summing up as per the text

    i want to sum the numbers from jan to dec month wise with criteria lead pack for example scm retail is in 2 rows i want it only in 1 row the year total for scm retail should be 37, Please tell how to do it
  10. M

    Summing up as per the text

    I want sum up as per the lead pack. no duplicates
  11. M

    Text to columns

    Thanks
  12. M

    Text to columns

    THis is working out but some time. Some codes are appeaching double time is there any way to do it
  13. M

    Text to columns

    Final Output is P,Q
  14. M

    Text to columns

    No logic it is predfined we can enter it
  15. M

    Text to columns

    Please help me in this format attached .
  16. M

    Macro for Moving multiple sheets data into new sheet based on condition

    after that 21 mins i never bothered to ask in the forum.
  17. M

    Macro for Moving multiple sheets data into new sheet based on condition

    i just asked to help i did not say you are late. Dont take in wrong way
  18. M

    Macro for Moving multiple sheets data into new sheet based on condition

    Please Help
  19. M

    Macro for Moving multiple sheets data into new sheet based on condition

    I have 9 sheets in the atatched file i want to move all sheets into new one sheet where the DC(Column)= HYD Please help
  20. M

    Conditinal formating for negative

    Please find the print scree of ur file
  21. M

    Conditinal formating for negative

    or face book online
  22. M

    Conditinal formating for negative

    can u give ur number i can explain better
  23. M

    Conditinal formating for negative

    yes there is no conditiona format in that
  24. M

    Conditinal formating for negative

    you cannot use another sheet refernences in the condition formattiing is the error
  25. M

    Conditinal formating for negative

    Basically i need the the numbers to be highlighted in the rdbn sheet where the closing which are above(Sum of opening and invoicing) and at the same the if rdbn sheets negative numbers is because of negative numbers in inv sheets then there is no need to format it
Back
Top