# 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

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))

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.``

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1