1. R

    Create all the combinations with some 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...
  2. 2

    Exceptions table

    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) =...
  3. R

    I am trying to add exceptions to a formula

    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...
  4. K

    VBA Saving tabs as CVS files based on sheet names and date

    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...
  5. A

    Looping through Workbooks with multiple named exceptions

    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...
  6. R

    Create a string of 6 random constonants - and ensure that none of these values are in a specified cell

    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"...
  7. K

    Save tabs as individual files with exceptions

    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...
  8. M

    New to Power BI - compare "Exceptions" table to Fact Table - Identify any Matches

    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...
  9. M

    Automatically Generate A List Based on Certain Conditions - HELP

    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...
  10. K

    Formula to add unique values from range EXCEPT values in another range

    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...
  11. M

    VBA code needed to automate past due with 4 exceptions

    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...
  12. R

    Proper Case with a Range of Exceptions

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back