advanced

Every time I open a new workbook, the default setting for borders is set to white instead of grey. I have to go into advanced settings every time and change it to grey to be able to see the cells. I have tried to uninstall and re-install several times with no luck. I have even contacted MS...

Let's say I have in sheet 1 cell A1: The best scenes from Jursassic Park In sheet 2 I have a list like in the picture: A1: Jursassic Park A2: The Bourne Identity I want a formula where if a part of the value in A1 is found in that list, return only that title. See pictures for example

Hello everyone, Attached pictures below for you to see the task as well. At sheet 1 I have column C filled with multiple tags like "Showname,Jimmy O. Yang,comedy". At sheet 2 I have column A with multiple names. I want to see if the tag at column C contains text that is found at my second sheet...

Hello everyone, Attached pictures below for you to see the taskas well At sheet 1 I have column C filled with multiple tags like "Showname,Jimmy O. Yang,comedy". At sheet 2 I have column A with multiple names. I want to see if the tag at column C contains text that is found at my second sheet...

I have a question about sorting a list and removing blank cells vertically. what I have is a basic spreadsheet, it is built into my software so it does most all of excel's formulas, however, I am unaware that it support VBA code nor does it allow sorting and removing blanks like using Data tab...

Hello, I am trying to make a formula that goes from row to row and left to right to check if the cell is equal to 1. If the cell is equal to 1, then I want to print the number that's below the cell. I added a picture to illustrate what I mean. Appreaciate any help I can get. I have been...

I am experiencing problems with a formula in a workbook we use in my workplace. It was written by a former employee who has recently left but taken the knowledge with him. The data in cell 'BJ5' Should be the same as in 'BJ6'. BJ6 being the correct value. I have attached a copy of the...

I'm looking for formulae that will compare Sheet1 and Sheet2, searching Sheet2 for cells that don't match columns C-E for the associated ID and Date (columns A & B) in Sheet1. Further, I'd like to highlight in Sheet1 whatever cells in columns C-E that don't have matches in that can be found in...

Hi, everybody In a couple of weeks I will run an online tournament. In this tournament there will be between 11-60 players. Every player will play 5 matches (1 match every round). A match consist of 1 game between 5-10 participants. I want to find the perfect matches, which is rougly defined as...

Hello, I am fairly new to vba and i am having a hard time coding something that will solve my issue :( I have two data sources I wish to combine. Sheet 1 Data source on Sheet1 contains 2 columns: AccountID and Cost. Source is in cells A3:B3 (data row starts in A4) for 1 to N records. A...

Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and: 1.) Sorted the Extract 2.) Made some changes to the Extract Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes Other...

Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...

Fluff very kindly posted the following code to enable the automation of advanced filtering from one worksheet to another in the same workbook for variable criteria without having to reinput the criteria each time. But how would this be done from another workbook? The data is in a workbook...

Apologies - not a VBA Ninja! I have found the code below to perform an advanced filter in place so that a user can enter the filter criteria and the data will update automatically, but could someone please amend this to filter to another location? The target location is a worksheet called...

Hi all Im using the index match feature with multiple criteria to get a returned value, but its slowed the sheet to a crawl. Any other ideas to return the text value? Im not great at VB I should mention its a shared document and I think arrays have issues with it being shared...

I have set up an advanced filter but it won't update automatically, but then again maybe it's not supposed to! I have a data entry worksheet to which random part numbers are added against known fault codes. All this is numeric. Fault codes are in column A, part numbers in column B. I have...

Hello, I have a workbook with several worksheets and several advanced filters that was working very well, but with unknown reason the advanced filters stop working Below is a link for a test sheet from my workbook that shows how I did the advanced filter Can someone please check it and let me...

Hi all, quite an involved one here so please bear with me. Working at a company trying to rectify their orders. They have a weekly report that they are seeking a comparator on, to see the changes. Because so many of their orders are very similar, I have taken their data and had to create a...

Hello, I'm using advanced filter in a sheet using a list of clientsIDs grabbed from the same sheet. The code works, but a problem arises when I have 2 clientsIDs that start with the same numbers. For example, if one of the clients in my list is 102, my filter also includes 1021. Is there a...

I use this on a number of large files (in 2003 compatibility mode because it is much faster) and when I click Data - Advanced it always comes up with the "Filter the list in place" and every time I must click "Copy to another location" before OK. Is there any way to make Copy to another...