Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    some member Flash's Avatar
    Join Date: Dec:2002
    Location: Âàðíà
    Posts: 1,020

    Ìàëêî ïîìîù çà MS Excel

    Ìèíà äîñòà âðåìå îò êàêòî ó÷èõìå MS Office ïàêåòà â ÒÓ è ñåãà êàòî ìè ñå íàëîæè äà íàïðàâÿ íåùî ñå îêàçà ÷å ñúì ãî ïîçàáðàâèë.
    Èìàì åäíà òàáëèöà ïîäîáíà íà òàçè
    Code:
    ÅÃÍ	           Äàòà	    Êîëè÷åñòâî
    8501012222	15,09,2005	15
    8501012222	16,09,2005	10
    8501012222	17,09,2005	20
    7710103333	15,09,2005	45
    7710103333	16,09,2005	45
    7710103333	17,09,2005	45
    Òðÿáâà äà ñìåòíà îáùîòî êîëè÷åñòâî çà âÿñêî ÅÃÍ
    ò.å. äà ïîëó÷à íåùî îò ñîðòà íà:
    Code:
    EÃÍ              Îáùî êîëè÷åñòâî
    8501012222        45
    7710103333        135
    Íÿêîÿ îò âñè÷êèòå ôóíêöèè ãî ìîæåøå òîâà äàæå ñúì ïðàâèë íåùî ïîäîáíî çà êóðñîâà ðàáîòà íî áåøå ïðåäè 2ã. äå òè òîëêîâà àêúë ó ìåí
    Àêñèîìà íà Êîë: "Èíòåëèãåíòíîñòòà íà ïëàíåòàòà å êîíñòàíòíà âåëè÷èíà, à íàñåëåíèåòî íåïðåêúñíàòî ñå óâåëè÷àâà."

  2. #2
    Registered User gaburko's Avatar
    Join Date: Sep:2001
    Posts: 5,081
    ïúðâî ìó äàâàø åäèí sort (ïî ÅÃÍ â òâîÿ ñëó÷àé). Ñëåä òîâà - data -> subtotals. at each change in ÅÃÍ, Use function:sum, Add subtotal to: êîëè÷åñòâî. òîâà å .

  3. #3
    some member Flash's Avatar
    Join Date: Dec:2002
    Location: Âàðíà
    Posts: 1,020
    Êîìïëåêñèðàõ ñå

    Ìåðñè ìíîãî
    Àêñèîìà íà Êîë: "Èíòåëèãåíòíîñòòà íà ïëàíåòàòà å êîíñòàíòíà âåëè÷èíà, à íàñåëåíèåòî íåïðåêúñíàòî ñå óâåëè÷àâà."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè