ȸ
|
μ | ǻȰɷ | óɻ
| Ȱ | | Ʈ | ũ/VBA | ǹ
OA α׷ | | ڰ | Ÿ
α
йȣ
 ڵȭ
 ڵȭ
 ǹȰ
㼭
 ȸ 湮     802,728   
  ο     443   
  Ȩ > ڵȭ > ڵȭ     

(Hit: 46,256) Ȯ   μ  
ٿε
 ̿().xls
 ̿(ϼ).xls
ҵ漼 꼭 ؾ Ը 꼭 ϰ ŷ ϱ Դϴ. ⿡ ۼϴ "Է" Ʈ ŷó ۼ, ŷ Էϸ "" Ʈ 2 ڵ ۼǵ Դϴ. ٷ ִ ϼ ϰ ִ մϴ.

≮1>

≮2>


1) ŷ Էϰ ̸

* ̸

[Է] ũƮ [] ũƮ ϼϱ ʿ ⺻ Էϱ ̴. Ÿ ͸ Էϰ ߿ ͸ ̸ ϴ Ѵ.

[C4] ŷó, [C5] ۼڸ ԷѴ. [C5] ¥ ǥ ̸ Ǿ ִ.

   

[B8:B22] ŷ, [C8:C22] ǰ, [D8:D22] , [E8:E9] ܰ ԷѴ.

[F8:F22] ϰ =IF(OR(D8="",E8=""),"",D8*E8) Է [Ctrl+Enter] ݾ Ѵ.

     

OR Լ

OR(1,2,...)

ϳ ̻ ̸ OR Լ TRUE ȴ. OR Լ FALSE ȴ.

м

OR(D8="",E8="")

(D8) ְų ܰ(E8) TRUE ȯѴ. ܰ ԷµǾ FALSE ȯѴ.

=IF(OR,"",D8*E8)

OR Լ TRUE̸ () ǥϰ, OR Լ FALSE̸ , ܰ ԷµǾ (D8) ܰ(E8) ؼ ݾ Ѵ.

[F4] =SUM(F8:F22) Էؼ ݾ հ踦 Ѵ. [F5] ʿ Ƿ ԷѴ. ⼭ ƹ ͵ Է ʾҴ.

[B4:C5] ϰ [Ctrl] ¿ [E4:F5] Ѵ. ׷ [][̸][] ޴ Ѵ.

   

[̸ ] ȭڿ [ ] ׸ ϰ [Ȯ] ŬѴ. ̷ ϸ ؽƮ Ű ̸ ǵȴ.

   

[B7:F22] ϰ [][̸][] ޴ Ѵ.

[̸ ] ȭڿ [ù ] ׸ ϰ [Ȯ] ŬѴ. ̷ ϸ ̸ ù ࿡ ִ ؽƮ ǵȴ.

   

[̸ ] ȭǥ ߸ Ŭϸ [] ̸ Ȯ ִ. ̸ Ͽ ϳ Ŭϸ ش ̸ ϴ Ǵ õȴ.

   

2) ޹޴ڿ ϱ

* INDEX Լ

[Է] ũƮ Է [] ũƮ ޹޴ڿ INDEX Լ Ѵ. INDEX Լ ȣ ؼ Ư Ѵ.

[] ũƮ [E6] =ŷó ԷѴ. ׷ [ŷó] ̸ [Է] ũƮ [C4] Է ״ ǥõȴ.

   

Ϲȣ ȣ, ޹޴ڿ Էϴ Ѵ.

[B15] , [F15] =հݾ, [M15] = Էؼ ̸ ̸ ״ ǥѴ. ࿡ ش Ͱ ԷµǾ 0 ǥõȴ.

     

[B18:C32] ϰ =INDEX(,ROW(A1)) Է [Ctrl+Enter] .

      

ROW Լ

ROW()

ȣ Ѵ. ϸ ROW Լ Է ȣ Ѵ.

INDEX Լ

INDEX(,,)

־ , ȣ شǴ Ư Ѵ.

INDEX(,ȣ)

ϳ ̳ ϳ Ǿ ִ ־ ȣ شϴ Ѵ.

м

ROW(A1)

