Tagged Questions

0
votes
1answer
41 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
72 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
84 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
106 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
318 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
553 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
314 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
2k 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
454 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. ...