Results 1 to 8 of 8

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jul:2001
    Location: Âàðíà
    Posts: 584

    Ïîìîù çà åêñåë

    Òðÿáâà ìè ìàëêî ïîìîù çà åêñåë 2000. Èíòåðåñóâà ìå åäíà ôóíêöèÿ countif, ò.å. äà ìè ïðåáðîè êîëêî çàïèñà îòãîâàðÿò íà 2!!! êðèòåðèÿ. Ñ åäèí êðèòåðèé íÿìà ïðîáëåì, àìà êàòî ñëîæà è âòîðè è ... Åòî ãî ôàéë-÷åòî:
    http://cekobg.hit.bg/Book1.xls

    Ìåðñè íà âñè÷êè ïðåäâàðèòåëíî!
    Thå Power Of Dreams

  2. #2
    conscientious objector Tarambuka3500's Avatar
    Join Date: Jan:2002
    Location: Ñîôèÿ
    Posts: 2,034

    xxx

    tazi idiotstina trqbva da q napravish SAMO s CountIf ili kak???
    Robot Arkadash says:
    There are alternatives to fighting.

  3. #3
    motherfather The Penalty's Avatar
    Join Date: Mar:2002
    Location: ÑÔ
    Posts: 20,469
    Åòî òè ãî ðåøåíèåòî:
    Ïðàâèø ðàçëè÷íè êëåòêè çà âñåêè êðèòåðèé è íàêðàÿ ãè ñóìèðàø èëè òàì êàêâîòî ãè ïðàâèø íà ôèíàëà...
    Attached Files

    • Ìîæåø äà èçâàäèø ÷îâåêà îò ñåëîòî, íî ñåëîòî îò ÷îâåêà - íèêîãà
    • Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us
    • Soul platinum 1 and 2. See? It's not the game - you suck.


  4. #4
    motherfather The Penalty's Avatar
    Join Date: Mar:2002
    Location: ÑÔ
    Posts: 20,469
    à-à-à, è îùå íåùî,
    ïîíåæå íå ðàçáðàõ êàêúâà å òî÷íî öåëòà ( ) ùå òè äàì îùå åäèí ïðèìåð:

    =COUNTIF(A1:F9;"A*C*")

    Òîâà âðúùà âñè÷êè êîèòî çàïî÷âàò ñ A è ñúäúðæàò C ñëåä íåãî (áåç çíà÷åíèå êúäå ñå íàìèðà)...

    Àêî íå ñúì òè ïîìîãíàë, ïèøè çà äà óòî÷íèì ïðîáëåìà

    • Ìîæåø äà èçâàäèø ÷îâåêà îò ñåëîòî, íî ñåëîòî îò ÷îâåêà - íèêîãà
    • Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us
    • Soul platinum 1 and 2. See? It's not the game - you suck.


  5. #5
    Registered User
    Join Date: Jul:2001
    Location: Âàðíà
    Posts: 584
    Àìè íà ìåí ìè òðÿáâà äà îòãîâàðÿ íà äâà êðèòåðèÿ åäíîâðåìåííî! ò.å. äà êàæåì äà çàïî÷âà ñ À è äà å ñ ïðîöåñîð 486 äà êàæåì. Ïîîòäåëíî ñè ãè ïðåáðîÿâà, îáà÷å êàòî ìó ñëîæà è äâåòå åäíîâðåìåííî è ...

    Tarambuka3500: Äðóãà ôóíêöèÿ, äåòî äà ïðåáðîÿâà êîëêî êëåòêè îòãîâàðÿò íà äàäåíà ñòîéíîñò èìà ëè? Ùîòî àç ñàìî òàÿ çíàì.
    Thå Power Of Dreams

  6. #6
    motherfather The Penalty's Avatar
    Join Date: Mar:2002
    Location: ÑÔ
    Posts: 20,469
    Åòî òîâà êîåòî èñêàø (ïîíå òàêà ñè ìèñëÿ), ïîëåòàòà êîèòî ñúì ïðîìåíèë ñà â çåëåíî.
    Òåçè êîèòî ñà ñëóæåáíè è áðîÿò ðàçíèòå ìó ðàáîòè ìîæå äà ãè õàéäíåø çà äà íå òè ñå ðàçâàëÿ ïåéçàæà
    Attached Files

    • Ìîæåø äà èçâàäèø ÷îâåêà îò ñåëîòî, íî ñåëîòî îò ÷îâåêà - íèêîãà
    • Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us
    • Soul platinum 1 and 2. See? It's not the game - you suck.


  7. #7
    Registered User
    Join Date: Jul:2001
    Location: Âàðíà
    Posts: 584
    Àààà òîâà å ìíîãî ÿêî Ìåðñè ìíîãî
    Thå Power Of Dreams

  8. #8
    motherfather The Penalty's Avatar
    Join Date: Mar:2002
    Location: ÑÔ
    Posts: 20,469
    N.P.
    Happy to help.

    • Ìîæåø äà èçâàäèø ÷îâåêà îò ñåëîòî, íî ñåëîòî îò ÷îâåêà - íèêîãà
    • Sometimes I think the surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us
    • Soul platinum 1 and 2. See? It's not the game - you suck.


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 | Ìàãàçèí çà åëåêòðîííè öèãàðè