exceptions

Hey, i have a question for a university project: There is a sheet and i want to figure out all possible combinations if you can only pick one "Option" of A, B and C. Thats quite easy and the result will be: a1,b1,c1;a1,b1,c2;a1,b1,c2... <tbody> A B C 1 from the top open bottom 2...

Hello, How can I return records from table-1 that do not match with records in table-2? I have a master table (say Table-1) that contains all the data. Another table (Table-2) contains records that I do not want to see in the resulting table. I need to do following: (Table-1) - (Table-2) =...

Dear Sir or Madam: My name is Robert, and I have just one more Excel formula issue before I fall asleep. The following formula works perfectly, but I want to add exceptions to it. I need Excel to find a cell that contains "minimum", "maximum", and range" with any other words except the...

Good morning. I hope some one can help me a piece of VBA that I just can not wrap my head around: I have a workbook with a number of different sheets where a macro can save each of these sheets to a CVS naming the files using the sheet names + a specific word and the current date and time...

Sorry if this is similar to previous posts. I can't quite find one that solves my problem. I am attempting to compile multiple daily data tables into a database containing several years of information. I want to skip my personal macro workbook, as well as the sheet I am pasting into. This code...

Hi, I'd like to create a string of 6 random consonants (e.g., "kftryp") but with 2 caveats: 1. no letter repeats (e.g., you can't have "kftryk") 2. the string does not contain a consonant that is used in another specified cell (e.g., if the specified cell - A1 - contains "tiger" then "kftryp"...

I am hoping someone can help me solve a puzzle here. I have a workbook with a number of tabs for which I have created macro to save each of these as it's own VBA file. When the files are saved the macro is designed to use the name of the tab combined with a predefined value and a date and time...

Hi, I have a fact table - say with 1) description of fruit and 2) with quantity ordered. I would like to take another table of exceptions (ie names of fruits that need to be flagged on fact table). So if "Apples" is a record in the Exceptions table and is also a record in the Fact table, flag...

Hi, I have a question in regards to automatic lists in Excel and will try my best to explain it clearly. Any help is appreciated. :) Very simplified, I have 3 tabs. #1 has raw data, #2 has a list of "cost centers" and #3 is a tab in which I would like to have an automatic list of all rows with...

Hi guys, I have no idea if this is possible but I hope so. We have a document here at work where we log all our transactions and in the summary field we have lots of formulas based on customers which is all row based. Issue is that we have certain codes that we do not want to include in the...

Thanks in advance for any help. I've been searching the forum for a few days to try and piece together a VBA to pull out invoices that are more than 30 days old, and of the 100s of clients, there are 4 exceptions. I know this is more simple with a pivot table, but the end users on this have...

Working with Excel's proper case function and artist's names can be such a pain. :mad: But I do have an accurate list of the way these artists names should appear. For example: the artist EPMD should be all caps not Epmd. I found this similar thread, but it isn't working properly because...