Ismael
11-29-2007, 03:31 AM
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
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