Search results

Any updates?

Hi Hui, I am facing the same problem. But the trick you mentioned is not working. Anything else possible? cheers, Deepak

Thanks Hui.

Hi All, Can you please take a look at this?

ok. Thanks.

Hi Hui, Any advantages of using COUNTIFS over COUNTIF in this case?

Hi, There is one way. You can apply Text Filter -> Custom Filter -> does not begins with, on the columns and use GROUP-1 as the keywords. Then just paste the filtered results to sheet 2. cheers, Deepak

can u check now? I was facing error while uploading the file.

Hi All, I want to create a sheet where a small timescale/chart is available, showing resource allocation over dates based on their day to day engagements. I tried doing this in a very crude way, but not happy and satisfied with it. Is there a better way of doing this? Attached is the sheet I...

Hi, I am Deepak. I have been following Chandoo.org for more than 2 years now and am fascinated by what Chandoo and team does on excel. I am happy to be able to meet Chandoo and you all on this forum. Cheers, Deepak

Anyone, any inputs?

Hi, I have one problem related to word merge, wherein my data source is excel sheet. What I am currently doing, is generating a word document based on the data filled in a single row of the excel (data source). • For example, I have the document with 26 merge fields as 1. Work...

Hi Friends, With conditional formatting, is it possible to have certain cells highlighted based on a condition? I would elaborate the problem. I have several columns say col1, col2, col3 till say col 10. In col1, I will have a list type of selection for all the rows, where some fixed values...

Dear Luke, Vijay, I must thank you for the kind help. I tried both the formulas with below start date ann end dates. Can you please confirm, which is perfect? Start Date End Date Luke Formula Vijay Formula ------------- ------------ ------------- ------------------ 2/28/2008 3/29/2011 1125...

HI, I have to find out no. of days between any two dates (may not be in the same year) with a complete accuracy, in MS Excel 2003. Is there a way to do this? Cheers, Deepak