Erlandsen Data Consulting » Blog Archive » How to count unique values

How to count unique values

Posted on 2000-08-08, 00:23, by OPE, under Count.

This workbook uses a custom function to return the count of equal values in two different ranges. The function counts matches regardless of the position in the range. You will also find a function that counts the matches according to the position in the range.

Click here to download this file.
Updated: 2000-08-08 & 2012-04-11 Requires: XL5 File size: 29 kB

Tags: unique
| Trackback

Search for:
Categories
- Functions (55)
  - Count (5)
  - Dates (7)
  - Lookup (3)
  - Other (15)
  - Strings (4)
  - Sum (7)
  - Time (6)
- Games (8)
- Help (4)
- Off topic (1)
- Problem Solving (7)
- Read Me (3)
- Tools (17)
- VBA Programming (213)
  - Addins (5)
  - ADO (9)
  - Application (15)
  - Charts (12)
  - Commandbars (21)
  - Dialogs (20)
  - Events (8)
  - File Access (9)
  - Files & Folders (17)
  - Import & Export (28)
  - Printing (10)
  - VBE (14)
  - Workbooks (20)
  - Worksheets (27)
Archives