LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
WD WD is offline
external usenet poster
 
Posts: 12
Default formula to count formatted result value

In column A enter the date and in B a formula copies A1 reformated as day
(dddd).
How can I count the results of colums "B" (number of times each day appears)?
Col A Col B
1/1/10 9:13 PM Friday
1/3/10 3:25 PM Sunday

 
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
Formatted Result from an IF function Sri Harsha[_2_] Excel Worksheet Functions 3 September 15th 09 09:01 PM
Count if within conditional formatted cells kmaki Excel Worksheet Functions 12 June 13th 08 01:06 PM
Formula to count number of time stamps within a range in a column having dates formatted as "custom" Sam Excel Discussion (Misc queries) 3 June 19th 07 12:33 AM
Formula to lookup Multiple Column Text and then Count Result ShelbyMan Excel Worksheet Functions 2 August 22nd 05 01:43 AM
reference the result of a formula in a text formatted cell jpwinston Excel Discussion (Misc queries) 1 February 7th 05 05:33 PM


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