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: 9
Default count of different type records

hi,

are there any way to count that how many different type of records are in a
column? for example, in column A are 6 times a210, 8 times a240 and 3 times
g450. in this case i have three types of record, but i have a little bit
bigger database and i would like to know how many types of record are in it.
i wonder that there could be something like countif or else but i have no
idea at the moment

thx in advance
 
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
Count unique records... with a twist... Need help! [email protected] Excel Worksheet Functions 4 August 3rd 06 06:17 PM
Need formula to count spinoffs jamescarvin Excel Worksheet Functions 1 July 14th 06 04:07 PM
count of records with 2 or more "options" selected Monish Excel Worksheet Functions 1 October 23rd 05 03:10 AM
Select rows and sort based on type Sarah Excel Discussion (Misc queries) 0 October 11th 05 05:06 PM
Formula for If Term is on Certain Date then Count Krisjhn Excel Worksheet Functions 3 August 30th 05 07:57 PM


All times are GMT +1. The time now is 12:18 AM.

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"