<div>
The current MAX function will only evaluate the max NUMERICAL values given.<br><br>It could work if you made a helper column (or in your case maybe a helper row) that evaluates the string into days in numericals. Use your MAX function on that row.
</div>


The current MAX function will only evaluate the max NUMERICAL values given.

It could work if you made a helper column (or in your case maybe a helper row) that evaluates the string into days in numericals. Use your MAX function on that row.

Newton

<div>
Hi Kimputer,<br>Thanks for your feedback. Noted your point.<br><br>Thanks
</div>


Hi Kimputer,
Thanks for your feedback. Noted your point.

Thanks

<div>
<div class="content wysiwyg-content fr-view">
Hi,<br><br>In excel I know we can use max function but if the column data is concat of string and number then how can I use the max function ?<br><br>For example,<br><br>Column A, Column B, Column C<br>1Y10, &nbsp; &nbsp; &nbsp; &nbsp; 2Y10M, &nbsp; &nbsp; 10Y9M2D<br><br>Y stands for years, M stands for month and D stands for Days. Max of column A, B and C is 10Y9M2D.. can we use max function in such scenarios ?<br><br>
</div>
</div>



Hi,
In excel I know we can use max function but if the column data is concat of string and number then how can I use the max function ?
For example,
Column A, Column B, Column C
1Y10,         2Y10M,     10Y9M2D
Y stands for years, M stands for month and D stands for Days. Max of column A, B and C is 10Y9M2D.. can we use max function in such scenarios ?

Excel max function

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.