LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Using count function for multiple columns

I have a spreadsheet with style numbers and colors sold over a period. for eg
A B
DN012 red
DJ111 White
TS442 BLue
DN012 Black
DR123 red
DJ111 Blue
Now i want to count the number of colors for each style. as in for DN012
there are two colors sold. How can i do it ??
 
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
Filter Multiple Columns on Multiple Criteria and count the last co LBitler Excel Worksheet Functions 2 February 12th 09 08:36 PM
To count the data using multiple criteria in multiple columns Rajesh New Users to Excel 5 December 15th 08 04:07 PM
Count Using Multiple Columns karen Excel Discussion (Misc queries) 4 October 29th 07 07:19 PM
Count if Multiple columns Dean Excel Worksheet Functions 2 January 16th 06 12:53 PM
Count on multiple columns Emece Excel Worksheet Functions 2 March 4th 05 02:52 PM


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