| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Data
I have a list of data that can have the same value. How can i count the
number of similarities and get it to display the result in the next row. For example:- BOTTLE_CHK-2707 BOTTLE_CHK-2707 CALSOLUT-0563 DEF-ESTATE-2088 DEF-ESTATE-2088 EDEN_DC-2682 ELS_LTD-2450 ELS_LTD-2450 ESSEXCRP ESSEXCRP ESSEXCRP HARDING_EN-2558 Thanks in advance |
|
#2
|
|||
|
|||
|
=SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&""))
change the A20 to wherever your data ends. -- HTH Bob Phillips "dave" wrote in message ... I have a list of data that can have the same value. How can i count the number of similarities and get it to display the result in the next row. For example:- BOTTLE_CHK-2707 BOTTLE_CHK-2707 CALSOLUT-0563 DEF-ESTATE-2088 DEF-ESTATE-2088 EDEN_DC-2682 ELS_LTD-2450 ELS_LTD-2450 ESSEXCRP ESSEXCRP ESSEXCRP HARDING_EN-2558 Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Counting data - 1 last question | New Users to Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
