Hi,

in cell D3 on sheet 2 put this formula. Copy across and down

=(LEN(Sheet1!$C7)-LEN(SUBSTITUTE(UPPER(Sheet1!$C7),UPPER(D$2),"")))/LEN(D$2)