I
Ian P
I wonder if anyone can help me with this? Every day I
get a list of roughly 45 hotel/hostel names, many of
which reoccur in the list, so there are only about 12
different names in total. If I paste the list into
excel, can I put in a formula that will count the number
of times each hotel name occurs in the list? For example,
by placing the frequency of each name in the cell
adjacent to the name? Or by listing elsewhere on the
excel page the individual names and their frequencies of
occurence? It is very tedious at present to go through
the list manually and easy to make mistakes. Much
obliged for any help.
Ian P
get a list of roughly 45 hotel/hostel names, many of
which reoccur in the list, so there are only about 12
different names in total. If I paste the list into
excel, can I put in a formula that will count the number
of times each hotel name occurs in the list? For example,
by placing the frequency of each name in the cell
adjacent to the name? Or by listing elsewhere on the
excel page the individual names and their frequencies of
occurence? It is very tedious at present to go through
the list manually and easy to make mistakes. Much
obliged for any help.
Ian P