• 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

    Help regarding a IF Function with multiple conditions...

    Thanks Yaar Faseeh, Check out the sample data https://docs.google.com/file/d/0B_8nXiEldUKKZUVXV0EwRDZnTjQ/edit?usp=sharing From B351:B1136 in Date column the dates are blank and there are no dates, but in the remarks columnD it is showing as Delivery Date already over (Ex: D430:D432). But...
  2. A

    Help regarding a IF Function with multiple conditions...

    Thanks Faseeh, I want the Already Done comment to be added in the nested if function after satisfying the date condition also =IF(ISERROR(MATCH(E2,{"Approved","Committed","New"},0))=TRUE,"",IF(J2<TODAY(),"Delivery Date already over","Target Release T2 - Delivered after 31.10.2013"))...
  3. A

    Help regarding a IF Function with multiple conditions...

    Faseeh, Yes the file looks great and i have made few changes and i am able to get the required output. I have one more request, one more nested if function to be added to the formula =IF(ISERROR(MATCH(E2,{"Approved","Committed","New"},0))=TRUE,"",IF(J2<TODAY(),"Delivery Date already...
  4. A

    Help regarding a IF Function with multiple conditions...

    Yeah can you please do that as i am getting the other way as i described, Thanks
  5. A

    Formatting a data which is pasted from Web page through Delimiter or any other m

    Hello, I have pasted data from a table in the Webpage to the Excel and i found the result (Screen Shot attached) https://docs.google.com/file/d/0B_8nXiEldUKKRnpQMHJXSVlZSEE/edit?usp=sharing In the file, from A1:C10 is the sample data which i have pasted from a Web Page Table. But when i...
  6. A

    Help regarding a IF Function with multiple conditions...

    Hello Faseeh, There is a problem again. For this date 2013-07-17 (Example) the formula is retreiving Target Date which is less than the 2013-07-31. Can you please Edit the formula and send it. Instead of Today use the date 2013-07-31 (31st July) I have the dates column in this format...
  7. A

    Help regarding a IF Function with multiple conditions...

    Hello Faseeh, Thanks, but there is a correction. First the formula in E1 has to check whether in Cell C1 there is which status (Approved/Committed/New) If the Cell C1 Contains any of the three above mentioned status then it has to satisy the next conditions that is the date condition...
  8. A

    Help regarding a IF Function with multiple conditions...

    Hello, 1)I have a column where in i have the status of a user like Approved, Committed, New and few other 2) There is a due date column where in date is mentioned in yyyy-mm-dd format I want the below conditions to be satisfiedMy Requirement is : **) I want an If condition where in it...
  9. A

    Help Needed in Splitting the Address data in one cell to multiple cells

    Hello, I have already deleted the file. Sorry for not checking the content before uploading a sample data. In Cell D2 i have placed the sample address which i have in my data sheet. There is Char(13) in between each and every field i tried all the ways but am not able to remove that...
  10. A

    Help Needed in Splitting the Address data in one cell to multiple cells

    Thanks For the suggestion. But this data is Original, this is not a SPAM. Help needed !!!!!
  11. A

    Help Needed in Splitting the Address data in one cell to multiple cells

    Hello, Help needed in figuring out a solution for my problem. I have a data which contains Sl.No, Mobile No, Email Id, Address Main (4 Columns). In "Address Main" Column the entire address is entered in a single cell Sample: (Xxxxxx yyyyy.Zzzzzzz H.no: 1 10 100/90/B/40, Www Wwwwwwwww...
  12. A

    Help regarding Validation Function Drop Down....

    Thanks Deb, it works like a charm. Thanks a ton.
  13. A

    Help regarding Validation Function Drop Down....

    Hello, I need help regarding Validation drop down menu. I have a file which will track the Funds collected by 20 people month on month. I am using Offset function to pull the data through the drop down menu but i am not able to do that. Please help me out in this as this is for a Charity...
  14. A

    Help Regarding a VBA Code for Checking the links (Dead Active)

    Hello, I have 2 categories of links with me. Column A is one category of Web Links and in Column B there is a list of other category links. 1) I want to check whether the links are active or dead links. 2) I want to match the content of both the web pages in the back end or even in the front...
  15. A

    Help needed on Validation Drop Down

    Hello Vijay, It worked like a charm. Thank You so much. Sorry for the late reply.
  16. A

    Help needed on Validation Drop Down

    Hello Vijay, Yes, it is right. For example if we take Category1 table then the items in the table are shown below. Table-1 -------- Category 1 (Column A) A B C | | U -- Thread Id (Column B) xx-123 xx-121 | | xx-127 -- ----------- When i click on the drop down menu...
  17. A

    Help needed on Validation Drop Down

    Hello Shiva, I have a data, i mean i have around 11 categories. Each category contains 2 columns, One is Category and the other is the ID. There are around 11 of them like that. I am trying to incorporate a drop down menu for only the categories. When i select the cateogry i want the category...
  18. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Thanks a Ton Narayan, It worked like a charm. Thank you so much for your support
  19. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Narayan, Thanks in Advance and Thanks a ton for all the help.
  20. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Hello Narayan, Thanks a ton, it is working like a charm !!!!! But i have few problems. Whenever i am selecting a date a new sheet is getting created but the count is the same for all the sheets (For all the dates). When i change the date the count as per that day has to be displayed in...
  21. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Thank You so much Narayan. If possible can you please help me out in providing the code. Looking forward for you co-operation. Thank You in Advance..
  22. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Yes, I need each day's data to be stored in the same workbook. To be precise the whole month's data in the same work book. Is this possible ???? If not in this way is there any other alternative where i can achieve this kind of environment. Thank You in advance.
  23. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Thank You for your quick reply Narayank991. Yes, you are right. When i change the date in A2, i want the counts in Columns C & F to Change. As shown in the sample data file for 13th Mar'12 the counts are already there and when i select the 14th Mar'12 tomorrow from the date drop, the count...
  24. A

    Help needed regarding VBA Code within Validation Funtion Date Drop Down List

    Hello Excel Gurus, I have a table where i have two Categories, in that i have sub categories also. I will capture the count on a daily basis for all the items (Categories) and by the end of the day i will take the sum of all those items separately. Now i want the same table to be used for the...
Back
Top