Filter Issue

[Ismael]

Hi to all in the forum,

I have a problem regarding a filter issue with 3 conditions.

On the file attach, you guys will see on column E that I have several times the same number repeated. This number is associated with other "events" on the other columns. I import this data from a txt file, and I only can load the entire file on office 2007, because the original file is to big...normally the file has 130,000 rows.

So my doubt is: There is a possibility of made a filter in order to "cache" only the numbers of column E that have simultaneous the "event" RECEPCAO DE BSM on column D and the "event" SEM BSM on column K.

On the file attach I have put 2 sheets, one is "what I have", the other is "what I pretend", I made this in order to you guys can understand better my doubt.

Thanks in advance.

Best regards,
Ismael

[unmarkedhelicopter]

There are routines in excel that allow you to import more than 65536 (apart from using 2007) use one of those and then do your filtering by deleting unecessary rows from however many sheets you end up with then adding the results (assuming that will be less than 65535 ;) )