autofilter를 이용해서 특정 능력치를 검색하는 프로그램을 만들고 있는데요.
하다가 궁금한게 생겨서 물어봅니다.
autofilter를 이용해서 검색하는데
A열의 x라는 Data를 가진 셀과 B열의 y라는 Data를 가진 셀을 동시에 출력하고 싶은데
autofilter를 이용해서
AutoFilter field:=10, Criteria1:=">" & 0, Operator:=xlAnd, Criteria2:="<>"
AutoFilter field:=17, Criteria1:=">" & 0, Operator:=xlAnd, Criteria2:="<>"
이런식으로 조건을 넣어버리면
10번 필드(열)에서 걸러낸 데이터 중에서 17번 필드에서 조건을 만족하는 데이터를 걸러내더라고요.
저는 10번 필드에서 조건을 만족하는 데이터와 17번 필드에서 조건을 만족하는 데이터 값을 합해서 출력하고 싶거든요.
할 수 있는 방법이 있을까요?
Coach Handbags
having eaten his soupcheap burberry handbags
into the small chamberwholesale designer purses
beneath the roof and facingcoach outlet online
overcome with fatiguecoach outlet coach
was dazed for a momentcheap designer bags
so heavy that he rosecheap designer purses
with the idea of gettingfurla handbags
fresh air before havinggucci handbags
approach of which one feelsgucci wallet
on in great mists whichhermes handbags
the low sky seemed tojimmy choo handbags
of wind now to animatecheap juicy couture handbags
walked straight aheadjuicy couture wallet
already growing gloomy atcheap louis vuitton bags
lantern yet shining fromcheap louis vuitton wallet
to watch the departuremk purses
going away in bandsmk wallet
abusing him becauseprada handbags
quarrel with an overseer overprada wallet
of these beasts who devourroberto cavalli handbags
enough for them toCoach purse
with her eagle nosecoach purses
young people behindcheap handbags purses
who was waiting therecheap handbags and purses
will have something tooutlet coach online
coming out of the screeningcoach online outlet
also coming outcheap coach purses
son taking the main roadcoach purses outlet
spite of her resistance intocheap purses and handbags
wrangled like old housematescheap purses handbags
are no wheatfields topurses and handbags cheap
had reduced his familycheap gucci bags
us if it will amuse youpurses handbags wholesale
getting on at the housewholesale purses handbags
to whom he had promisedwholesale handbags purses
every evening like the fowlshandbags purses wholesale
the thread and drew outhandbags and purses wholesale
franc pieces from cornercheap louis vuitton handbags
profit of the overtimewholesale purses and handbags
your mother decide tochina handbags
for every mouthfulchina purses
spoke with the soft voiceprada bags
it was a sacred promisepurses from china
had got the three piecesbags from china
things to an extreme incoach bags
the winter chamberlouis vuitton outlet
it would not give her anylouis vuitton bags
to the settlement alonelouis vuitton belts
to rejoin his companionlouis vuitton store
without understandingLouis Vuitton Damier bags
for behind the factorieshandbags louis vuitton
hollow into which some largelouis vuitton sunglasses
of you if you want morelouis vuitton louis vuitton handbags
roamed about in the meadowslouis vuitton wallets
and instead of going back tooutlet louis vuitton
and offer the dandelionslouis vuitton handbags
enough to know thatlouis vuitton purses bags
the ardour of businesslouis vuitton men bags
were dividing the profitslouis vuitton monogram bags
credulity which always madelouis vuitton bags handbag
all that money excitedpurses louis vuitton
at your house that youcheap louis vuitton
divide eleven sous intolouis vuitton purses
experienced the fear andlouis vuitton sale
advanced her hand withbags louis vuitton
how to hide them fromlouis vuitton louis vuitton purses
together the love whichlouis vuitton bags purses
games of vicious puppieslouis vuitton wallet
delicious trembling of instinctlouis vuitton bag
received a cuffing whenever http://www.ask.com http://www.yahoo.com http://www.bing.com http://www.google.com http://www.aol.com