0
votes
1answer
36 views

Excel filtering multiple columns with common header and common criteria

I have made a Book Archive in Excel 2013 that has the data sorted like this. Book's Owner ¦ Book Cover ¦ Book Name ¦ Author ¦ Edition ¦ Language ¦ Topic ¦ Index Since those are ...
0
votes
3answers
50 views

Excel filter duplicate values in column A and filter out rows which have column C blank

Total n00b here. How to filter duplicate values in column A and filter out rows which have column C blank. I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next ...
0
votes
1answer
38 views

Why doesn't collapsing duplicate rows work for me?

I'm trying to filter out duplicate rows in my excel sheet By selecting column B and checking unique records only I expect this to collapse to a single row, but this isnt happening. What am i doing ...
0
votes
1answer
21 views

Count the number of times a value/string is in a column when other columns are filtered

I am trying to count the number of times a value/string is in a column when other columns are filtered. Example: I want to be able to filter any column, A through V, and then count how many times a ...
0
votes
1answer
102 views

How to delete entire row when A1:A100000 columns are duplicated

I have to filter quite big data (102858 rows, 9 columns). The idea is that between these rows (URL addresses) are a lot of duplicates. A1:A102000 contains URL addresses with and without comments. For ...
0
votes
1answer
127 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
0
votes
1answer
38 views

How to create drop down column OR filters

I have a worksheet (in Excel 2003) that has a number of cross-reference cells, for example: 1 Red|Green|Blue|Yellow|Any|Information 2 X | | | | |.... 3 X | | | | X ...
0
votes
0answers
35 views

Excel Auto-filter Modifying Filtered Rows

When doing auto-filter, how to I ensure that changes will only affect the filtered rows? It seems to be a hit-miss thing. Ideally, when auto-filter is on and you do a Select All, all changes should ...
0
votes
1answer
205 views

Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries. I do not want to simply remove ...
0
votes
0answers
103 views

Excel Combo box to filter a table column

I have a table that I want to filter a column of 'team names' (D10 is the column header) using a combo box (which has a list of the 10 team names from another sheet). So, when I select a different ...
0
votes
2answers
82 views

How can I filter data based on items in a list?

How can I filter entries containing any specific word in a list of words? For example, I have a list of road names in Singapore. Amoy Street, Singapore Ann Siang Hill Anson Road Arab Street Armenian ...
0
votes
1answer
41 views

How to filter an array of words in Microsoft Excel? [duplicate]

How do I filter an array of words in Microsoft Excel? For example, I have a big list of road names in Singapore and I wish to filter all entries in the Excel containing any road name in the list. How ...
0
votes
2answers
89 views

Microsoft Excel Filter function

Hi I need help with the Excel filter function. I need to filter entries containing short forms of words (for example "Rd" for "Road"), however the filter function for containing "Rd" would return me ...
0
votes
0answers
30 views

Filtering dates from different sheets

I have an excel workbook which consists of around 200 separate worksheets. Column A on each sheet is a date column. I need some vba which will give the names of all sheets that have a stipulated date ...
1
vote
1answer
237 views

How to filter rows which are blank rows from a specific column onward?

I have a file with thousands of rows and need to filter it. How can I filter rows for which all columns are blank after column X? The situation is as follows: I am working with a database of ...
4
votes
2answers
723 views

How to filter cells based on font color?

Someone sent me an Excel 2010 spreadsheet with more than 50,000 records with the request to review the "highlighted in red" records. My current method of scrolling with the assumption I have a keen ...
0
votes
1answer
363 views

filter through one excel spreadsheet using data from another

I have 2 excel files. One holds some products that i need to put into a database but it doesnt have all of the information i need. The second file has all the information for these products but there ...
3
votes
1answer
461 views

Filter comma-delimited Excel column

I have an Excel sheet serving as a master spell list for a tabletop game. Each row (save for row 1) contains the data for a spell: Name, Target, Range, Duration, Function, Effect, Subject, Level, and ...
1
vote
0answers
78 views

excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields: USER_ID | DATE_CREATED | TAGS Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field. I ...
0
votes
1answer
9k views

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...
1
vote
1answer
2k views

How to apply a 'comma separated list' as a filter in Excel?

I have a stock-list of books and would like to filter the stock data only with selected publishers. Is there a way I can provide a 'comma separated list' in the filter? I tried the 'Advanced ...
1
vote
2answers
151 views

Working with “~” in excel

I have a data set that has names that contain ~ within them. Unfortunately, I cannot find a way to filter or incorporate these cells in a formula. For example, I tried to use a text cell that had ~ ...
0
votes
1answer
157 views

Pivot table on filtered data

There doesn't be a way in Excel to run a pivot table on an Excel sheet that already has columns filtered. Thus far, I've had to manually copy and paste the sheet into another sheet and then run a ...
0
votes
2answers
785 views

Excel use columns in one table to make another table

