Is it possible to use "Advanced Filter" to compare two columns in the data range and keep if the values are the same? Trying to use Advanced Filter and avoid creating another column of data with which to do my comparison.
For example, I want to compare columns M and S and keep the rows where...
Hello,
i am wondering how to filter words in a data set. e.g men, male without it being part of other words (lament, female etc).
Is there a way of using advanced filter for this rather than a formula?
Thankyou
So it seems I am having trouble setting up the criteria I would use to filter out rows where Column H is blank and Column G is 0. Both these conditions need to be met for that row so it can be filtered out. Can anyone share how they would create the criteria?
Hi Everyone,
I've got a couple of issues with a search function I'm building.
The first is that sometimes the filter won't return all available results. This is something that I've only come across as I've been trying to figure this issue out and made a new sheet with a smaller data set to try...
Hello,
I am currently working on a spreadsheet with many data, including a dropdown list with multiple selection (I used a VBA code to activate it). Now, on another sheet, I need to extract data from the initial one by using the dropdown list as a criteria, but the advance filter is not...
I put together an advanced filter to only show rows that match my selection from a drop-down menu. I used function =IF(E6=“”,”*”,E6) and recorded a macro to extract data from one sheet and display in my filtered table on another sheet. It works well, but I’ve run into a wall.
I have some cells...
Hi Everyone,
I'm stuck and need a little guidance. I'm attempting to copy unique values within a column of one worksheet and paste them within another worksheet (same workbook) retaining the destination sheet's formatting. Below is the VBA that pastes over the formatting.
Sub...
Hi Everyone,
If I wanted to filter data that was in Column AH by data provided from Column AC how would I do that?
Let's say Column AH has 50 values while Column AC here has 10.
I want to filter using Column AC first value (YOG6LOHSP) to show all of the same values in Column AH(YOG6LOHSP)...
I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'.
What I'd like to achieve is a button that...
Hi Friends, I request your help here for a code to search for a column using column name and filter data using wildcards. ABC, PQR, and XYZ are part of the same team but no other column to identify teams and therefore they need to be searched at once from the given data.
Below code was...
Hello,
i cant find what Iam doing wrong, I have quiet complex table (9199 rows actually and colums from A to FE)
I wish to use just 2 columns for filtering, but i need to get few combinations of data extracted.
1st column iam using for criteria should search for like values Data1 - Data6 and...
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...
How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...
Good afternoon!
So I am trying to sat up an automatic report for my job where I can use advance filters to type the selected months into the criteria page and have it filter per those months. The macro however uses both Advanced and Normal filters and when I transition between, the entire table...
I have an Advanced Filter set up in my spreadsheet, and rather than showing all of the filtered results at once, I have it set up so it cycles through them one by one. But I have noticed that the first time I click the button that executes the script, it returns the header value first and then...
Hi
I'm a first time poster so apologies in advance if any of the below is not allowed or does not make sense etc. I'm more than happy to amend it/clarify anything.
I have a userform which allows me to view values in worksheet1 using a listbox. I have several textboxes on the userform which...
Morning all.
I have a column on sheet 1 with different numbers in it (150, 300, 600, 900, 1500, 2500) ad would like to filter it based on the number given on sheet 2, cell B5 (I have the criteria listed on sheet 2 as well). I've tried manually writing the advanced filter macro, and when that...
Hello!
I can't seem to be able to find any help in regard to this, nor can I find any excel add-ons that can do this seemingly easy task. I have a huge list of URL's on my spreadsheet, and I need to remove certain domains such as social media sites and various others. I can do this manually...
I have some code that currently looks for two criteria.
<colgroup><col><col></colgroup><tbody>
Date Requested
Approved?
2/24/2019
Approved
</tbody>
I would like to add pending as a criteria under approved too. so that if the column has approved or pending it will show up. bellow is what i...
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.