Erotima gia empeiroys sto excel:

[sosimple]

Thelo na kano kati sto excel.An kapios mporei na voihthisei tha toy eimai

ypoxreos... Synkekrimena esto oti exo tis parakato 4 stiles:

 

kodikos Pelaths kodikos Pelaths

1 A 1 A

2 B 3 C

3 C 4 D

4 D

 

 

Opos vlepete sthn trith stilh lipei o kodikos 2 poy antistoixei ston pelath B (An

yphrxe kai afto , ta stoixeia ths 3hs kai 4hs stilhs tha htan oloidia me ta stoixeia

ths 1hs me th deyterh....) Afto pou thelo na kano, einai na sigrinei kapos

toys kodikoys to excel, kai na mou vazei se kathe gramh toys idioys kodikoys (me

toys antistoixoys pelates) vazontas se oti lipei keno , diladi ta parapano dedomena

na ginoyn:

kodikos Pelaths kodikos Pelaths

1 A 1 A

2 B 2 B

3 C

4 D 4 D

Ypopsin milame gia 2000 grames arxeio...An kapios kserei pos na to kano, h exei

kamia idea tha me vohthisei para poli. Thanks,

 

[isim]

auto pou xreiazesai einai na ksereis VBA kai na grapseis ena aplo makro pou na kanei auto pou thes. Geia na katalabeis ean exeis ftasei sto telos elegxeis an i epomeni grammi exei keno string.

[makisathanos]

Ίσως τέτοια προβλήματα με πελάτες και αντίστοιχους κωδικούς να αντιμετωπίζονται καλύτερα με μια βάση δεδομένων π.χ. access.

[Jimis]

για πες μου, ο κάθε πελάτης έχει μόνο έναν κωδικό;

μαλλον ετσι πρεπει να είναι το σωστό.

 

επιπλέον, κάποια από τις δύο στήλες έχει διπλές εγγραφές;

 

Η 1η στήλη έχει όλους τους πελάτες, ενώ για κάποιο λόγο (πες μου αν θέλεις το λόγο) λείπουν οι εγγραφές από τη 2η στήλη.

 

Απάντησε αν θέλεις και τα λέμε

[tkappas]

An katalaba kala theleis na antigrafeis tis duo prwtes sthles me liga logia....

Apla pane stis function kai bres thn SUBSTITUTE

 

An Baleis p.x

 

=SUBSTITUTE(B2;"pelaths2";B2)

 

Mporeis na antigrapseis thn timh toy keliou B2 sto keli pou theleis.An baleis keno antigrafei keno

[sosimple]

Katarxas thanks gia tis apantiseis.Tora tis eida kai apanto sinolika.

Tha prospathiso na gino pio katanohtos gia na mou peite an kserete an mporei na

ginei mias kai den exo empiria pano sto excel.Exo empeiria pano se gloses

programatismou, basic , C ,klp.

Exo piasei doylia se mia etairia, opote tetia provlimata pano sto excel tha exo pola...

Me to excel doyleyoun ekei mesa,Gia thn akrivia exoyn ena dikhs toys kataskeyhs logistiko paketo (se dos...) to opio eksagei ta stoixeia poy vgazei se arxeio.dbf (d base)

Opote ta pernoume meta, ta petame sto excel kai ta epeksergazomaste gia na vgaloyme kathe

mera ena soro stixeia.( Paragogikothtes,diagramata pithanothtes na mhn mas plirosei kapios

pelaths ta opia stelnoume se asfalistikes eteries klp..) Gia na sas doso na katalavete,

an doso lysh sto parapano provlima moy, ego kerdizo 1 ora doylias kathe mera.

Exo 2 stiles opos eipa kai parapano. Oi kodikoi stis 2 stiles einai idioi, kai kathe kodikos antistixei se 1 monadiko pelati.

Dino ena paradigma: To parakato :

Kodikos 1 Pelaths1 Kodikos2 Pelaths 2

...1.........A.........1.........A...Ta stoxeia ton 2 proton stilon einai 1 mhna

...2.........B.........2.........B...kai ton alon 2 stilon toy epomenoy mhna

...4.........C.........5.........D...Thelo na ta valo to kathe stixeio apenanti apo to alo

...7.........E.........8.........F...gia na ta sigrino na 2 ti metavoles exoyn ginei miniaia

