How to find the largest value in column T then paste into Cell

Hello All,
I'm looking for the code how to find the largest value in column T then paste that value into Cell "T14".
Let says:

T15 = 5 DAYS
T16 = 5 DAYS
T17 = 7 DAYS
T18 = 3 DAYs
T19 = 12 DAYS
T & Last Row

Then copy 12 DAYS to Cell "T14".

Regards,
tt3

Hi,

If each cells contains both a number and the word 'DAYS' then the simplest approach would be to create a helper column (say column U) which contains only the number and in T14 enter =MAX(U:U). U15 copied down would contain the formula =VALUE(LEFT(T15,LEN(T15)-5))

In Vba something like.

Please Login or Register  to view this content.