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: 14
Default Need a formula to count dates

I have a spradsheet in Excel 2007 that contains a list of company names,
course names, delegate names and dates that they attended courses.

I need to do a count of the courses but can not figure out how to do it.
there are lots of dates that are the same and lots of names that are the same
so i want it to count them only if they are different which is why i though
the date would be better to work on

Not sure if this makes any sense. Let me know if you need more info
--
Thank you for reading my post. Hopefully you can answer my querie
 
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
Formula to count no. of months between 2 dates Melissa Excel Discussion (Misc queries) 5 March 23rd 10 09:18 AM
Sum if or Count if with dates or any other formula that would work Jeremy Excel Discussion (Misc queries) 1 April 27th 08 08:21 PM
Formula to count cells between dates. Vegs Excel Worksheet Functions 4 June 12th 06 06:56 PM
Formula that will count between dates ranges jbsand1001 Excel Worksheet Functions 4 April 1st 05 11:41 PM
Formula that will count between dates ranges jbsand1001 Excel Worksheet Functions 0 March 7th 05 06:41 PM


All times are GMT +1. The time now is 01:17 PM.

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

About Us

"It's about Microsoft Excel"