LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default counting repeat numbers in a column

I have a spread sheet with two columns:

Date St. No.
4/10/06 1452
5/13/06 1339
5/22/06 3538
6/1/06 1452
6/9/06 305

In this example, I have two number 1452, however, my spread sheet contains
about 2000 data with numbers ranging from single digits to 5 digits. How can
I have Excel count all of the repeating numbers and providing me the answer.
I dont want to sort the data because of other issues.

Thanks for any comments.

--
Lowell Shoaf
Realtor
RE/MAX Gulfstream Realty
Sarasota, Florida
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting groups of exact numbers in a huge list (column) pgiessler Excel Discussion (Misc queries) 1 August 16th 06 05:00 PM
Can Excel pick random numbers from 1-300 and not repeat numbers? Julian Excel Discussion (Misc queries) 1 June 7th 06 07:17 AM
counting only specific numbers in column Alex C Excel Worksheet Functions 2 May 25th 05 08:32 PM
Counting NUMBERS &/or TEXT from a column to other sheet ? Trixie Excel Worksheet Functions 4 March 3rd 05 07:59 PM
Counting numbers in a column without including others kim11757 Excel Worksheet Functions 1 January 6th 05 10:14 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"