View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jojik jojik is offline
external usenet poster
 
Posts: 9
Default to find the repetitve text from a column.

JANUARY -44
JUNE - 20
FEBRUARY - 37
DECEMBER - 56
JUNE - 96
JUNE - 56
SEPTEMBER - 46
OCTOBER - 15
NOVEMBER - 87
DECEMBER - 66
DECEMBER - 12

dear All, i have this data in 2 columns and I want to show automatically in
one cell as 'december' and in the next cell the total of december (134).
please help me to sort out this. thanks in advance.