ϳ . .
. , . . , .
:
* , .
* .
* ð (Data ð Consolidate).
* .
, . , . :
. .
ϳ .
:
= (2: 10! 1)
=[ 1. xls ] 1! 1 + [ 2. xls ] 1! 1
. , . , . . :
.
, .
ð (Edit ð Paste Special). ʔ.
ð . . ð :
* . , .
* . .
ð (Consolidate), :
(Function). , , : (Sum); - (Count); (Avg); (Max); ̳ (Min); (Product); - (CountNums); (StdDev) ( ); (StdDevp) ( ); (Var); (Varp)( ).
|
|
(Reference). . - , . ϳ (Add), . , , .
³ (All references) , (Add).
(Use Labels In). , . .
(Create Links to Source Data). , . , . , .
, . .
(Add) (Reference) (All references).
(Delete) .
:
, . ( ) ( ). . 䳿:
. ³ .
ð .
. .
. , , , . . , , , . ϳ , .
, .
, . Excel .
. Excel .
, ʔ.
|
|
Excel , . ( ), ( ). , . .