LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Count occurances based on certain data

Given columns of data, I need to count occurances, based
on certain data.

aa 0123 red 3
ab 0125 red 3
ac 0452 blue 5
ba 0478 white 12
bb 0845 white 1
bc 0654 red 54

I need to only look at data that starts with a "b" (first
column), then I want to count how many colours (3rd
column) have numbers less than "4" (last column).

I suppose that the function should have the colour as an
argument, so when it is called it will return the number
of occurances.

Can anyone help me please.

Simon
 
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 Occurances gjameson via OfficeKB.com Excel Discussion (Misc queries) 3 January 4th 10 07:09 PM
Count occurances in data JONSPONGE Excel Discussion (Misc queries) 2 September 5th 08 01:56 PM
Count occurances Gaurav[_2_] Excel Worksheet Functions 1 April 26th 08 01:11 AM
Count of different occurances Bee Excel Discussion (Misc queries) 3 October 8th 07 03:36 AM
count occurances kevcar40 Excel Discussion (Misc queries) 3 June 13th 07 10:00 PM


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