Filter issues

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
180
Hi,

My filter does not work properly. It just displays a minor portion of all values in the column. I have no blank rows in the table array.

How do I solve this?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
180
Bumping this thread, any suggestions? Have not managed to make it work yet.
 

ClaireS

Board Regular
Joined
Jul 29, 2013
Messages
137
I suggest you read the Guidelines here which offer advice on the sort of information you need to give in order to explain your problem clearly.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,926
Office Version
2007
Platform
Windows
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
180
I managed to solve it! I had some hidden columns. Though I am facing a new similar issue in another file which I can not seem to solve. See screenshot:
https://imgur.com/t6KR8tw

All cells in the table range have values. No hidden or empty columns or row. I filtered a number of projects from the table, then sorted them in ascending order. Not sure if all but a lot of numbers then appeared in in the wrong row and context. The most f*cked up thing about this f*cking issue is the whole table and data gets messed up and I can not restore it unless I do ctrl+z, which does not work when I have worked for a while until noticing things are incorrect. Really disturbing, so I need to re-do the whole thing. Please help! :banghead::devilish:
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,926
Office Version
2007
Platform
Windows
I managed to solve it! I had some hidden columns. Though I am facing a new similar issue in another file which I can not seem to solve. See screenshot:
https://imgur.com/t6KR8tw

All cells in the table range have values. No hidden or empty columns or row. I filtered a number of projects from the table, then sorted them in ascending order. Not sure if all but a lot of numbers then appeared in in the wrong row and context. The most f*cked up thing about this f*cking issue is the whole table and data gets messed up and I can not restore it unless I do ctrl+z, which does not work when I have worked for a while until noticing things are incorrect. Really disturbing, so I need to re-do the whole thing. Please help! :banghead::devilish:

If you first filter and then order, then the rows are rearranged.
The suggestions that you first order and then perform the filter.
 

Cameltoe

Board Regular
Joined
Jun 5, 2018
Messages
180
Thank you man for response! At least are there any ways to sort data correct without ctrl+z if you by mistake filter first and then order?
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,926
Office Version
2007
Platform
Windows
Thank you man for response! At least are there any ways to sort data correct without ctrl+z if you by mistake filter first and then order?
As you well know, machines do what you do. They do not know if your procedure was correct or wrong.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,060
Messages
5,472,213
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top