Recent content by ajayxlnc

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

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"))...

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

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

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

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

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

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

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

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

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

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

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

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

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