JozoMujica Posted June 23, 2015 Share Posted June 23, 2015 Pa takve linkove otvaraš u Private Window-u. Kada klikneš na gornje desno ćoše da ti se otvori meni, druga ikona u prvom redu je New Private Window. Surfovanje u tom režimu ne ostavlja nikakve tragove na računaru. Link to comment
Moća Posted June 24, 2015 Share Posted June 24, 2015 Ne nego ces da krijes da posecujes forum Ana.rs. Link to comment
John Coltrane Posted June 24, 2015 Share Posted June 24, 2015 Ajde bezi bre, kako te nije sramota. Link to comment
copkillah Posted June 24, 2015 Share Posted June 24, 2015 Ajde bezi bre, kako te nije sramota. Sramota me na tvoj racun. Link to comment
ExicPL Posted June 27, 2015 Share Posted June 27, 2015 Imam neki veliki excel. U jednom sheet-u su tabele jedna ispod druge. Datum kreriranja tih tabela je u celijama a1, a40, a79, a118... dakle u svakoj 39-oj. Kako da izvucem samo datume da budu u novom sheet-u jedan ispod drugog? Gledam na netu nesto sa index funkcijom ali ne umem :( Link to comment
radisa Posted June 27, 2015 Share Posted June 27, 2015 U VBA napravi loop sa stepom 39 i stavi da ti svaku 39 ćeliju stavi u Sheet2. Vako nekako: alt +F11 da uđeš u deo za programiranje i ubaciš ovako nešto: Sub test() Dim i As Integer Dim k As Integer Dim V As Variant k = 1 For i = 1 To 1000 Step 39 Application.Sheets("Sheet1").Activate V = Cells(i, 1) Application.Sheets("Sheet2").Activate Cells(k, 1) = V k = k + 1 Next End Sub Ovoti prebaci iz "Sheet1" svaki 39. red u "Sheet2" u prvu kolonu, redom. A možeš i ovako, jednostavnije je: Stavi u kolonu D u sheet2 ovaj niz 1 40 79 118 157 196 235 274 313 352 391 430 469 508 547 586 A onda u A1 u sheet2 stavi ovo: =INDEX(Sheet1!A:A;D1) I povuci dole :) Link to comment
Frank Pembleton Posted June 28, 2015 Share Posted June 28, 2015 (edited) Ajde kad smo kod excella jel moze da se iz gdocsa njihov gogle sheets dl-je kao office excell?Nesto mi ne uspeva... Edited June 28, 2015 by Frank Pembleton Link to comment
Zli Gli Posted July 4, 2015 Share Posted July 4, 2015 tfght is compressed Press Ctrl+Alt+Del to restart Drugarici se ovo desilo na laptopu, mislim da ima windows 7. Jel ima neko drugo resenje osim ovog sto pominju sa loadovanjem necega sa instalacionog cd-a? Pitam za drugo resenje jer nema cd a nemam ni ja :D Link to comment
djili Posted July 4, 2015 Share Posted July 4, 2015 Može neko drugi sa istom verzijom windowsa da napravi system repair disk, nešto ovako http://www.sevenforums.com/tutorials/2083-system-repair-disc-create.html Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now