Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

Excel Search Function

Hello

I am looking for an Excel function that will return the number of different instances of a specific label in a column

Example:

COLUMN A
33D
33D
33D
33D
R4R
5AZE
5AZE
TTET
TTET
TTET
,,,
,,,

Will return something that will help me know thaT
33D = 4 times
R4R= 1 time
5AZE = 2 times
TTET=3 times
and so on...

Thank you for your help
0
gadsad
Asked:
gadsad
  • 2
  • 2
1 Solution
 
slubekCommented:
Use COUNTIF() function. Example in attached file.
t4.xlsx
0
 
gadsadAuthor Commented:
thank you but I may have explained wrongly

The problem is that I have 15000 lines in column A, without knowing the exact content to manually build column D and I want precisely to generate automatically column D  !

Column D will be (like in your sheet) same content as column A but only ONE TIME every unique instance

How to generate automatically column D?

Thank you
0
 
slubekCommented:
If you want to automatically generate count column, use pivot table (see example).
t4.xlsx
0
 
gadsadAuthor Commented:
perfect
Thank you
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now