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

1. ## 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  Register To Reply

2. ## Re: How to find the largest value in column T then paste into Cell

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))  Register To Reply

3. ## Re: How to find the largest value in column T then paste into Cell

In Vba something like. ``Please Login or Register  to view this content.``  Register To Reply

4. ## Re: How to find the largest value in column T then paste into Cell

@Richard Buttrey: Thank you for your information.
@Harry: The code works.

Thank you very much for your time and help.

Regards,
tt3  Register To Reply