Erwthsh excel..pros tous GUROU tou eidous:)

[nickb123]

Erwthsh excel

 

ESTW OTI EXOUME 2 DIAFORETIKA ARXEIA EXCEL POU TO KATH ENA PERIEXEI 2 STHLES

 

ARXEIO EXCEL 1 ARXEIO EXCEL 2

 

 

STHLH A STHLH B STHLH G STHLH D

 

 

 

OI STHLES A KAI G EXOUN KOINA DEDOMENA ALLA OXI ME THN IDIA SEIRA. P.X

 

STHLH A

1

2

3

 

STHLH G

2

1

3

 

YPARXEI KAPOIOS “AYTOMATOS tropos wste na kanw ennalagh twn sthlwn b kai D alla ta dedomena tous na adistoixithun plirws me ta dedomena twn sthlwn pou ypirxan stis dipla stiles tous (a kai g) prin thn ennalagh?

 

p.x

 

STHLH A

1 4

2 33

 

STHLHB

4 (adistoixei sto 1 ths A)

33 (ADISTOIXEI STO 2 THS A)

 

STHLH G

2

1

 

STHLH D

44 (ADISTOIXEI STO 2 THS G)

54 ( ADISTOIXEI STO 1 THS G)

 

 

 

 

 

 

 

KAI META THN ENNALAGH:

 

STHLH A

1

2

 

STHLH D

54 (ADISTOIXEI STO 1 THS A!)

44 (ADISTOIXEI STO 2 THS A!)

 

STHLH G

2

1

 

STHLH D

33

4

 

 

 

MESA APO POIO MENU I ME POIA DIADIKASIA BORW NA TO KANW?

 

thanks in advance!

[grigas]

an k den katalavainw ti ennoeis 2 arxeia kai ypothetontas oti anti gia G mallon ennoeis c kaneis ta eksis(gia toys typoys estw ta dedomena arxizoyn apo tin grammi1 kai teleiwnoyn stin grammi 50)

 

stili e ws exei

 

stili f =vlookup(a1,c$1:d$50,1,0)

 

stili g ws exei

 

stili h = vlookup(c1,a$1:b$50,1,0)

 

Stoys typoys analoga me to pws exeis ta regional settings anti gia , endexetai na thes ;

 

An katalava kala tin erwtisi soy kaneis ayto kai eisai ok

[grigas]

ekanes edit k me mperdepses twra....alla nomizw eixa katalavei swsta...

[nickb123]

2 axeia ennow 2 diaforetika excel...alla edaxei tha borusan na einai kai se ena arxeio pou apla exei 4 sthles.nai adi gia g ennow C (SORRY!).to vlookup se poio menu brisketai? thanks again !

[nickb123]

mia ennagh STHLWN thelw na kanw me liga logia apla epeidi ta dedomena twn dipla sthlwn (apo aytes pou thelw na allaxw) den exoun thn idia seira (opou an eixan me ena copy-paste tha lunotane) thelw kata thn enallagh ta swsta dedomena na "katsoun" dipla sta adistoixa.

[grigas]

to vlookup einai entoli....an tin valeis to help tha soy eksigisei ta panta..efoson einai se 2 diaforetika arxeia toy excel tin epilogi toy zeygoys stilwn tha tin kaneis me to pontiki wste na parei to path toy arxeioy.exe ypopsi oti an allakseis meta tin thesi twn arxeiwn (to directory) kai paei na kanei update ta data tha xasei tin mpala to excel..gi ayto prosoxi!