$$Excel-Macros$$ Segmentation?

2011-02-15 Thread MikeMikeMike
Say for example I have one tab that has a list of contact information - say anywhere from 1000 to over 100,000 contact items that include name (one field for first and last name), phone, address, etc. On the other tab I have a list of Categories. 1 column for Category Name and the other for a

$$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-15 Thread MikeMikeMike
I am struggling with this and wondering if you could help.. Worksheet 1 Column A B Keyword Category telecom Telecom tele com#N/A Worksheet 2 Column A B termcategory telecom Telecom telcom Telecom tele comTelecom What I want to do is pull the category name from worksheet 2

$$Excel-Macros$$ Question for you Excel Masters out there...

2011-02-09 Thread MikeMikeMike
Greetings, I have a question I am hoping to find the answer of here... I have a spreadsheet that signifies that includes revenue which is represented on my pivot charts as bars represented by a month (a good example but I could come up with others of course). Simple enough right? Well what if I

$$Excel-Macros$$ vlookup? sumproduct? sumif? argghhh!?

2010-10-11 Thread MikeMikeMike
First of all thank you for any effort put in this direction. I am having problems with a couple excel formulas that I really need to get right for a client. Here is the deal: WORKSHEET 1 Column1 = email address Column2 = ***This column I want the sum of events on new years but having problems

$$Excel-Macros$$ Counting Unique Items

2010-10-11 Thread MikeMikeMike
. Many email addresses can be attributed to many stores.) WORKSHEET 2 - The stores. Column1 = email address Column2 = store_name Any help is most appreciated. Thank you! MikeMikeMike -- -- Some important links