Question

A

aroraaj

Board Regular
Joined
Jan 14, 2009
Messages
61
Office Version
  1. 365
Platform
  1. MacOS
I have a excel sheet and one of the column has list of suppliers. For example:

NBT
NBPC
NBT
ESO
ECO

I need a formula that will count how many suppliers are there and I don't want it to double count the ones that are already listed. For example there are two ESO and two NBT I only want that to count once. Is there a way to do that?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Try this

=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))

Note, the ranges cannot be entire column refs like A:A, must use row #s like A1:A1000
Unless in xl2007

Hope that helps..
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Dynamic Data Validation list without dispersed blanks
Replies
7
Views
408
julhs
J
B
  • Solved
Dynamic dropdown list based on filtered table
Replies
4
Views
573
Georgiboy
Georgiboy
M
  • Solved
Can I use a Dropdown box with a COUNTIF formula?
Replies
8
Views
1K
etaf
etaf
K
  • Question
How do I set up this count?
2 3
Replies
20
Views
894
Fluff
Fluff
R
  • Solved
Count unique/total entries based on multiple criteria
Replies
3
Views
267
duggie33
D

Forum statistics

Threads
1,215,603
Messages
6,125,786
Members
449,259
Latest member
rehanahmadawan

Share this page

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