Hi guys, I am rather noob in excel so pardon me if my request seems a bit easy.
So for example, i have the data set below, how do i sum the frequencies of the duplicated words? I cant do it manually because my data sets are quite large
so ie end result should be like
abdul 2
able 2
..
accounts 5
..
Words Freq
abdul 1
abdul 1
able 1
able 1
about 1
about 1
abu 1
abu 2
accounts 2
accounts 3
achieved 1
achieved 1
achievement 5
achievement 1
acquiring 1
acquiring 1
activities 3
activities 1
activities 3
activities 1
address 10
address 3
address 1
address 1
address 2
address 1
administration 3
administration 1
administration 2
advertising 1
advertising 1
advising 1
advising 2
age 2
age 1
age 1
agri 1
agri 1
agricultural 1
agricultural 19
agricultural 5
agricultural 3
agricultural 15
agriculture 2
agriculture 1
agriculture 1
agriculture 5
agriculture 5
agriculture 2
agriculture 22
agronomic 1
agronomic 2
agronomist 1
agronomist 1
agronomy 1
agronomy 7
all 2
all 5
all 1
all 5
along 1
along 1
also 1
also 1
analysis 3
analysis 1
analysis 1
application 2
application 8
application 2
application 2
applying 1
applying 1
aqua 2
aqua 1
area 4
area 9
area 3
asia 4
asia 1
asian 2
asian 20
assigned 2
assigned 1
assist 1
assist 1
associations 3
associations 1
attainment 1
attainment 1
attractive 1
attractive 1
availability 1
availability 1
available 1
available 2
avenue 1
avenue 2
awareness 1
awareness 1
bachelor 2
bachelor 1
bachelor 2
bachelor 2
background 1
background 1
base 1
base 1
base 1
basic 1
basic 1
basic 1
being 1
being 2
below 1
below 1
benefits 1
benefits 1
best 1
best 1
between 1
between 1
bhd 6
bhd 2
biological 1
biological 3
birth 2
birth 1
birth 1
birth 1
birth 1
board 2
board 2
board 1
box 3
box 4
box 1
box 1
budgets 1
budgets 2
build 1
build 1
building 1
building 2
building 2
business 21
business 1
business 2
business 3
business 1
business 1
buying 1
buying 1
cabbage 1
cabbage 1
camps 3
camps 1
can 2
can 1
career 1
career 1
cauliflower 1
cauliflower 1
center 1
center 4
center 6
central 1
central 2
centre 1
centre 1
centre 1
centre 1
centre 4
chain 1
chain 1
challenges 1
challenges 1
challenges 1
charge 6
charge 1
chemical 1
chemical 1
chief 1
chief 2
chief 1
chinese 1
chinese 16
choice 1
choice 1
city 3
city 2
city 2
city 1
civil 1
civil 1
class 4
class 1
clients 1
clients 1
college 2
college 1
com 1
com 1
com 2
com 3
com 1
com 1
com 1
com 3
commercial 1
commercial 1
commercial 1
commodities 1
commodities 2
community 1
community 1
companies 1
companies 2
company 3
company 3
company 4
company 9
company 3
complaints 1
complaints 1
computer 1
computer 1
computer 1
computer 1
concept 1
concept 1
conducting 1
conducting 1
conducting 1
conference 1
conference 5
consideration 1
consideration 1
consideration 1
contact 2
contact 1
contact 1
contract 2
contract 2
contribute 1
contribute 1
control 1
control 1
control 3
control 2
cooperative 2
cooperative 1
coordinate 2
coordinate 1
coordinating 3
coordinating 1
coordinating 1
coordination 1
coordination 1
corn 2
corn 1
cost 4
cost 1
course 2
course 1
course 2
create 2
create 7
creative 2
creative 1
credit 1
credit 1
cristo 3
cristo 2
crop 1
crop 3
crop 2
crop 1
crop 15
crops 1
crops 1
crops 5
crops 3
crops 5
cultivating 1
cultivating 3
cultivation 3
cultivation 9
culture 4
culture 1
current 1
current 1
currently 1
currently 1
curriculum 1
curriculum 1
curriculum 1
customer 4
customer 5
customer 1
customer 2
customers 2
customers 2
daily 1
daily 1
dairy 1
dairy 6
dairy 1
dairy 1
data 1
data 1
data 2
date 1
date 1
date 2
date 3
date 1
date 1
day 2
day 2
dealers 1
dealers 1
dec 1
dec 1
dec 1
dec 1
december 1
december 1
december 1
degree 5
degree 2
department 3
department 3
department 4
deputy 3
deputy 1
design 1
design 1
designing 2
designing 1
designing 6
designing 1
details 1
details 1
details 1
details 1
develop 1
develop 1
develop 1
develop 1
developing 5
developing 16
development 12
development 4
development 1
development 4
development 10
development 1
development 2
development 23
dhabi 1
dhabi 2
diploma 1
diploma 1
diploma 1
direct 1
direct 2
director 1
director 2
director 4
director 4
disease 1
disease 1
distribution 2
distribution 1
distributors 1
distributors 1
district 2
district 1
district 1
division 4
division 2
division 1
division 4
drive 1
drive 1
driving 1
driving 1
duties 3
duties 6
dynamics 1
dynamics 1
east 1
east 3
east 2
economic 3
economic 3
edgardo 2
edgardo 1
education 1
education 1
education 1
education 3
education 1
education 1
educational 1
educational 1
educational 1
effective 1
effective 1
effective 1
effective 1
effectively 1
effectively 2
efficiency 1
efficiency 1
egypt 1
egypt 2
email 1
email 1
email 3
email 1
email 1
email 4
e-mail 1
e-mail 1
e-mail 1
engineering 1
engineering 2
english 2
english 1
english 1
english 1
english 1
ensuring 1
ensuring 1
environment 4
environment 1
environmental 1
environmental 1
equipment 1
equipment 1
establishing 2
establishing 5
establishment 1
establishment 2
estate 1
estate 32
etc 2
etc 1
etc 1
excel 1
excel 1
excellent 1
excellent 1
executive 2
executive 1
existing 1
existing 1
experience 1
experience 2
experience 1
experience 4
experience 1
experience 1
experience 1
experiences 2
experiences 1
expert 2
expert 1
export 1
export 1
export 3
extension 7
extension 2
extension 1
facilitating 1
facilitating 4
facilitating 1
facilities 1
facilities 1
factory 1
factory 1
faithfully 1
faithfully 1
farm 4
farm 1
farm 1
farm 12
farm 2
farm 2
farm 5
farmer 1
farmer 1
farmer 2
farmers 14
farmers 6
farmers 1
farmers 2
farming 1
farming 3
farming 2
farms 2
farms 2
fertility 6
fertility 1
fertilization 1
fertilization 1
fertilization 5
fertilizer 1
fertilizer 5
fertilizers 1
fertilizers 3
field 2
field 2
field 2
field 3
fields 1
fields 5
first 2
first 1
first 1
first 2
focus 1
focus 1
focus 1
food 1
food 8
food 2
forecasting 1
forecasting 1
four 1
four 1
fresh 1
fresh 5
fruit 1
fruit 2
fruit 1
full 1
full 1
full 1
function 1
function 6
functional 1
functional 1
funded 2
funded 1
funding 1
funding 1
gather 1
gather 1
general 1
general 3
get 1
get 2
ghana 6
ghana 3
global 3
global 1
global 3
gmail 1
gmail 1
goals 1
goals 1
good 1
good 1
good 1
good 3
good 1
grade 1
grade 1
green 3
green 1
Bookmarks