View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anayray
 
Posts: n/a
Default Is there a way to tally 3 different values in one column?

Is there a way to pull the tally of 3 different values and have the tally
posted to a diffrernt column. Example: One colum has 16 ones 63 twos and 97
threes, but this inforamtion is listed sorted within one column. I do not
want to sort, as it will alter my input dates. is there a formula where I can
extract the total tally of each indvidual number 1, 2, 3, and have that tally
in a different feild?