Aug 12 2022 03:28 AM
Hello Everyone,
Kindly help me to solve this . Consider these are the values present in table (in excel)
Names | PIA Names PIA
---------------------------------- ----------------------------------
workday 562 workday 2
DocuSign 345 DocuSign 2
OneTrust 2
OneTrust 556-------------------------------->
Microsoft 345
Workday 444
DocuSign Application 345
OneTrust Emergency 456
Consider this is an excel sheet. I want to to find the count of repetitive values present in sheet. Here
I want Work day as 2 there are repeatative. For DocuSign count is 2 because DocuSign is present in word DocuSign Application , so its count is 2. Similarly for onetrust also there is 2 .
Kindly help me to get this type of output
Aug 12 2022 03:39 AM
SolutionAug 12 2022 03:39 AM
Solution
The formula in E2 is
=COUNTIF($A$2:$A$8,"*"&D2&"*")
This can be filled down.