View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
megz12 megz12 is offline
external usenet poster
 
Posts: 2
Default count unique fields

In a row I have 4 to 5 unique fields, that can appear in more than 1 column.
I have a function to count all the text fields but I would like them
separated into unique counts.

Exp: blue red green red red blue green green = how many red, how many
green, etc. I would like each result in a different cell.

Thanks I am sure this is simple, but it doesn't seem to be working out.