Please try at B2 drag down to B7
=COUNTIF('journals 2018'!A:A,A2&"*")
For Etc B8
=COUNTA('journals 2018'!A:A)-SUM(B2:B7)-1
Please try at B2 drag down to B7
=COUNTIF('journals 2018'!A:A,A2&"*")
For Etc B8
=COUNTA('journals 2018'!A:A)-SUM(B2:B7)-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks