Excel 2007º¯Êý¹«Ê½ÊµÀý»ã×Ü

\¶à:{=TEXT(MODE(B2:B9*1),\ ÂÞÁгö±»Í¶Ë߶à´ÎµÄ¹¤×÷ÈËÔ±±à

ÄÄÖÖ²úÆ·Éú²ú´ÎÊý×î

ºÅ:{=IFERROR(TEXT(MODE(IF(COUNTIF($D$1:D1,$B$2:$B$11)=0,$B$2:$B$11*1)),\ ¶ÔѧÉú³É¼¨ÅÅÃû:=RANK(B2,B$2:B$11,0)

¼ÆËãÁ½ÁÐÊýÖµÏàͬ¸öÊý:=COUNT(RANK(B2:B11,C2:C11))

²éѯijÈ˳ɼ¨ÔÚÈý¸ö°àÖеÄÅÅÃû:³É¼¨{=LOOKUP(0,0/(E2:E11=H2),F2:F11)};Ãû´Î=RANK(I2,(B2:B11,D2:D11,F2:F11),0)

·Ö±ðͳ¼Æÿ¸ö·ÖÊý¶ÎµÄÈËÔ±¸öÊý:{=FREQUENCY(B2:B11,D2:D5)} ²õÁª¹Ú¾ü×î¶àµÄ´Î

Êý:{=MAX(FREQUENCY(ROW(B$2:B$11),(B$2:B$10<>B$3:B$11)*ROW(B$2:B$10)))}

¼ÆËã×î¶à¾­¹ý¼¸´Î²âÊԲųɹ¦:{=MAX(FREQUENCY(ROW(2:11),(B2:B11=\³É¹¦\ ¼ÆËãÈý¸ö²»Á¬ÐøÇø¼äµÄƵÂÊ·Ö

²¼:{=SUM(LOOKUP({1,3,5},ROW(1:5),FREQUENCY(B2:B11,{500,550,600,650})))}

¼ÆËãÒòÃÜÂë´íÎó±»Ëø¶¨¼¸´Î:{=COUNT(0/((FREQUENCY(ROW(2:12),(B2:B12<>\´íÎó\

¼ÆËãСѧ¼Ó³õÖÐÈËÊý¼°ÖÐר¼Ó´óѧÈËÊý:{=FREQUENCY((B2:B11<>\Сѧ\³õÖÐ\ ¼ÆËãÎı¾µÄƵÂÊ·Ö²¼:{=FREQUENCY(CODE(B2:B11),CODE(D2:D5))} ¶á ¹ÚÅÅÐаñ:{=IF(ROW(A1)>

SUM(1/COUNTIF($B$2:$B$11,$B$2:$B$11)),\($B$2:$B$11,$B$2:$B$11,),ROW($1:$9))-ROW($1:$10)%,ROW(A1)),FREQUENCY(MATCH($B$2:$B$11,$B$2:$B$11,),ROW($1:$9))-ROW($1:$10)%,)))} Ë­ ²õÁª¹Ú¾ü´ÎÊý×î

¶à:=INDEX(B2:B11,MATCH(MAX(FREQUENCY(ROW(2:11),(B2:B10<>

B3:B11)*ROW(2:10))),FREQUENCY(ROW(2:11),(B2:B10<>B3:B11)*ROW(2:10)),))

ÖйúʽÅÅÃû:{=SUM(--(IF(FREQUENCY(B$2:B$11,B$2:B$11),B$2:B$11>B2)))+1} Ë­ »ñµÃµÚ¶þÃû: {=INDEX(A:A,SMALL(IF(B$2:B$11=SMALL(IF(FREQUENCY($B$2:$B$11,$B$2:$B$11),$B$2:$B$11),2),ROW($2:$11),1048576),ROW(A1)))&\¼Ç¼µ±Ç°ÈÕÆÚÓëʱ¼ä:=TEXT(NOW(),\ÔÂdÈÕ h:m:s\È·¶¨ÊÇ·ñÒѵ½¼ÓÓÍʱ¼ä:=TEXT(NOW()-B2,\¹úÇìµ¹¼Æʱ:=TEXT(\ ͳ¼Æ·¢»õµ½ÊÕ¿îÌìÊý:=ROUNDUP(IF(B2<>\ͳ¼ÆÒѵ½´ïÊÕ¿îʱ¼äµÄ»õÆ·ÊýÁ¿:=COUNTIF(B2:B10,\

±¾ÔÂÐèÒªÍê³É¼¸Åú»õÎïÉú²ú:{=SUM(N(B2:B11=TEXT(TODAY(),\ ¼ÆËã±¾¼¾¶ÈÊÕ¿îµÄºÏ

¼Æ:{=SUM(IF(ROUNDUP(B2:B11/3,0)=ROUNDUP(TEXT(TODAY(),\ ÅÐ ¶Ï½ñÄêÊÇ·ñÈòÄê:=OR((MOD(TEXT(TODAY(),\

(MOD(TEXT(TODAY(),\ ¼ÆËã2008ÄêÓжàÉÙ¸öÐÇÆÚ

ÈÕ:{=SUM(N(TEXT(DATE(2008,1,ROW(INDIRECT(\ÈÕ\ ¼ÆËã±¾ÔÂÓжàÉÙÌì:=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0),\È·¶¨½ñÄêĸÇ×½ÚµÄÈÕ ÆÚ:=DATE(YEAR(TODAY()),5,14-WEEKDAY(DATE(YEAR(TODAY()),4,30),2)) ½ñ Äê°üº¬¶àÉÙ¸öÐÇ ÆÚ:{=SUM(N(WEEKDAY(DATE(YEAR(TODAY()),1,ROW(INDIRECT(\

(365+(DAY(DATE(YEAR(TODAY()),2,29))=29))))),2)=7))+(WEEKDAY(DATE(YEAR(TODAY()),1,365+(DAY(DATE(YEAR(TODAY()),2,29))=29)))<7)} ½«Éí·ÝÖ¤ºÅÂëת»»³É³öÉúÈÕÆÚÐò

ÁÐ:=DATE(MID(B2,7,2+(LEN(B2)=18)*2),MID(B2,9+(LEN(B2)=18)*2,2),MID(B2,11+(LEN(B2)=18)*2,2)) ¼ÆË㽨¹ú¶àÉÙÖÜÄê:=YEAR(TODAY())-1949

¼ÆËã2000ÄêÇ°µçÄÔÅàѵƽ¾ùÊÕ·Ñ:{=AVERAGE(IF(YEAR(A2:A11)<2000,B2:B11))}

¼ÆËã½ñÌìÀë±¾Äê¶È×îºóÒ»ÌìµÄÌìÊý:=(YEAR(TODAY())&\¼ÆËã±¾ÔÂÐèÒª½»»õµÄÊýÁ¿:{=SUM((MONTH(B2:B11)=MONTH(TODAY()))*C2:C11)} ¼ÆËã8Ô·ݱÊͲºÍë±ÊµÄ½ø»õÊýÁ¿:{=SUM(IF(MONTH(A2:A11)=8,IF((B1:H1=\±ÊͲ\ë±Ê\

¼ÆËã½»»õÆðÖ¹ÔÂ:{=MIN(MONTH(B2:B11))&\ÔÂ-\ÔÂ\Äê \\Ìì\

¼ÆËãÄê×Ê:=10*MIN(DATEDIF(B2,TODAY(),\ ¼ÆËãÁÙʱ¹¤µÄ¹¤×Ê:=ROUND(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(B2,\·Ö\Сʱ\ ¼ÆËã±¾ÈÕ¹¤Ê±¹¤

×Ê:=(HOUR(C2-TIMEVALUE(\¼ÆËã8£º00Ò»16£º00µÄƽ¾ùµç

ѹ:{=AVERAGE(IF((DAY(A2:A11)=8)*(HOUR(A2:A11)>=8)*(HOUR(A2:A11)>=16),B2:B11))} ¼ÆË㹤×÷ʱ¼ä£¬¾«È·µ½·Ö

ÖÓ:=HOUR(C2)+MINUTE(C2)/60-HOUR(B2)-MINUTE(B2)/60-D2+24*(C2

gt;=18,-(ROUNDUP((HOUR(B2-\0+60-MINUTE(B2))/30,0))*3)

¼ÆË㹤³Ìʱ¼ä:=SUMPRODUCT(MINUTE(B2:B11)+(SECOND(B2:B11)>0)) ¼ÆËã½ñÌìÊÇÐÇÆÚ¼¸:=WEEKDAY(NOW(),2)

»ã×ÜÐÇÆÚÈÕµÄÖ§³ö½ð¶î:{=SUM((WEEKDAY(A2:A11,2)=7)*(B2:B11=\Ö§³ö\ »ã×ܵÚÒ»¸öÐÇÆڵijö¿âÊý

Á¿:{=SUM(OFFSET(A2,,MIN(IF(WEEKDAY(B1:P1,2)=1,COLUMN(B:P))),,7))}

¼ÆËãÿÈÕ¹¤Ê±¹¤

ÔÂ

×Ê:=8*5*IF(WEEKDAY(A2,2)<6,1,1.5)+(B2-8)*5*1.5 ¼ÆËãÖ¸¶¨ÈÕÆÚËùÔÚÔ·ÝÓм¸¸öÐÇÆÚ

ÈÕ:{=SUM(N(WEEKDAY(DATE(YEAR(A2),MONTH(A2),ROW(INDIRECT(\1))} °´ÖÜ»ã×ܲú

Á¿:{=SUM(((WEEKDAY($B1,2)-WEEKDAY($B1:$AF1,2))+(COLUMN($B1:$AF1)-1)=(1+(COLUMN(A1)-1)*7))*$B2:$AF2)}

°´ ÖÜ»ã×ܽø²ÖÓë³ö²ÖÊýÁ¿:

{=SUM(((WEEKDAY($B1,2)-WEEKDAY($B1:$BK1,2))+INT((COLUMN($B1:$BK1))/2)=(1+(INT((COLUMN(A1)+1)/2)-1)*7))*$B3:$BK3*($B2:$BK2=B7))} ÂÞ Áб¾ÔÂÐÝÏ¢ÈÕ:

{=IFERROR(SMALL(IF(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),ROW(INDIRECT(\ONTH(NOW(),0))))),2)=2,DATE(YEAR(NOW()),MONTH(NOW()),ROW(INDIRECT(\NOW(),0)))))),ROW()),\ ¼ÆËãÖÜÄ©½±½ð²¹

Ìù:=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(B2&\ÂÞÁÐÖµ°àÈÕ

ÆÚ:{=MIN(IF(WEEKDAY(DATE(2008,ROW(),ROW($1:$31)),2)=7,DATE(2008,ROW(),ROW($1:$31))))} ¼Æ Ëã±¾Ô¼Ӱàʱ¼ä:

{=SUM((MOD(MOD(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),ROW(INDIRECT(\ONTH(NOW(),0))))),2),7),2)={1,0})*{3,2})} ½ñÌìÊDZ¾Äê¶ÈµÚ¼¸ÖÜ:=WEEKNUM(TODAY())

±¾Ô°üÀ¨¶àÉÙÖÜ:=WEEKNUM(EOMONTH(NOW(),0),2)-WEEKNUM((EOMONTH(NOW(),-1)+1),2)+1 ÂÞ ÁеÚ30ÖÜÈÕÆÚ:

{=TEXT(SMALL(IF(WEEKNUM(DATE(YEAR(NOW()),1,ROW($1:$366)),2)=30,DATE(YEAR(NOW()),1,ROW($1:$366))),ROW(A1)),\ ͳ¼ÆijÔµÚËÄÖܵÄÖ§³ö½ð

¶î:{=SUM((WEEKNUM(A2:A11*1,1)-WEEKNUM(YEAR(A2:A11)&\1)}

ÅÐ ¶Ï±¾ÔÂÐÝÏ¢ÈÕ:{=(SUM(N(WEEKNUM(ROW((INDIRECT((EOMONTH(NOW(),-1)+1)&\ EOMONTH(NOW(),0)))),2)-WEEKNUM(EOMONTH(NOW(),-1)+1,2)+1=5))>3)+4} ¼ÆËãÀëÖ°ÈÕÆÚ:=WORKDAY(A2,5,{\

¼ÆË㹤³ÌÍ깤ÈÕÆÚ:{=WORKDAY(A2,B2,EOMONTH(A2,ROW(INDIRECT(\ ¼ÆËã2008ÄêµÚÒ»¼¾¶ÈÓжàÉÙ¸ö¹¤×÷