SOLVED

I need to count repeated values

Occasional Visitor

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

 

 

 

1 Reply
best response confirmed by JimGMac (MVP)
Solution

@Lakshman5 

S1659.png

The formula in E2 is

=COUNTIF($A$2:$A$8,"*"&D2&"*")

This can be filled down.

www.000webhost.com