[A1] ȣ 1 Ѵ. [B18] ROW(A1) [B19] ROW(A2) ǹǷ ȣ 2 Ѵ.

=INDEX(,ROW(A1))

[] ROW Լ شϴ ġ Ѵ. [B18] ROW 1̹Ƿ [] 1° ִ , [B19] ROW 2̹Ƿ [] 2° ִ ´.

[B18:B32] ϰ [][] ޴ ؼ [ ] ȭڸ Ÿ. [ǥ ] ǿ [] [ ] ϰ, [] M Է [Ȯ] ŬѴ. ׷ ǥ ִ.

[C18:C32] Ͽ D Ѵ. ׷ ϸ ǥõȴ.

   

ǰ , ܰ, ޴밡 INDEX Լ ROW Լ ؼ ´. ԷѴ.   

ǰ 

[D18:D32]

=INDEX(ǰ,ROW(A1))

[H18:H32]

=INDEX(,ROW(A1))

ܰ

[J18:J32]

=INDEX(ܰ,ROW(A1))

޴밡

[M18:M32]

=INDEX(ݾ,ROW(A1))

   

[H33] =հݾ Էؼ [հݾ] ״ ǥѴ.

     


3) ڿ ϱ

* Ͽ ٿֱ

ڿ ޹޴ڿ ؾ Ѵ. =ּҡ ̿ϸ ޹޴ڿ ִ ڿ ״ ǥ ִ.

[V6] =E6 Էؼ ޹޴ڿ뿡 ִ ŷó ״ ǥѴ.

̿ؼ ִ. ԷѴ.   

[W8]

=F8

[W10]

=F10

[AD10]

=M10

[W11]

=F11

[W13]

=F13

[AD13]

=M13

   

[B15:M15] ϰ [Ctrl+C] Ѵ.

   

[S15:AD15] ϰ [ٿֱ] ȭǥ [Ͽ ٿֱ] Ѵ. ׷ =B15, =F15, =M15 ԷµǾ ǥѴ.

   

   

, ǰ, ܰ, ޴밡 [Ͽ ٿֱ] Է ִ. [B18:M32] ϰ [Ctrl+C] Ѵ.

[S18] [ٿֱ] ȭǥ [Ͽ ٿֱ] Ѵ.

   

      

[Y33] =H33 Էؼ հ踦 ǥѴ.

   


4) Ǻ 0

* ̵ ɼ ϱ

INDEX Լ INDEX Լ 0 Ÿ. ̷ ǥõ 0 Ǻ ̿ ̴.

[][̵] ޴ ؼ [̵] ȭڸ Ÿ [ɼ] ŬѴ.

[̵ ɼ] ȭڿ [] ɼ ϰ [Ȯ] ŬѴ. ׷ ũƮ ִ ڵ ° ȴ.

   

[][Ǻ ] ޴ ؼ [Ǻ ] ȭڸ Ÿ.

   

[ ], [ ] ϰ 0 Է [] ŬѴ.

   

[ ] ȭ [۲] ǿ [] ϰ [Ȯ] ŬѴ.

[Ǻ ] ȭڿ ٽ [Ȯ] Ŭϸ 0 ۲ Ǿ ȭ鿡 ƹ ͵ ó ̰ ȴ.

   


Ʈ


d inbook
! ̷ ű. մϴ.
2008-03-30 4:18:17
d dpswpf8329
˰ڳ...

2008-08-21 8:45:10
d hj2589
.𸣰....~~
2012-04-24 3:11:16
d chanyuan
20180810 junda

chloe outlet


coach outlet


jordan shoes


nike air max 90


wizards jerseys


dolce and gabbana


fitflops sale clearance


yeezy boost 350


ugg outlet


nike shoes


jazz jerseys


prada handbags


nike cortez


chrome hearts sunglasses


ugg outlet


gentle monster sunglasses


coach outlet online


michael kors outlet


wellensteyn jackets


michael kors handbags


nike pegasus


canada goose jackets


fitflops shoes


moncler outlet


adidas outlet


canada goose outlet


michael kors outlet


michael kors outlet


world cup jerseys


nike tennis


supreme clothing


mbt shoes


chicago blackhawks jerseys


michael kors


