<參考檔>:
http://www.funp.net/359467
前一參照區第1格(F1)空白,公式顯示0(不顯示)!
=IF(INDEX(Area2,1)="",0,F3*ISNA(RANK(F3,Area2)))
INDEX(Area2,1) 為F1
INDEX(Area2,2) 為G1..類推!
若要6格都有數字,才顯示:
=IF(COUNT(Area2)=6,F3*ISNA(RANK(F3,Area2)),0)
This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html