Excel Forum
Similar Content
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Macro: This Excel macro filters data in Excel without the filter "arrow" appearing in the column ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dups


Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to Count 1 For Each Item in List 1 That Is In List 2 -- No Double Count for Duplicates. There are multiple criteria for counting, but we need a 1 even when there are duplicates in List.





Got a Question? Ask it Here in the Forum.