Finding the maximum character length in a vertical cells

[Sekars]

Hello

Kindly refer the attached excel file.

In the light yellow cells N2:N2000 need to find the maximum character length using formula and this need to plotted in the light green cell P4.


thanks in advance

Sekar

[T.I.]

Please try.

[Fluff13]

Similar option

Please Login or Register  to view this content.

[Czeslaw]

Formula

Please Login or Register  to view this content.

[Sekars]

Thanks to all of your formulas. These formulas are helping me to avoid the manual search.

Thanks again.

[Fluff13]

Glad to help & thanks for the feedback.