I have an csv data dump which is a flattening of related tables from a sql database. So to simplify it looks like this. | col1 | col2 | col3 | col4 | +------+------+------+------+ | A | Ad | B ...
0
votes
1answer
126 views

How to get rid of text overlapping with the arrow buttons when filtered in Excel?

When filtering, my header columns are overlapped by the arrow buttons as in the below snapshot. How can I get rid of this?
0
votes
1answer
145 views

Using the advanced filter in Excel

I have 40 rows in Excel starting with a SerialID in sheet 1. In sheet 2 i have 109 rows which I would like to filter based on sheet 1. Sheet 1 contains records i want to hide from sheet 2.
1
vote
2answers
159 views

Is there an easy way to have no choices selected in filter?

In Excel 2010 when I turn on the filter and click on the down arrow "Select All", and therefore all choices, is selected. Turning off all choices is as easy as unchecking "Select All". However ...
0
votes
1answer
3k views

Excel Formula for filtering data from one sheet to another

I have table that have the following columns (Agent Name, Client, Policy #, Premium) with the name of agents repeating several times since they have multiple clients... I don't want to give all the ...
1
vote
2answers
1k views

How can I filter specific rows from an Excel spreadsheet based on criteria?

I have a spreadsheet from which I need to select ONLY the first five rows in each category. Probably easier to see than describe.... I only want columns A and B when C is less than 5 -- ...
2
votes
2answers
787 views

How can I filter for unique values using the most recent Date in a specific column?

I have 10K rows of data, some with multiple rows per employee, I need to filter by unique values by using the employee ID# in 1st column, but filter using the most recent date in another column. I am ...
0
votes
1answer
659 views

Single source worksheet, and multiple pivot tables using filtered data

How does one manage to create a workbook, where one worksheet is the master source data, but multiple pivot tables need to be created with the same set of "row labels" and "summed values", but ...
0
votes
1answer
356 views

Sort Excel Pivot Table By Month

I am trying to sort data in a pivot table. I am hoping to end up with a table that has row labels with my data types, and then 12 monthly columns with a count of each type in each column. So far I ...
2
votes
2answers
359 views

Auto Updating an Excel Filter

Firstly I'm using excel 2010. I have had a look at other "auto-update" and from what I saw they wanted you to type some information in to make it "refresh" the auto-update. Essentially what I have ...
2
votes
1answer
698 views

Copy/Paste including Hidden Columns when Filtering Rows in Excel 2010

I suspect the solution will be related to this question?? I have a spreadsheet that comes to me pre-formatted with hidden columns sprinkled in multiple places (for viewing brevity's sake). I need to ...
3
votes
3answers
2k views

How to exempt rows from being hidden/filtered in Excel 2010?

Consider a spreadsheet that starts looking like this: I want to be able to filter for Name 1 on the left column and have it look like this: Yes, I realize that the simple answer is to filter for ...
2
votes
2answers
1k views

how to filter each 4 rows in Excel?

Actually I have an Excel file(xlsx - MS Office 2010) file that it has a column (Just A) and 3000 rows, I want to filter it each 4 rows, for example at first I want Row 4 after that row 8 after that ...
3
votes
5answers
2k views

Excel formula - querying a Range that results a Range

I have a Range in Excel (B3:C8) from which I want to filter out the English persons. In SQL this would be dead simple: SELECT Persons FROM [myTable] WHERE Nationality = 'English' How can I apply a ...
4
votes
3answers
11k views

Excel 2007: Filtering out rows in a table based on a list

I have a large table that looks like this: ID String 1 abcde 2 defgh 3 defgh 4 defgh 5 ijkl 6 ijkl 7 mnop 8 qrst I want to selectivley hide rows ...
0
votes
1answer
1k views

Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011. I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way. Questions: ...
0
votes
1answer
411 views

Excel filter by range

I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone ...
2
votes
1answer
738 views

How to filter out data between two columns?

I have data in my excel sheet in the below format A B 1 2 2 3 3 5 4 8 5 6 7 8 9 i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in ...
1
vote
1answer
5k views

How can I make filtering rows on an Excel spreadsheet easy?

I have an Excel 2010 spreadsheet that looks like this: Department Location Staff Accounting SF 10 IT NYC 20 Finance NYC 15 Design ...
1
vote
2answers
4k views

how to filter Excel data, by text length?

In Excel 2007, I want to filter rows by one of my columns text length, eg. hide the rows with text lengths less or greater than 12 characters. what should I do?
1
vote
3answers
6k views

Does Excel have a row filtering function (more general version of SUMIF/COUNTIF)

SUMIF and COUNTIF functions are handy for simple SUM and COUNT operations on only some of the values in a range, but is there a more general version that would allow me to plug in any other function I ...
1
vote
1answer
695 views

Have Excel's Correlation Function Respect Filtering

I've got a cell that's using the CORREL function to return the correlation of two rows of data in my spreadsheet. The issue is that I'd like this to update based on the filter that I have applied. ...