-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel filter
-
C
How to group filtered data
Hi! I'm looking for some help in grouping sets of data for when a filter is applied. Example below: Says below is the original set of data - I would like to be able to filter by tests that have "failed". Is it possible to keep all of Test number 2 & 4 showing when I filter for "fail"...- Clayton18
- Thread
- excel excel filter filter filter advance filter advance criteria
- Replies: 7
- Forum: Excel Questions
-
M
Help with excel filter formula
Dear members, having below query with excel filter function. Given below is data set, formula 1 and formula 2. Having query with formula 2 given below. I am not getting why result of formula 2 is including item with units sold =4 when my condition for filter is unit sold is >5. (formula 2...- manekankit
- Thread
- excel filter excel filter formula office 365
- Replies: 10
- Forum: Excel Questions
-
S
Excel Filters Greyed out after selecting a certain row/column?
Hi there, I have come across a new problem which I've not had seen before in Excel 365 version. 1. After a certain ROW and COLUMN my filters are not working - I have cleared the filters, checked blanks, etc but when I select the entire data "Filter options" are greyed out as per image below...- SK_786
- Thread
- excel filter sort filter excel
- Replies: 2
- Forum: Excel Questions
-
A
Filtering data causing formatting issues
I have a project for uni that I have to do but these 2 problems are standing in my way. I have a picture of what the table should look like after it's been filtered Here you can see that I need to have 2 tables side-by-side. Left table is sorting data based on value from it's furthest right...- admirbabovic
- Thread
- excel excel filter excel filter formula excel filters filter filter advance
- Replies: 6
- Forum: Excel Questions
-
R
How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help
How to filter hunderds of lables in Excel Filters & from Pivot filters?. It is easy to filter one or two label values from filters / pivot filters, if i want to filter hunderds of labels in "Filters" or Pivot "Filters" in excel .. How to do that? It is very difficult to select many labels from...- ramkichn
- Thread
- excel excel filter filter filters pivot
- Replies: 1
- Forum: Excel Questions
-
B
Problem on filter with merging cell
Excel version: 2010 Currently having problem on showing all my data. The screenshot below shows my objective of filtering 'Completed'. However, there are action that are being cut and only shows the 1st row. My objective is to show all the data when being filter accordingly. 1: 2:- Blanko
- Thread
- excel excel 2010 excel filter excel filters help !
- Replies: 16
- Forum: Excel Questions
-
K
Not avoiding copy & paste in hidden / filtered cells
Hi, I have searched all over and read many solutions for selecting only visible cells and copy pasting them or formatting them by doing Ctrl + G and selecting visible cells only. However the problem is once I select visible cells only, it seems that every time I do Ctrl + C on filtered Range it...- kd360
- Thread
- excel filter reset excel toggle visible cells only
- Replies: 0
- Forum: Excel Questions
