Filtering all data

[carloszoom3000]

Hi,

I have a table with more than 1500 records.
When filtering the data it shows data that should not be included in the selection.

I went to data+fitering+advanced and made the selection $B$10:$AD$1658.
Being those the beginning and the end of the table respectively.

What am I missing?.

Thanks in advance.

 

[carloszoom3000]

Re: Not Filtering all data

Hi,

I have a table with more than 1500 records.
When filtering the data it shows data that should not be included in the selection.

I went to data+fitering+advanced and made the selection $B$10:$AD$1658.
Being those the beginning and the end of the table respectively.

What am I missing?.

Thanks in advance.

I was able to find the root of the problem.
I first created the table and then started to paste the information from another table.
So that information was not part of the table but just some information within a frame.
As i copied the table and pasted it with no format into another sheet, it allowed me to do the filtering as I just wanted it.

I hope this helps someone else .

Regards,