Excel 篩選公式:Realtime－

Blogtrottr

Mobile01最新文章

Thousands of Free eBooks

BookBub brings you free & bargain national bestselling eBooks in the genres of your choice! Sign up now & join 1.5 million happy readers.

From our sponsors

Excel 篩選公式

Jul 24th 2014, 06:44

假設欄位有id,姓名,當日狀態,舊狀態，時間（年月日時分）等，
現在笨做法，選篩選，
然後到每個欄位手動篩選，
然後再看篩選出來的數量。
再換不同篩選條件，
重複以上動作，完成統計表格。

有沒有辦法把篩選條件變成公式化，
就不用一直手動篩選統計數量。

假設篩選條件：
1 當日狀態等於某文字，且舊狀態不等於某文字，計算有幾個符合條件
2 時間為大於某年某月某日，計算有幾個符合條件

有查網路，提到進階篩選，
例如：
當日狀態舊狀態
='= 好' ='= 普通'
設為準則，
但卻不能成功，找不到任何資料。

有沒有人可以教該怎麼做？

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.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions