Skip navigation

Using an array formula to count the number of unique items in a list

Using an array formula to count the number of unique items in a list: Excel 2016: Managing and Analyzing Data
Using an array formula to count the number of unique items in a list: Excel 2016: Managing and Analyzing Data

Excel doesn't have a function that counts the number of unique entries in a range, but if you want to count the number of unique entries in the range B2:B900, use this array formula: =SUM(1/COUNTIF(B2:B900,B2:B900)) and then press Ctrl+Shift+Enter. This formula will not work if there are any empty cells in the range.

  • Overview
  • Transcript
  • View Offline
Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
89,438
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now