No. of different cells (numbers)

  • Thread starter Thread starter lefty
  • Start date Start date
L

lefty

Hello,

I have a problem to find the way how to count different cells. Fo
example in the column below

25871
25698
42587
42365
25871
25871
25698

the result of the formul would be 4. Can anyone help me?

Thanks
 
Hi
if your data is in column A try
=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Function 3
Count in a range of numbers 8
Excel Need Countifs Formula Help 0
Count Unique Cells, within a date range (dates stored in separatecolumn). 3
Count multiple rows with vlookup 3
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
How do I use "column" function to get the column number of the firstcell matching criteria? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top