# Tagged Questions

**0**

votes

**1**answer

127 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

**0**answers

47 views

### Filter excel pivot table using date range

I am exporting an MS Project file into an Excel spreadsheet. I would like to be able to pivot my tasks by assignee, by task etc.
I would like to be able to filter the tasks such that if the start ...

**1**

vote

**0**answers

209 views

### Pivot Tables - Filter Behavior, Limiting Filter Drop Downs Based on Previous Filters

I am working in excel 2010, and I have a question about pivot table filter capabilities / limitations. I tend to use complex, extensive pivot tables for data analysis/data accuracy on huge datasets, ...

**0**

votes

**1**answer

62 views

### How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow.
After copy-pasting from pivot table and using filter to remove the blank flow ...

**0**

votes

**1**answer

201 views

### Excel tables: Tag collumn in table

I am really not a power user of Excel, so I hope my question would make sense.
I need to use Excel as a "database programme" (even though I know there are other sollutions actually built for that). ...

**4**

votes

**2**answers

556 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 ...

**3**

votes

**1**answer

389 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

**0**answers

70 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

**1**answer

7k 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 ...

**0**

votes

**1**answer

141 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

**2**answers

595 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

**1**answer

134 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

**2**answers

1k views

### Excel 2010 Autofilter does not filter

I have been struggling with this for several days now and I would appreciate any help you may be able to provide. I have a sheet with 69 columns and 6600 rows called Raw Data. I also have a sheet ...

**1**

vote

**1**answer

309 views

### Can I filter multiple column headers to display subheadings of each in Excel?

I can't seem to find this anywhere... it may not even be possible without coding?
I have a spreadsheet containing more than one heading in a single column. These headings are identified with blue ...

**2**

votes

**2**answers

321 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 ...

**3**

votes

**3**answers

1k 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 ...

**1**

vote

**1**answer

1k views

### Excel 2010 filter arrow not showing text values

I have an odd problem on a tracker spreadsheet i use. All the columns have a filter, but when you click on the filter arrow it doesnt show you a breakdown of all the text values for that column. All ...

**0**

votes

**1**answer

410 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 ...

**1**

vote

**1**answer

4k 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

**1**answer

669 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.
...