• 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. A

    Broken Links in Excel 2007

    Hello, I have an excel file with 4297 Hyperlinks to the external sites. I need a VBA code which can run the code and check for the broken links. I want to know how many links are active and how many are broken. Please help me out in this issue Here is the Link...
Back
Top