View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Counting cells with multiple data

Hi folks,

I'm tracking game data for a few players and am running into a problem. On
doing a web query, column D will show the following data below. Here are
four cells of those 50. I'm trying to count the # of 1st, # of 2nd & # of
3rds.

I've used countif, count a, and several other formulas and get a 0 result.

I know it's probably a very simple formula, but I'm stumped.

3rd of 8
2nd of 8
1st of 6
3rd of 5
3rd of 11


Thanks for any help.

Thanks, Bob