grizzlies jerseys


soccer shoes


lakers jerseys


golden state warriors jerseys


louboutin pas cher


keen shoes


tory burch outlet


ray ban outlet


chrome hearts outlet


tory burch outlet


hornets jerseys


michael kors outlet


miu miu handbags


hawks jerseys


toms shoes


true religion uk


cheap jordans


nike factory outlet


christian louboutin outlet


cheap jordans


air more uptempo


coach outlet store online


polo ralph lauren


pandora charms


coach outlet


raptors jerseys



2018-08-10 11:16:41
d xiaojun

ray ban sunglasses


adidas jeremy scott


columbia outlet


maillot de foot


dansko shoes


timberland outlet online


nike socks

nike factory store


vans shoes


prada outlet


fingerlings monkey


coach factory outlet


air max 95


nike blazer


dolce and gabbana


juicy couture handbags


mk purse


nike mercurial


coach outlet online


light up shoes


rolex watches


ugg sale


lebron 15


cheap mlb jerseys


puma fenty


nike presto


polo outlet


stussy


sophia webster


adidas flip flops


uggs


nfl jerseys


camisetas de fútbol


supreme hoodie


nike air max


true religion


air jordan 4


jordan 11


ray ban sunglasses


cartier bracelet


michael kors purse


ray ban sunglasses outlet


pandora jewelry


oakley sunglasses cheap


coach outlet


nfl jerseys


nike air force 1


yeezy 500


nike epic react


cristiano ronaldo jersey


chenlina20180905
2018-09-05 4:27:22
d chanyuan
20180906xiaoke

canada goose outlet


light up shoes


coach factory outlet online


kate spade new york


mlb jerseys wholesale


fossil watches


jordan shoes


pandora charms


canada goose outlet store


jerseys wholesale


canada goose outlet store


kate spade


polo ralph lauren outlet


oakley sunglasses sale


colts jersey


canada goose


dsquared2 jeans


canada goose jackets


christian louboutin sale


ray ban outlet store


christian louboutin


michael kors outlet online


uggs canada


michael kors outlet clearance


ralph lauren


hermes online


cheap jordan shoes


calvin klein jeans


christian louboutin


coach outlet store online


canada goose outlet store


cheap air jordans


kate spade handbags


michael kors outlet online


michael kors outlet clearance


ugg boots


air jordan shoes


north face outlet


mbt shoes clearance


bulgari jewelry


ugg boots on sale 70% off


ray ban sunglasses outlet


kate spade handbags


kate spade purses


pandora jewelry


christian louboutin


coach outlet online coach factory outlet


swarovski crystal


jordan shoes


ugg boots



2018-09-06 2:48:15
d zzyytt

links of london outlet store


hermes belt


goyard bag


kobe 9


yeezy boost 350 v2


hogan outlet


yeezy


lebron soldier 11


coach outlet


jordan retro


adidas ultra boost


vapor max


tom ford sunglasses


retro jordans


westbrook shoes


curry 4


longchamp bags


yeezy 500


coach outlet online


cheap mlb jerseys


zzyytt
2018-09-25 11:13:50
d chanyuan
2018927 leilei3915

manolo blahnik


christian louboutin shoes


canada goose outlet


pandora outlet


oakley sunglasses wholesale


canada goose outlet store


polo outlet


michael kors outlet


coach outlet online


true religion jeans


michael kors outlet online


michael kors outlet clearance


valentino outlet


canada goose outlet


kate spade outlet online


pandora jewelry


ralph lauren polo shirts


christian louboutin shoes


moncler jackets


michael kors outlet


oakley sunglasses


canada goose outlet


ugg outlet


coach outlet online


coach outlet


north face jackets


coach outlet


pandora jewelry


coach outlet


kate spade sale


polo ralph lauren


nike outlet store


michael kors


michael kors outlet clearance


canada goose outlet store


ugg boots


pandora outlet


mbt outlet clearance


michael kors outlet clearance


kate spade bags


mcm outlet


michael kors outlet clearance


clarks outlet


coach factory outlet


canada goose jackets canada


moncler outlet


canada goose


coach outlet store online


ray ban sunglasse


polo ralph lauren outlet



