Count Formula, Ignore Counting Duplicates

Ottsel

Board Regular
Joined
Jun 4, 2022
Messages
174
Office Version
  1. 365
Platform
  1. Windows
Tried to search around to find a solution for this, but perhaps I'm not phrasing it correctly.

Below is a table of numbers. I want to count each one, but not twice. So, with this example I need the result to give me 11.

Employee List.xlsx
F
2101
3101
4101
5101
6101
7101
8101
9101
10101
11101
12101
13101
14101
15101
16101
17101
18101
19101
20101
21101
22101
23112
24112
25113
26113
27114
28115
29115
30115
31115
32115
33116
34116
35117
36117
37117
38117
39117
40117
41118
42118
43118
44118
45118
46119
47119
48119
49120
50120
51122
Sheet1
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Kept playing around with formulas and go this to do the trick:
Excel Formula:
=SUM(1/COUNTIF(F2:F51,F2:F51))
 
Upvote 0
Solution

Forum statistics

Threads
1,223,888
Messages
6,175,213
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top