excel - Show all unique elements in a list and how many times they appeared -

i trying make formula return me list of unique elements in list , how many times each appeared. can't predict going added list, list of strings.

example:

car car bike car bus bus 

would result in:

bike 1 bus 2 car 3 

thanks!

create unique list, paste below formula c2 , enter array formula, ctrl+shift+enter. drag down copy.

=index($a$2:$a$7, match(0, countif($c$1:c1, $a$2:$a$7), 0)) 

then use countif, paste d2, drag down copy:

=countif($a$2:$a$7,c2)