Search results

Nevermind, I was able to download. Will look at it and get back soon. Thanks again :)

Narayan, I truly appreciate your response. Unfortunately when I click on the link, I don't see anything. It says no preview available. :(

thanks Narayan, I'll wait.

Hello, Can anyone help me on this please? Thanks!

Here's an example of the worksheet: https://docs.google.com/spreadsheet/ccc?key=0AsoAJIfjMjo2dFdRUHhNdGg4OC1INHAwSzVmTU5Xa2c Thank you! Supat

I am using excel 2007

Hello, Is there an excel function that can give me due dates excluding holidays and weekends (sat and sunday), but including the first saturday after each quarter end? Here's an example: Task Due day Due date A 2 7/3/2012 B 3 7/5/2012 excluding July 4th weekend C 4 7/6/2012 D 5 7/7/2012...

Thank you very much Luke M! Highly appreciate your help!

bobhc -thanks for your response. The networkdays.intl works only in excel 2010, and not in 2007. I am on excel 2007 and that's why I am looking for an alternative. oldchippy - thanks for your response. I went over pearson's link before posting here - the link has a VB code which I do not know...

Hello, Can someone help me how to define just Sunday as weekend in the workday function in excel 2007? I have a list defined for 'HOlidays' which I'd like to the excluded in addition to Sunday for the WORKDAY function. Thanks much in advance. Supat

Hello everybody, I joined in last night. After browsing through various other excel sites, this one seemed the best. The topics discussed here are very very helpful. Chandoo - kudos!! fyi... I graduated from AU as well. Cheers, Supat

Luke, that sounds reasonable. I'll surprised though if there's not an easier fix to it. I like VijaySharma's solution, but the string is a lot complicated compared to the sumproduct one.

This is fantastic! Thanks much Vijay Sharma. Just for curiousity, would you know why such formula =sumproduct(1/countifs(B2:B10,B2:B10,A2:A10,"LK"))) won't give the desired results? Thanks again, and really appreciate your help! Supat

that's correct. I could have 10 different values in Col A. Using an IF condition will mean creating one such column for each such value - which is why I don't want to tread that path. My goal is to get a summary total of unique values in Col B, for each category in Col A. Thanks, Supat

Thanks for your response. I am able to accomplish the result I need by creating a new column C to my dataset and defining =if(A2="LK",B2,"") And then summing up = sumproduct((C2:C10<>"")*(1/countif(C2:C10,C2:C10))) However, this looks like a roundabout solution. I am really looking for a...

Hello, I am looking for a function that can give me unique count of values in one column based on condition if met in a differnt column. Eg: COL A COL B AB cat AB dog LK horse LK dog LK dog LK rat Answer: Unique count with LK in column A is 3. Appreciate any help! Thanks, Supat