This isn't showing the "After" example as requested.
What this means is:
"Show us what you want the result to look like"
Do you want to know the DATE of the latest version?
If so, you can create a column with the formula for row 4:
=MAX(E4:N4)
that would give you the most recent date.
If you're wanting the "Rev #", then you could use something like:
=INDIRECT("R3C"&MATCH(MAX(E4:N4),E4:N4)+4,FALSE)
Paul
-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
________________________________
From: Rohan Young <rohan.j...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Mon, September 26, 2011 3:18:27 AM
Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
On Thu, Sep 22, 2011 at 6:04 PM, dguillett1 <dguille...@gmail.com> wrote:
> Can you provide an AFTER example
>
> -----Original Message----- From: Rohan Young
> Sent: Thursday, September 22, 2011 2:30 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> ---------- Forwarded message ----------
> From: Rohan Young <rohan.j...@gmail.com>
> Date: Tue, Jul 26, 2011 at 2:22 PM
> Subject: Required Latest No. of Drawing - Help
> To: excel-macros@googlegroups.com
>
>
> Dear Experts
>
> I want to make a list drawing in which i required only latest revision
> of drawings it can be R3, R5, i need only latest version rest of
> previous i do not required in that list please help me out with any
> formula or vba code (see attachment)
>
> Thanks & Regds,
>
> --
>----------------------------------------------------------------------------------
>-
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
> --
>----------------------------------------------------------------------------------
>-
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
