Hi
its a bit long, but you can do this with a formula if you like - try this in cell C2 and copied to the cells below
=Sheet1!A$2&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$2),"")))/LEN(Sheet1!A$2)&CHAR(10)
&Sheet1!A$3&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$3),"")))/LEN(Sheet1!A$3)&CHAR(10)
&Sheet1!A$4&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$4),"")))/LEN(Sheet1!A$4)&CHAR(10)
&Sheet1!A$5&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$5),"")))/LEN(Sheet1!A$5)&CHAR(10)
&Sheet1!A$6&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$6),"")))/LEN(Sheet1!A$6)&CHAR(10)
&Sheet1!A$7&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$7),"")))/LEN(Sheet1!A$7)&CHAR(10)
&Sheet1!A$8&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$8),"")))/LEN(Sheet1!A$8)&CHAR(10)
&Sheet1!A$9&", count: "&(LEN(B2)-LEN(SUBSTITUTE(LOWER(B2),LOWER(Sheet1!A$9),"")))/LEN(Sheet1!A$9)
Bookmarks