2018-09-27 7:04:17
d chanyuan
2018927 leilei3915

michael kors outlet


nfl jerseys wholesale


canada goose jackets


cheap ray ban


coach outlet


pandora charms


michael kors outlet online


cheap nfl jerseys


canada goose outlet


gucci outlet


ugg boots clearance


kate spade outlet


coach factory outlet


michael kors handbags


kate spade outlet


coach outlet online


coach outlet


canada goose outlet store


moncler jackets


pandora


ugg boots clearance


true religion outlet


vibram fivefingers


moncler outlet online


giuseppe zanotti sneakers


ugg outlet online clearance


true religion jeans


ray ban sunglasses outlet


coach factory outlet


jordan shoes


kate spade outlet


kate spade outlet online


true religion jeans


michael kors outlet clearance


tory burch outlet


kate spade purses


ray ban sunglasses wholesale


ugg boots


michael kors outlet online


coach outlet


michael kors outlet


canada goose jackets


coach factory outlet


cheap nfl jerseys


birkenstock shoes


ralph lauren outlet


coach factory outlet


coach factory outlet


canada goose


ray ban sunglasses



2018-09-27 7:07:53
d chanyuan
20181004 xiaoou

uggs outlet


cheap nhl jerseys


ralph lauren femme


oakley sunglasses wholesale


cazal outlet


michael kors bags


toms outlet


ugg outlet


valentino shoes


christian louboutin shoes


links of london jewellery


kate spade


canada goose jackets


true religion outlet


michael kors outlet


nike shoes outlet


ed hardy outlet


mbt outlet


tods outlet online


kate spade sale


mulberry handbags


coach factory outlet


ray ban sunglasses outlet


manolo blahnik outlet


michael kors outlet online


cheap soccer jerseys


uggs outlet


canada goose coats


true religion outlet


nike shoes outlet


pandora outlet


nike blazer pas cher


yeezy boost 350


uggs outlet


suicoke sandals


colts jerseys


coach outlet


cheap nhl jerseys


salomon outlet


nike air max 90


tory burch handbags


ugg boots clearance


tory burch outlet online


michael kors outlet online


coach outlet


nhl jerseys


canada goose jackets outlet


san antonio spurs


coach canada


ralph lauren polo


michael kors outlet clearance


under armour outlet


true religion outlet


coach outlet


mulberry bags


canada goose outlet store


polo ralph lauren


birkenstock shoes


kobe 9 elite


canada goose outlet



2018-10-04 5:34:47
d chanyuan
2018.10.10chenlixiang

adidas


adidas outlet


moncler jackets


curry 4


nike air max


adidas superstar


kevin durant shoes


rolex watches


curry 2


adidas flip-flops


chrome hearts jewelry


air max


roshe run


yeezy shoes


arcteryx jackets


jordan retro


new balance


pandora jewelry


nike air max


air max 95


kate spade outlet


louboutin


carson wentz jersey


ray ban sunglasses


hollister outlet


pandora


adidas outlet store


instyler ionic styler


rolex


ralph lauren


wedding dresses


jordan 8


nike air max


designer sunglasses


cheap nfl jerseys


jordan 9


kenzo clothing


bose headphones


lululemon outlet


moncler outlet


kobe 9


ugg boots


new balance


nike factory


oakley


michael kors outlet


kids jordans


converse shoes


michael kors


oakley sunglasses


2018.10.10chenlixiang
2018-10-10 2:42:44
d xiao
2018-10-16 xiaozhengzheng

pandora jewelry outlet


michael kors outlet online


ugg outlet


coach outlet store online


kate spade bags


coach outlet


nike sneakers


christian louboutin


coach outlet online


cheap ugg boots


prada outlet online


polo outlet


michael kors outlet online


north face


uggs outlet


air jordan 4 retro


coach outlet


pandora jewelry


cheap jordans


canada goose outlet


moncler outlet online


mbt shoes


canada goose


tory burch outlet


mbt


north face outlet


coach outlet


polo ralph lauren outlet


true religion outlet


pandora charms sale clearance




2018-10-16 3:18:02
d chanyuan

ralph lauren polo


michael kors outlet clearance


baseball bats


undefeated clothing


