Search results

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.

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

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

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

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

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

Thank You Narayan in advance.

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

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.

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

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