excel计算星座公式一：B2单元格输入公式，然后下拉复制公式即可。公式：=LOOKUP(--TEXT(A2,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"...

公式：[=vlookup(值(‘ 1900-‘文本(mid (a2，len (a2)/22，4)，’ #-# # ‘))，{1，’摩羯座’；20、水瓶座；50，“双鱼座”；81，“白羊座”；111，“金牛座”；142，“双子座”；174，“癌症”；205，“狮子座”；236，“处女座”；267，“天秤座”；298，“天蝎座”；328，...

用日期结果生成星座函数公式：【=LOOKUP(--TEXT(C2,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})】   直...

区分公式如下：在C10单元格输入以下公式，然后向下填充公式：=LOOKUP(--TEXT(A10,"mdd"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})...

公式如下 =IF(LEN(A2)=18,CHOOSE(MATCH(TRUE,MID(A2,11,2)&"月"&MID(A2,13,2)&"日">={"12月22日","11月22日","10月23日","09月23日","08月23日","07月23日","06月22日","05月21日","04月21日","03月21日","02月19日","01月20日"},),"摩羯座","射手...

设身份证号在C列C2开始 ，请在D2输入公式：=LOOKUP(--TEXT(C2,"mdd"),{101,"摩羯座";120,"水平座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})。下拉填充。

用countif计算每个星座的个数即可。假定星座写在c列，添加两个辅助列d列和e列，在辅助列d列输入12个星座，在e1输入公式：=cuontif(c:c,d1)公式下拉到e12,用e列的数值除以40作为图表的引用源数据。

{"1/21","2/20","3/21","4/21","5/22","6/22","7/23","8/22","9/24","10/24","11/23","12/23"},{"水瓶","双鱼","牧羊","金牛","双子","巨蟹","狮子","处女","天秤","天蝎","射手","摩羯"}&"座")。比如下面公式 =IF(ISNA(VLOOKUP(B5,sheet1!$B$2:$E...

｛｝表示里面的数据为数组。

---按你贴的图 B12公式:=VLOOKUP(B7&TEXT(B8,"00"),$L$2:$M$14,2,1)