hi excelers,
I need a simple solution to return any words which appears more than once i.e.
list A1:
cat
boy
lake
cat
=
lake
cat
thanks for any help on this matter...
hi excelers,
I need a simple solution to return any words which appears more than once i.e.
list A1:
cat
boy
lake
cat
=
lake
cat
thanks for any help on this matter...
In B1 enter..
![]()
=countif(a1:a5,a1 then PRES CRTL SHIFT and ENTER , enter it as an array. drag down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks