0
votes
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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. ...