advaced filters

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

Hi, I have a data set of account numbers and product lines, e.g: Account Product 100 1 100 1 100 2 200 2 200 3 200 3 Is it possible to set a filter to show only uniques. What I...

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, My range goes from col A to col N, col A is the criteria for making unique it if filed with serial# The "Sub CopyToNewMakeUnique()" filter copies but does not make unique, this is the first time I have tried this so maybe I do not understand what the unique is actually doing or I am...

Hello Everyone, I have data in two sheets that need to be sorted. I need to create a list of records that are on the first list but NOT on the 2nd list. I was wondering how I could sort these records out using the name columns (2) and filter into a new sheet. Thank you!

Hello, I have a very interesting challenge. I have a dropdown list (C4) in sheet1 from where i select different values. based on this value i would need to make an advanced filtered of an database from sheet2 and the result of the advanced filter to be displayed in sheet1 . is it possible...