» Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
-------------------------------------------- Dates in column A Text in Column B -------------------------------------------- 03/10/2003 | AAA 03/15/2003 | BBB 03/20/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC Question: Count how many times the text "AAA" appears next to 03/25/2003? Answer: 3 times. Date in cell D1: 03/25/2003 Text in cell D2: AAA The Formula: =SUMPRODUCT ((A1:A12=D1)*(B1:B12=D2))
Book Store:
Recommended Books:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Mortgages For Dummies®
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The Fall of Advertising and the Rise of PR
No comments have been submitted.
