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

Recent content by asowdi

  1. A

    SEPERATE TEXT NUMBER

    Deb, Check out this thread, it may solve 50% of your problem http://chandoo.org/forums/topic/separate-number-from-text-thru-formula
  2. A

    quick Question

    hi Its working fine with me here, Try to change the format first and enter the date. mean time am using MS office2007 here.
  3. A

    quick Question

    Hi Ausikenoath Follow below procedure to get the date in required format 1. Right click on the cell where you have entered date. 2. Go to "Formats" and Select "Customs" 3. Below "Type" enter "dddd, dd-mm-yyyy" 4. Now enter date in this format "05/28/2012".
  4. A

    Count Unique value

    I got it, its total 132 ; Many Thanks Narayan for your time and effort. Ashwin S
  5. A

    Count Unique value

    Hi all Today I came across this issue, on my birthday, I wanted to invite my friends, I have made group and added all my friends there, added same group in TO list of email and expanded that group to know how many are there in group. As there are many in the list, I thought to copy info to...
  6. A

    Auto generate numbers under Lists

    Shermansee, Its better if you share sample sheet.
  7. A

    Indirect Formulas

    @Montrey Congratulations :)
  8. A

    How to add our photograph/ Pictures in chandoo Posting Icon

    Senthil, You can add your profile pic in http://gravatar.com/ In turn it you can see it in chandoos blog. PS: Use same email ID in gravatear which u used to create chandoo ID.
  9. A

    Need help to capture data

    Thanks Faseeh, u r right, this was the repost....i could not able to fetch the detail last time so reposted. Many thanks for your time.
  10. A

    Need help to capture data

    Friends I have two columns A and B. "A" carries Task Name, "B" with the Engineer name. Engineers name repeat in "B" column assuming same engineers handle different tasks. I am trying to capture task handled by each engineer in one cell separated by commas. Can anyone help me to get the right...
  11. A

    Perentage calculation between two dates

    Many thanks Hui & Narayan. have good day ahead.
  12. A

    Perentage calculation between two dates

    Can anyone help me to find the percentage of completion of task? I have task with "start date" and "end date". I want to calculate percentage of completion of task as on today’s date.
  13. A

    Index and Match Function

    @ mrzoogle Many thanks for your time. Regards Ashwin S
  14. A

    Index and Match Function

    Narayan Thanks for your time on this. I have posted old sheet over here with different requirement. My earlier requirement code given by Faseeh and its working fine. My other requirement is below,Request you to ignore my earlier need in this chain. Below is latest. "I am trying to capture...
  15. A

    Index and Match Function

    Faseeh Many thanks. Will see how to present this. Have good weekend Regards Ashwin S
Back
Top