Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default totalling dates

On Feb 23, 6:28 pm, Gary''s Student
wrote:
Lets say we have a list of dates in column A. In an unused column enter:
=COUNTIF(A:A,A1)
and copy down. This helper column will tell you how many times each date
apears in column A.

You can also use this formula in Conditional formatting.

--
Gary's Student
gsnu200707

"manish" wrote:
Hi All,


How could i count the number of identical dates in a column ?


Thanks in advance.


Rgds,
Msh.


Thanks gary and darlove .. both of you solved my problem . Thanks a
lot.

Reply
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
Totalling Colum [email protected][_2_] New Users to Excel 2 June 3rd 08 11:02 AM
My SUM function is totalling to 0 tom Excel Worksheet Functions 1 January 19th 07 08:20 PM
Totalling volumes per box Brian Excel Worksheet Functions 5 December 6th 06 06:40 PM
Sub totalling in VBA Peter Excel Programming 1 September 9th 06 06:18 PM
totalling enyaw Excel Discussion (Misc queries) 1 May 9th 06 08:19 PM


All times are GMT +1. The time now is 11:55 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"