Search results for query: *

Thanks Geoff, I haven't used SumProduct before. This totally worked for me. Thank you Teresa

I need a help writing a formula that sums column C1:C3000 if Column A = Dental Care and in the same row Column B = Spouse. How do I do that? Thanks, Teresa

Gavin, Thank you for educating me again! I had no idea what the -- before the formula meant so I left it out. Skip, Thank you too for all your help.

Nevermind - I got it! Woot Woot... =IF(AND($D2<G$1,OR($E2="",$E2>G$1)),1,0) Thank you all very much for the help. Whew, this was way beyond my ability. Tee

Gavin, How do you turn =--AND($D2<G$1,or($E2="",$E2>F$1)) into a 1 & 0 vs a True & False? Thank you.

Skip, My spreadsheet has a column for each month end. I don't aer about anything in between "aaout 2/1/09 - 2/27/09" or "6/1/09 - 6/29/09". I only care about if they are elig on the last day of each month (or the date in the column heading) A1 1/31/09 B1 2/28/09 C1 3/31/09 ETC..... In my...

I am trying to write a formula that looks at the employee's hire date and termination date at the end of each month to get a count of how many eligible employees we had. Elig = 1 not Elig = 0. Hire Date 2/1/09 Termination Date 6/15/09 1/31/09 should equal 0 2/28/09 thru 5/31/09 should equal...

Hi Skip, Well, since the employee was hired on 2/1/09 then termed on 6/15/09 my end result should be a 0 because he is no longer elig. Do I have my < mixed with my > ?

Can someone tell me why my AND forumual isn't working correctly? I should be getting back a value of 0 but am getting a 1 for the month ending of 6/30/09. What I am trying to do is determine if the employee was eligible as of 6/30/09 based on hire date and termination date. If Elig give me back...

This is perfect!! JUST what I needed. Thank you so very much.

1) takes the Latest_Hire_Date and replace the year with the current year 2) If the resulting date is less than the current date then add a year to that date, otherwise leave it the way it is. Example: 1 Latest Hire Date: 2/2/08 New Result: 2/2/10 Example 2 Latest Hire date: 9/8/73 New...

Thanks Skip, that worked.

John, When I open the csv file in notepad I can see the 040108, however, when opened in excel the leading zero is dropping off. So, the source does have mmddyy until I open it in excel.

Hi All, I have a csv file that is combined with three other excel spreadsheets and turned into a report. One of the columns has the text field that is really a date value; example: 41008 for April 10, 2008. I need to change this to a date and display as 10-Apr-08. Any recommendations? Using...

Skip, I am stuck again. Not fully understanding this formula I am unable to make the smallest change without your help. I understand for this to work that I need to be in column B2, however, I need to put this in column S through X. Thanks again for all your help. Tee

Skip, Can I get greedy for a minute? This worked well for me (thank you), however, there are some employees with up to 6 dep and others with only 1 - is there a way to add an additional forumla that leaves the field blank if it can't find a value instead of #ref?

I have two spreadsheets that I need to do a vlookup to bring values from one to the other. This I know how to do, however, I need an IF statement to ensure I bring over the right value when there are one to many. Sheet 1 columns A B C D E EE...

Wait Wait Wait, I figured it out John.... I read what LEN does. Thank you

John, I need it to count how many characters are in the string before I do =Left(A1, Len(A1) - 1) (probably an if statement too?)

Hi all, I have a spreadsheet that has a string of numbers in cell C. I need to write a formula that counts the characters in cell C and if there are 12 characters bring over the left 11, if there are 11 characters bring over the left 10 else bring over the string. How do I do this? Example of...