| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count fuction
Hi,
I am trying to find a formula that will be best for the below situation i am having. Lets say I have a data as below, I want to know how I can find the count of B for Q1B01. All the blanks I can't delet, so basically my table is set up as below. A B Q1B01 H10F001 Q1B01 H10F002 Q1B01 Q1B01 H10F003 Q1B01 H10F004 Q1B01 Q1B01 H10F005 Q1B01 Q1B01 H10F006 Q1B01 Q1B02 0905036 Q1B02 0905037 Q1B03 P005750 Q1B03 P005751 Q1B03 P005752 Q1B04 0906278 Q1B04 0906279 Q1B04 0906280 Q1B04 0906281 Q1B05 H10F007 Q1B05 H10F008 Q1B05 H10F009 Q1B05 H10F010 Q1B05 H10F011 Q1B05 H10F012 Q1B05 H10F013 Q1B05 H10F014 Q1B05 H10F015 Q1B05 Q1B05 H10F016 Q1B05 Q1B05 H10F017 Q1B05 H10F018 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need a fuction | Excel Discussion (Misc queries) | |||
| Min Fuction | Excel Worksheet Functions | |||
| if fuction | Excel Worksheet Functions | |||
| IF FUCTION | Excel Worksheet Functions | |||
| need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
Threaded Mode