...8.........F.......................oste na do an mpike kapios alos pelaths, h an efige kapios. (sthn pragmatikothta exo kai ales stiles ala

an lyso afto,pisteyo tha lyso kai ta ypolipa.

Thelo na ginei:

...1.........A.........1.........A...Edo opos vlepete einai opos ta thelo apenanti apo ton

...2.........B.........2.........B...kodiko 1 pou antistoixei ston pelath A yparxei o

...4.........C...................... idios kodikos kai pelaths (1 kai A) Epidi sthn 3h kai

...7.........E.......................4h sthlh den yparxei o kodikos 4 poy antisteixei ston

.......................5.........D...Pelath C typonetai keno, To idio gia ta stixeia 7,E

...8.........F.........8.........F... Eno antistrofa epidh sthn 3h kai 4h sthlh yparxoyn ta 5, D antoistoixa, pou den yparxoyn sthn 1h,2h sthlh,typonetai ekei keno, parakato mpenoun ta 8,F apenanti apo ta idia 8,F afoy yparxoun...

Elpizo tora na katalavate ti thelo na kano.An eixa na kano me 5 grames tha to ekana paneykola xeirokinita.Ela omos poy exo na kano me 2000 grames... Akoma kai kapia skepsh h

gnomh pies entoles prepei na xrisimopoihso isos tha me vohthoysan. An vohthei, mporo na valo

eksarxhs se kapia logikh seira ta stixeia (kanontas mia taksinomish kata ayksoysa h fthinoysa seira (mias kai oi kodikoi einai arithmoi.

Oi Kodikoi einai ana sthlh ,monadikoi, diladi den mporei sth sthlh (Kodikos1) na

vro ton kodiko 4 ,2 fores.

[md_agis]

To provlhma einai oi ypoloipes oi stiles ti 8a ginoun? Gia paradigma an sthn 3 kai 4 yparxei diaforetikos kwdikos pelath 8a prepei h gramh tous na meinei kenh kai autoi na metafer8oune poio katw. Oi stiles omws pou vrhskontai poio deksia apo tis 1,2,3,4 8a pane mazi me thn 3 kai 4 h 8a meinoun me thn 1 kai 2?

Kai mia teleutaia erwthsh: To sygekrimeno sheet pou douleveis exei formules h mono text kai ari8mous ? Giati an exei mono text kai ari8mous einai poly poio eukolo na ginei auto pou 8es.

[gv]

ΝΑ ΑΥΤΟ ΠΟΥ ΖΗΤΑΣ

 

 

 

ΚΑΤΕΒΑΣΕ ΤΟ ΚΑΙ ΠΑΤΑ ΤΟ ΚΟΥΜΠΑΚΙ ...

ΜΗΝ ΜΕ ΒΑΛΕΙΣ ΟΜΩΣ ΝΑ ΣΟΥ ΦΤΙΑΞΩ ΟΛΟ ΤΟ ΠΡΟΓΡΑΜΜΑ !!!

[sosimple]

File gv eisai theos! Afto akrivos thelo, me vohthises hdh para poli..

Ksereis ti paketo einai na valeis ta dedomena me afth th seira otan exeis 500-2000 grames

kai thes na to kaneis afto? Eimoun veveos oti ginotan, apla pisteya oti tha yphrxe kapios

pio aplos tropos apo to na xrhsimopoihso visual basic, oxi tipota alo ala den ksero

pos akrivos syntasetai h vb...Thn monh basic poy exo doylepei poli kai eixa mathei

apsoga htan toy AMSTRAD CPC6128!! Poli palio PC e?

Pantos katalava to 80% toy kodika.Kai ama vro kana vivlio gia vb eimai sigoyros oti

mporo na to ftiakso. Tora mh me vriseis, ala ego tha soy steilo ena filo toy excel me

ena paradeigma opos einai pragmatika to provlhma, me ton pragmatiko arithmo sthlon klp,

kai EAN kai OTAN exeis xrono riksoy mia matia mias kai to exeis lysei se pososto 90%.

gia thn akrivia to mono poy menei einai na akoloythoun kai oi ypolipes sthles poy

antistoixoyn stoys kodikoys.Isos me mia mikrh tropopihsh na doyleye etsi opos to thelo.

An pali den vreis xrono ,Thanks, me vohthises hdh poli.

 

Pros md_agis:Den katalava akrivos ti enoeis,an sthn 3h sthlh yparxei diaforetikos kwdikos pelath , kai aftos den yparxei sthn 1h, (pragma spanio) as metafer8ei opos les kai esei poio katw, teleytaia as poyme, den exo provlima me afto, an den mporei na ginei alios.

To sygekrimeno sheet exei mono text kai ari8mous ,kai malista oi arithmoi (kodikos1 kai

kodikos2 einai me seira ,gia thn akrivia toys vazo se seira me mia aplh taksinomhsh.,soy stelno kai esena ena paradigma filoy toy excel ,mhpos exeis kamia pio aplh idea.

Thanks se oloys.

 

 

[md_agis]

Pantws auto pou 8es mporeis na to ftiakseis se glwssa c poly eukola. Alpws swse to arxeio oxi san xls alla san csv. An anoikseis to csv me enan text editor (me greek encoding) 8a katalaveis ti sou lew.

[gv]

koita to e-mail sou