Results 1 to 9 of 9
Thread: Excel - ôîðìóëà çà ...
Hybrid View
-
5th June 2007 22:13 #1
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))
-
5th June 2007 22:19 #2
Àêî ñúì ñõâàíàë ïðàâèëíî (âúâåæäàø èìåòî, à òî îòêðèâà ñúîòâåòíîòî ÅÃÍ), vlookup òðÿáâà äà òè ñâúðøè ðàáîòà.
Àêî âñè÷êî òè èçãëåæäà íàðåä, ÿâíî íåùî òè óáÿãâà...
[Core2 Duo E6600] [ASUS P5B] [2x512 MB Elixir] [Seagate Barracuda: 7200.7 Plus 160GB + 7200.10 250GB + 7200.10 sATA 320GB]
-
5th June 2007 22:22 #3
èäåÿòà ìè å ÷å èìàì èìåíàòà è åãí-òàòà è èñêàì êàòî îòâîðÿ åêñåëñêèÿ ôàéë äà ìè èñïèñâà : ÄÍÅÑ ÄÀ ÏÎ×ÅÐÏÈ ÈÂÀÍ ÑÒÎÉ×ÅÂ
((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))
-
5th June 2007 23:21 #4
Ñ ôîðìóëà ìàé íÿìà äà ñòàíå òðÿáâà ñ ìàêðîñ
EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2
-
6th June 2007 01:09 #5
Ìäàì, ìàé ñ ôîðìóëà íÿìà äà ñòàíå. Ïîíå íå ñ ïðîñòè÷êà ôîðìóëêà.
Íàêðàòêî - îðèåíòèðàé ñå ïî ñëåäíàòà ñõåìà:
- ïðèâåæäàíå íà ÅÃÍ-òàòà îò òèï ÃÃÌÌÄÄÕÕÕÕ êúì ÄÄÌÌ
- ñåòâàíå íà òåêóùàòà äàòà â íÿêàêâà êëåòêà
- òúðñåíå â áàçàòà (÷àê òóê ñå ïîÿâÿâà ô-ÿòà lookup) è èçâåæäàíå íà èìåòî (èìåíàòà) íà ñúâïàäåíèÿòà ìåæäó òåêóùàòà äàòà (ÄÄÌÌ) è ïðèâåäåíîòî ÅÃÍ (ÄÄÌÌ)Àêî âñè÷êî òè èçãëåæäà íàðåä, ÿâíî íåùî òè óáÿãâà...
[Core2 Duo E6600] [ASUS P5B] [2x512 MB Elixir] [Seagate Barracuda: 7200.7 Plus 160GB + 7200.10 250GB + 7200.10 sATA 320GB]
-
6th June 2007 13:11 #6
Àêî íå òè ñå ïèøå ìàêðîñ, ìîæå äà ïðîáâàø äðóãî - â êîëîíà 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.
-
6th June 2007 20:44 #7
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
-
8th June 2007 00:02 #8
offtopic: òèÿ äåòî ñà ðîäåíè ïðåäè 1900ã, íà äàëè ùå ìîãàò äà ïî÷åðïÿò ;-)
Too important to be said.
-
9th June 2007 00:45 #9((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))




Reply With Quote

Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð