find out Max Repeated Text Name in Rows

[ilayaraja]

Hi,

Required Excel formula Maximum Repeated Text Name in Single Rows (different cell)



Email Social Email Email Social Email Social Referral Email Referral Email Email


thanks,

 

[Somendra Misra]

Hi,

Considering your values in A1:L1, you below formula

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

Regards,

 

[Faseeh]

Please try this, your data is in first row with CSE:

=LOOKUP(MAX(COUNTIF(A1:L1,A1:L1)),COUNTIF(A1:L1,A1:L1),A1:L1)

 

[ilayaraja]

thanks Guys

this works...