Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Unhappy Date Frequency

Can someone help with this one. I have a list of dates in column G.

G
1/15/12
1/15/12
1/15/12 frequency for 1/15/12 should be here (i.e. 3)
1/16/12
1/16/12 frequency for 1/16/12 should be here (i.e. 2)
1/17/12
1/17/12
1/17/12
1/17/12

Each date occurs a mutiple number of times. I have sorted the data to show the oldest date at the top and the newest date on the bottom. I want a fuction that calculates the frequency of each date in the adjucent column, F, and possibly put the frequency of each date in the cell adjucent to where each date ends. I used =COUNTIF(G:G,"11/15/12"). It works but I have to go to the end of each date and change the criteria.

Thank you

Last edited by Mukayi : January 18th 12 at 01:33 PM
 
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
Frequency of date PAL Excel Worksheet Functions 4 November 30th 09 06:28 AM
frequency leslie Excel Worksheet Functions 2 June 24th 07 01:39 AM
histograms - frequency and relative frequency? confusedstudent Excel Discussion (Misc queries) 2 February 8th 06 08:20 AM
how do get the frequency Hi Excel Worksheet Functions 1 December 7th 05 02:50 PM
Frequency within date range cursednomore Excel Worksheet Functions 2 September 12th 05 08:44 PM


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