kate spade handbags


ugg boots


ralph lauren outlet


adidas flip flops


uggs


ugg outlet


red bottom shoes


ambassador 10


moncler outlet online


north face backpacks


mishka clothing


fjallraven kanken


ʫ ーー


balenciaga shoes


hermes bags


ugg outlet


oakley sunglasses


burberry outlet


kate spade purse


kate spade outlet


versace clothing


giuseppe zanotti


nike dunks


north face outlet store


malone souliers


michael kors handbags


canada goose jackets

adidas nmd


tiffany bracelet


fitflops


nike cortez


mk purse


christian louboutin


soccer jersey


christian louboutin shoes


air max 1


birkenstock sandals


ugg boots outlet


christian louboutin outlet


kate spade handbags

ugg canada

nike air max


canada goose outlet


lebron james jersey


lee jeans


balenciaga shoes


chenlina20181106
2018-11-06 11:49:21
d chanyuan
2018-11-19 xiaozhengzheng

canada goose outlet


polo shirts


ray ban wayfarer


kate spade handbags


true religion jeans


ugg boots


coach factory outlet


valentino outlet


true religion jeans


christian louboutin outlet


pandora outlet


uggs outlet


christian louboutin shoes


polo ralph lauren pas cher


ugg boots


christian louboutin shoes


coach outlet


mont blanc pens


coach factory outlet


nike outlet store


fred perry polo shirts


kate spade bags


air jordan shoes


michael kors outlet


canada goose outlet


mont blanc pens


adidas outlet store


giuseppe zanotti sneakers


michael kors outlet clearance


cheap ugg boots



2018-11-19 6:14:55
d qzyfffff

birkin bag


adidas eqt support


balenciaga


adidas nmd


lacoste polo


goyard wallet


tory burch


nike foamposite


bape hoodie


adidas zx flux


red bottoms


yeezy boost 350 v2


off white clothing


air jordan


stephen curry 5


asics shoes


adidas nmd


adidas tubular


nike shoes


yeezy


kevin durant shoes


offwhite


jordan shoes


goyard handbags


goyard st louis tot


off white nike


yeezy shoes


adidas yeezy


hermes handbags


golden goose outlet


supreme hoodie


kobe sneakers


adidas shoes online


christian louboutin


birkin bag


yeezy boost 350


adidas shoes


lebron 16 shoes


nike cortez


lebron 15 shoes


longchamp


chrome hearts


yeezy 500


fitflops sale clearance


ralph lauren uk


adidas ultra boost uncaged


jordans


balenciaga shoes


fake rolex watches


adidas stan smith


qzyfffff

2018-12-28 5:54:34
d yanmaneee

ferragamo belt


hermes belt


kd 11 shoes


moncler coat


chrome hearts store


nike shoes


yeezy boost 350


nfl jerseys


vapormax


goyard tote


longchamp


polo ralph lauren


golden goose


yeezy


golden goose outlet


russell westbrook shoes


golden goose


christian louboutin shoes


off white jordan 1


valentino shoes


nike flyknit


supreme hoodie


balenciaga shoes


irving shoes


adidas nmd


cheap jordans


kobe basketball shoes


golden goose sneakers


golden goose shoes


michael kors handbags


kobe shoes


jordan shoes


yeezy boost 350 v2


air max 270


nike air max 270


nike 270


timberland outlet


longchamp handbags


asics shoes


yeezy wave runner 700


yanmaneee

2019-04-29 7:11:51
Խù ǰ Է ּ(4,000 ̳).
ڵ
 2007
μ ⹮
ǻȰ ⹮
2013 ޿ ڵ
ܿ ⹮ ˻
ڵȭ
ڵȭ
ǹ
ε帲  ˻
ڵȭۿû
ȣ : ε帲ȹ | ڵϹȣ : 105-20-55088 | ǸžŰȣ : 5343ȣ | ǥ : |
å : ̼ҿ | ּ : Ư ŷ16 47 201ȣ() | ȭ: 02)323-7705 |
Fax: 02)6918-4545 | Աݰ : (543001-01-213514) | E-Mail :
Copyright 2006 ε帲ȹ(www.edodream.com) All Rights Reseved.