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

    how to convert text to numbers?

    Can anyone help on this?
  2. B

    how to convert text to numbers?

    Wants to convert this text " One thousand and twelve" to 1012.
  3. B

    How to run column filled data on command prompt from excel?

    I have written multiple command in excel in column. how do i run on command prompt?
  4. B

    Need help for SUMPRODUCT

    Hello Haseeb, Thanks a ton... it's working perfect.. Thank you.
  5. B

    Need help for SUMPRODUCT

    I have tried sumproduct formula but there is some mistake.. Please guide me.
  6. B

    Help for formula please. (remove duplicate and count)

    (remove duplicate and count)
  7. B

    Any Opposite formula of CONCATENATE? or Split the cell value in cells?

    Thanks Lakshmi Narain. Get the exact what i wanth..:) Thanks a lot..
  8. B

    Any Opposite formula of CONCATENATE? or Split the cell value in cells?

    Maximum number would be 25 (till Z column)
  9. B

    Any Opposite formula of CONCATENATE? or Split the cell value in cells?

    Hello Friends, Need small help from your side. I have value 9 in cell A1, now i need 9 zeros in Cell from B1 to Z1. I'll have to change the value in A column and it is maximum till 25. So i no need to use more columns after column Z. If i write 5 in A2 then the result would be in B2 to F2 = 0...
  10. B

    Please help on Spell to number and number to spell

    Hello Azumi, Thanks a lot.. It is exactly that what i want.. Thank you.:)
  11. B

    conditional formatting

    Hello Ysherriff, Have tried here as my knowledge. Hoping that it can help you. Thanks.
  12. B

    Please help on Spell to number and number to spell

    Hello Friends, I have checked the below given link http://chandoo.org/forum/threads/how-convert-number-to-text-in-excel.12009/ I get the nearest result. But actually i wants to teach my boy. I don't want "Rupees only" or"Paisa" at last.. and If Possible I would also like to convert Spell to...
  13. B

    IF formula doesn't allowed name?

    Thanks Dileep, Thanks for your nice suggestion..:)
  14. B

    IF formula doesn't allowed name?

    =IF(C2 = T., 0,1):( name error. Can anyone please guide me?
  15. B

    Author name protection

    How to protect only the author name in excel 2007? I don't want to protect another things in sheet. Please guide me Thanks you all.
  16. B

    Sum with muliple criteria

    Thanks Xiq, It works.. Thanks a lot..:)
  17. B

    Sum with muliple criteria

    Hello Xiq, Your efforts are too good but "helper column" extend my efforts a lot.. Total time spent v1 & v2 is also good.. Can't we skip the helper column?
  18. B

    Good Efforts Never fail

    Good Efforts Never fail
  19. B

    Sum with muliple criteria

    Hello Friends, Need your help for sum with multiple criteria. It is difficult to describe here. So i have uploaded here excel file.. Thank you all.
  20. B

    Try hard.. luck is not far..

    Try hard.. luck is not far..
  21. B

    Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

    Thanks Narayan, it is working perfectly.. You always help me in need. Salute you.:) Thank you..
  22. B

    Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

    Can anybody help me this.. extreme need for your help.
  23. B

    Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

    Thanks Hui.. It is working fine. but little bit problem, When there is file name contain N.jpg then the value should be in F row (F2) blank or zero. Cause it is added in T.jpg
  24. B

    Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

    Hello Hui, Que 1. => yes. Que 2. => 2 or 3 rows per date. Que 3. => yes. Thanks for Responding.
Top