Help

Re: Formula to find and label duplicated (question bank)

666 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Musaab_R
5 - Automation Enthusiast
5 - Automation Enthusiast

Screen Shot 2023-03-08 at 9.59.33 AM.png

Hi

I've more than 10,000 questions and counting, and many questions added daily, the issue is finding and labeling then deleting the duplicate, duplicate are not exactly unique same question written with similar words but different context , and sometimes exactly the same but with extra word.

i used the 2 duplicate extensions and it is very useful but it need too much manual work (see attachment )

so my question, what Formula can i use to label any question in separate column and flag the question as duplicate and linking the duplicate form with lookup/rollup, so i could ? 

i wish the result to be like that .

 

Screen Shot 2023-03-08 at 10.21.16 AM.png

thank you , i will really appreciate your answers.

1 Reply 1
Musaab_R
5 - Automation Enthusiast
5 - Automation Enthusiast

anyone ?