Results 1 to 9 of 9

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User crazyman's Avatar
    Join Date: Dec:2004
    Location: Ñîôèÿ
    Posts: 137

    Excel - ôîðìóëà çà ...

    Íÿêîé ìîæå ëè äà ïîìîãíå ñ ôîðìóëà â Excel ... èäåÿòà å ñëåäíàòà: â êîëîíà À èìàìå òðèòå èìåíà íà îïðåäåëåí áðîé äóøè. Â êîëîíà B èìàìå ÅÃÍ-òàòà íà òåçè õîðà. Êàêâà å ôîðìóëàòà äà ìè ñâúðæå ðîæäåííàòà äàòà îò ÅÃÍ-òî ñ òåêóùèÿ äåí. Öåëòà å äà ðàçáåðà êîé èìà ðîæäåí äåí íà òåêóùèÿ äåí.
    Íàäÿâàì ñå äà ñòå ìå ðàçáðàëè.
    Last edited by crazyman; 5th June 2007 at 23:17. Reason: äîïúëíåíèå
    ((MSI P45C Neo-FIR)) ((Core 2 Duo E8400)) ((Corsair DDR3 2x2/1333)) ((ATI Radeon HD 5600)) ((WD 1TB)) ((DVD RW LG4160B)) ((CASE Middle Toweð ATX Fortron 350W)) ((HP LP2465 - 24")) ((win7 x64))

  2. #2
    Registered to Quan's Avatar
    Join Date: Oct:2003
    Location: 1070
    Posts: 826
    Àêî ñúì ñõâàíàë ïðàâèëíî (âúâåæäàø èìåòî, à òî îòêðèâà ñúîòâåòíîòî ÅÃÍ), vlookup òðÿáâà äà òè ñâúðøè ðàáîòà.
    Àêî âñè÷êî òè èçãëåæäà íàðåä, ÿâíî íåùî òè óáÿãâà...

    [Core2 Duo E6600] [ASUS P5B] [2x512 MB Elixir] [Seagate Barracuda: 7200.7 Plus 160GB + 7200.10 250GB + 7200.10 sATA 320GB]

  3. #3
    Registered User crazyman's Avatar
    Join Date: Dec:2004
    Location: Ñîôèÿ
    Posts: 137
    èäåÿòà ìè å ÷å èìàì èìåíàòà è åãí-òàòà è èñêàì êàòî îòâîðÿ åêñåëñêèÿ ôàéë äà ìè èñïèñâà : ÄÍÅÑ ÄÀ ÏÎ×ÅÐÏÈ ÈÂÀÍ ÑÒÎÉ×ÅÂ
    ((MSI P45C Neo-FIR)) ((Core 2 Duo E8400)) ((Corsair DDR3 2x2/1333)) ((ATI Radeon HD 5600)) ((WD 1TB)) ((DVD RW LG4160B)) ((CASE Middle Toweð ATX Fortron 350W)) ((HP LP2465 - 24")) ((win7 x64))

  4. #4
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426
    Ñ ôîðìóëà ìàé íÿìà äà ñòàíå òðÿáâà ñ ìàêðîñ
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  5. #5
    Registered to Quan's Avatar
    Join Date: Oct:2003
    Location: 1070
    Posts: 826
    Ìäàì, ìàé ñ ôîðìóëà íÿìà äà ñòàíå. Ïîíå íå ñ ïðîñòè÷êà ôîðìóëêà.
    Íàêðàòêî - îðèåíòèðàé ñå ïî ñëåäíàòà ñõåìà:
    - ïðèâåæäàíå íà ÅÃÍ-òàòà îò òèï ÃÃÌÌÄÄÕÕÕÕ êúì ÄÄÌÌ
    - ñåòâàíå íà òåêóùàòà äàòà â íÿêàêâà êëåòêà
    - òúðñåíå â áàçàòà (÷àê òóê ñå ïîÿâÿâà ô-ÿòà lookup) è èçâåæäàíå íà èìåòî (èìåíàòà) íà ñúâïàäåíèÿòà ìåæäó òåêóùàòà äàòà (ÄÄÌÌ) è ïðèâåäåíîòî ÅÃÍ (ÄÄÌÌ)
    Àêî âñè÷êî òè èçãëåæäà íàðåä, ÿâíî íåùî òè óáÿãâà...

    [Core2 Duo E6600] [ASUS P5B] [2x512 MB Elixir] [Seagate Barracuda: 7200.7 Plus 160GB + 7200.10 250GB + 7200.10 sATA 320GB]

  6. #6
    Unprofessional Amateur spirtbrat's Avatar
    Join Date: Oct:2005
    Location: Ñîôèÿ
    Posts: 52
    Àêî íå òè ñå ïèøå ìàêðîñ, ìîæå äà ïðîáâàø äðóãî - â êîëîíà C ïèøåø òàçè ôîðìóëà:
    =IF(AND((VALUE(MID(B1;3;2)))=(MONTH(TODA Y()));(VALUE(MID(B1;5;2)))=(DAY(TODAY()) ));"òðÿáâà äà ïî÷åðïè";" ")
    è ÿ äúðïàø íàäîëó çà êâàäðàò÷åòî â äîëíèÿ úãúë íà êëåòêàòà. Òàêà, àêî íÿêîé èìà ðîæäåí äåí, â êîëîíà C íà íåãîâèÿ ðåä ùå ïèøå "òðÿáâà äà ïî÷åðïè".
    The harder I work, the luckier I goddamned get.

  7. #7
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426
    spirtbrat Àìè êàêâî ïðàâèì ñ ðîäåíèòå ïðåäè 1900 èëè ñëåä 2000 ìàé ôîðìóëàòà íÿìà äà ðàáîòè.Âñúùíîñò ìîæå è äà ñòàíå àêî â ïðîâåðêàòà çà month ñå ñëîæàò äâà òðè IF âëîæåíè åäèíèÿ äà ïðîâåðÿâà äàëè å ïî ãîëÿì îò 20 è äðóãèÿ äàëè å ïî ãîëÿì îò 40 è äà ãî ïðàâè íîðìàëåí ìåñåö.
    Last edited by entium; 6th June 2007 at 20:49.
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  8. #8
    DmKotev dimension's Avatar
    Join Date: Feb:2006
    Location: BG
    Posts: 235
    offtopic: òèÿ äåòî ñà ðîäåíè ïðåäè 1900ã, íà äàëè ùå ìîãàò äà ïî÷åðïÿò ;-)
    Too important to be said.

  9. #9
    Registered User crazyman's Avatar
    Join Date: Dec:2004
    Location: Ñîôèÿ
    Posts: 137
    Quote Originally Posted by spirtbrat View Post
    Àêî íå òè ñå ïèøå ìàêðîñ, ìîæå äà ïðîáâàø äðóãî - â êîëîíà C ïèøåø òàçè ôîðìóëà:
    =IF(AND((VALUE(MID(B1;3;2)))=(MONTH(TODA Y()));(VALUE(MID(B1;5;2)))=(DAY(TODAY()) ));"òðÿáâà äà ïî÷åðïè";" ")
    è ÿ äúðïàø íàäîëó çà êâàäðàò÷åòî â äîëíèÿ úãúë íà êëåòêàòà. Òàêà, àêî íÿêîé èìà ðîæäåí äåí, â êîëîíà C íà íåãîâèÿ ðåä ùå ïèøå "òðÿáâà äà ïî÷åðïè".

    òåñòâàõ... ðàáîòè... òî÷íî òîâà ìè òðÿáâà ... âåëèê ñè ÷îâå÷å )
    Áëàãîäàðÿ!!!
    ((MSI P45C Neo-FIR)) ((Core 2 Duo E8400)) ((Corsair DDR3 2x2/1333)) ((ATI Radeon HD 5600)) ((WD 1TB)) ((DVD RW LG4160B)) ((CASE Middle Toweð ATX Fortron 350W)) ((HP LP2465 - 24")) ((win7 x64))

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