Check for repetition and check for first 100 words and check for first sentence

**Asdf99** · 06-30-2022, 12:36 AM

Hi I need 2 formulas,

QUESTION 1 - check for repetition:
I need to crawl from sheet 2 colomn A1 into sheet 1 B2->B8 and count how many times the keyword has been repeated in sheet 2 colomn A1

QUESTION 2 - Check first 100 words:
I need to crawl from sheet 4 colomn A1 into sheet 3 B2->B5 and count how many times the keyword has been repeated in sheet 4 colomn A1 (but only for the first 100 words)

QUESTION 3 - Check first sentence :
I need to crawl from sheet 6 colomn A1 into sheet 5 B2->B5 and count how many times the keyword has been repeated in sheet 6 colomn A1 (but only for the first sentence)

Please check attachment

THANK YOU

**AliGW** · 06-30-2022, 01:18 AM

Q1:

=(LEN(Sheet2!A$1)-LEN(SUBSTITUTE(Sheet2!A$1,A2,"")))/LEN(A2)

Q2:

=(LEN(LEFT(SUBSTITUTE(Sheet4!A$1," ","|",100),FIND("|",SUBSTITUTE(Sheet4!A$1," ","|",100))-1))-LEN(SUBSTITUTE(LEFT(SUBSTITUTE(Sheet4!A$1," ","|",100),FIND("|",SUBSTITUTE(Sheet4!A$1," ","|",100))-1),A2,"")))/LEN(A2)

Q3:

=(LEN(LEFT(Sheet6!A$1,FIND(".",Sheet6!A$1)-1))-LEN(SUBSTITUTE(LEFT(Sheet6!A$1,FIND(".",Sheet6!A$1)-1),A2,"")))/LEN(A2)

**Asdf99** · 06-30-2022, 02:31 AM

Thank you very much again !,

You are the best in this skill !

**AliGW** · 06-30-2022, 02:32 AM

Glad to have helped.

Remember that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Check for repetition and check for first 100 words and check for first sentence

LinkBack

Thread Tools

Rate This Thread

Display

Check for repetition and check for first 100 words and check for first sentence

Re: Check for repetition and check for first 100 words and check for first sentence

Re: Check for repetition and check for first 100 words and check for first sentence

Re: Check for repetition and check for first 100 words and check for first sentence

Thread Information

Users Browsing this Thread

Similar Threads

How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In

check if sentence contains number

Finding Vacancy Percentage Month Wise from Check in and Check out Date

Automatically check one or more check boxes when a parent check box is manually checked

[SOLVED] Check the same values and delete if same, sort rows in sentence

VBA to Check List of URLs -- Check if landing page renders a particular error message.

Macro to check for blank cell entry, copy previous value, and check for duplicates

Bookmarks

Bookmarks

Posting Permissions