Search results

Thanks to both! Works like a charm.

I have column A as Date and column B as points. Column A looks like this: 7/26/2013 7/26/2013 7/26/2013 7/26/2013 7/27/2013 7/27/2013 7/27/2013 7/28/2013 7/28/2013 7/28/2013 7/28/2013 Next to each date there is a point value. I want to add up all of the points to a specific...

SirJB7, thanks so much! This is actually exactly what I was looking for. Sorry for the confusion and appreciate you helping out.

Hi excel family, I want to be able to generate a starting point for any date entered in column A (MM/DD/YYYY) such that the first row in Column B (days) will say "1" and Column C (weeks) will say "1" Right now, I have days entered in manually with first row =1, and subsequent rows as first...

Thanks so much - worked perfectly!

Hi all, I have a list of 2,000 email addresses on sheet 1. On sheet 2, I have a list of email addresses that are invalid. The problem is, some of the invalid email addresses on sheet 2 are in the list on sheet 1. How can I somehow find the invalid entries on sheet 1 and take them out easily? I...

Just figured it out (stupid oversight).. was on approximate match and not exact... which made the difference. Thanks so much for your help though Luke!

Thanks for the quick response. I identified a couple that are TRUE. So I retested again, knowing they should match, but the vlookup output value is still wrong. The value that should be returned is 2, but it is showing 0. It is really a simple vlookup, minus trying to combine the 3 different...

Hi all, I have 3 unique keys that I have to combine into 1 grand key that I can then use to pull values from another sheet via vlookups. I have user ID (in number format), Current month (dd-mmm-yyyy date format) and I have an action description like #surveys or #projects (in text format)...

Mercatog, Thanks so much for your quick response. It worked wonderfully and just made my work day a lot easier.

I have a "Month" column with 3000 rows that include month abbreviations (in text form, not date formatted) like "Mar" "Apr" "Aug" etc. However, I need them to include the year (2012), so the entries will read "12-Mar" "12-Apr" "12-Aug" etc. Is there an easy way to do this? Any help would be...