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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks