Jason wrote:
To grafw edo, wste meta apo kana 7mhno an to dei kapoios kai kserei, na to apantisei
1) sto Excel exo orisei orismena kelia ws "text". Otan se "text" keli vazeis ena sketo noumero, sou vgazei auto to prasino trigonaki stin panw-aristera gwnia tou keliou, kai otan patiseis panw sto keli, sou vgazei auto to kitrino thaumastiko opou prepei kathe fora na epilegeis "ignore error" gia na min sou emfanizei pia oute to kitrino oute to prasino. OK to ematha to error pou kanw, den thelw na me enhmerwnei pia sta text kelia. Pws ginetai na to apenergopoihsw? (na grafw ena noumero se text keli kai na mou to dexetai kateutheian)
2) episis sto Excel: pws vriskw kelia pou exoun idio periexomeno? (duplicates)
1)Re tragike. Patas sto kitrino 8aymastiko kai klikareis thn teleytaia epilogh (ypo8etw oti exeis Excel 2010). Sta ellhnika einai "epiloges elegxou sfamlatwn". Sto para8yro pou bgainei, sthn enothta "kanones elegxou sfalmatwn", 3eklikareis thn epilogh "ari8moi me morfopoihsh keimenou h' twn opoivn prohgeitai apostrofos". Patas OK kai eisai OK.
2)Markareis ta kelia ta opoia 8eleis na eleg3eis gia duplicates. Pas "conditional formatting" > "highlight cells rules" > "duplicate values". Patwntas OK sou kanei highlight ta diplotypa, dialegontas "unique" kai patwntas OK sou kanei highlight ta monadika.
OK ta tsekara kai ta 2, thanks. Tora tha ta vrw kai sto Exceli to classic to 2003 pou einai kai pio meraklidiko