Count values without putting value in formula

Closed

Clouston - Aug 11, 2010 at 07:50 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 11, 2010 at 08:06 AM

Hello,
i am trying to count if a value occurs more than once in a column in Excel
For example, if i have a column of numbers like shown below
23456
76543
23456
56453
You can see the 23456 occurs twice
How would i count that there are two without incorporating any of the numbers within the formula, so it will automatically pick up if the same number occurs. Is this possible?

Count values without putting value in formula
Number to words in excel formula without vba - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Position formula in excel - Office Software Forum
Excel grade formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 11, 2010 at 08:06 AM

So are you trying to find how many times numbers are repeated in a column ?

23456
76543
23456
56453
56453
56453

= 5 ?

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

help me to add particular cells

How to calculate position (1st,2nd,3rd) in excel....?

Counting cells containing only numbers

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!