removal

From a list of 6 digit number sets, is there a way to remove all sets that have a 4 or more digit consecutive sequence in it?

whats the best way to remove duplicate data in each column specifying a starting and ending column beginning sheet remove duplicates starting in row1 column J-P J K L M N O P 1 cat dog mouse cat 2 bat car ball switch car...

I have filters on 100+ columns on many of my worksheets and I frequently forget to remove the filter when moving to another sheet. Then, when I return to that sheet, I can easily not realise that a filter is already in place, leading to all sorts of problems. I've been trying to automate...

Hi, I am using the following formula in my worksheet: =IFERROR(INDEX($H$74:$H$783,MATCH(0,COUNTIF($H$74:$H$783,"<"&$H$74:$H$783)-SUM(COUNTIF($H$74:$H$783,F$797:F797)),0)),"") I am getting the intended list that i want with duplicates removed. But the List is appearing in alphabetical order...

So I have a large amount of text that is laid out into the following format: DATE & TIME | TRANSACTION |BOX|KEY#|KEY NAME | BY USER 9/1/2017 04:04|Key Removal 1 0001 Coordinator Key (NAME) 9/1/2017 07:11|Key Removal 1...

Hi all, I have a table (tab= "(HIDDEN) Source Data") containing data in range C3:W2000 (though sometimes there are less than 2000 rows containing data - it varies). Columns L, N and O contain dates and timestamps. The data in the table is used in a couple of different pivot tables in the same...

Hi, I have a large amount of data that contains an inspection status of various types e.g D/1,D/2, D/3, RTN, TPR, there is also a cell which contains an inspection result of pass/fail. Each line of data refers to an item held in a database with a reference number. This data can have multiple...