Find repeating Text

[Thiyagu]

Anyone got idea to find repeating text and no ,,example 120KSV.
If for no i can use function mode() , but it's not work for text and no together.Example 120KSV.

Pls help

 

[Aladin Akyurek]

Anyone got idea to find repeating text and no ,,example 120KSV.
If for no i can use function mode() , but it's not work for text and no together.Example 120KSV.

Pls help

If

120KSV

is an example/sample, what is the expected outcome?

 

[Bill Rockenbach]

Please post sample of text to parse out repeating text. Is it a column of data, multiple columns, etc. ?

How do you want to identify repeating text, highlight, post to another column, etc?

You can use the filter to filter out repeat text.

Need more info.

 

[Thiyagu]

example

120ksv 310
120ksv 310
140ksv 305

If i use mode function for no the result is 310 , but for the text & no
the resullt is NA ..i Want to have system show 120ksv.

 

[T. Valko]

If you want to find the most occuring TEXT entry try this array formula**:

=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))

** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

Assumes no empty cells. Also note, it works just like the MODE function does for numbers. If there is more than one instance of a mode the formula will return the first instance. If there is no mode you'll get an error.

 

[Bill Rockenbach]

Assume list starts in cell A2. Put this formula in cell B2 and Copy down

=IF(COUNTIF(A$2:A2,A2)>1,A2,"")

 

[Thiyagu]

Thanks for the help. Now this problem solve after follow the instruction from u all.

 

[Bill Rockenbach]

What solution did yopu use?

 

[Thiyagu]

Both solution also work fine.
Thanks for u all for the great support