Well.. the =max() function will work to get the DATE,
but using the match() function with the multi-row produces an error.
So, I think we need to add a column (that could be hidden) to check multiple
rows.
But, if the highlighting of PREVIOUS cells is an absolute requirement, then we
might as well do the whole thing in a macro.
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: Tue, September 27, 2011 8:25:47 AM
Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
Hi Paul,
thanks for your help, and yes i required the latest date i.e. 22-Mar-11.
On Tue, Sep 27, 2011 at 5:41 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
> As I mentioned before,
> =MAX(F4:O4)
> will give you the maximum date.
>
> =INDIRECT("R3C"&MATCH(MAX(F4:O4),F4:O4)+5,FALSE)
> will give you the Rev #.
>
> As far as highlighting the cells,
> Conditional formatting will highlight the cell with the matching date.
> If you really want to highlight the PREVIOUS revision, it'll take some
> custom coding.
>
> however,
>
> I noticed in your sample file, there are some records with multiple lines:
> (rows 24-41, column "H" (R1))
> 17-Mar-11
> 247-Mail
> 18-Mar-11
> 250-Hard
> 22-Mar-11
> 261-Hard
>
> which date are you looking for? since all three are in column R1...
> If you're expecting the 22-Mar-11 date, then it'll take some more work.
>
>
> 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: Tue, September 27, 2011 1:47:20 AM
> Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help
>
> Please see the attchment
>
> regds
>
> On Mon, Sep 26, 2011 at 7:19 PM, dguillett1 <dguille...@gmail.com> wrote:
>> Can you show us an AFTER example(s) of what you want this to look like..
>>
>> -----Original Message----- From: Rohan Young
>> Sent: Monday, September 26, 2011 2:18 AM
>> To: excel-macros@googlegroups.com
>> 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
>>
>
> --
>----------------------------------------------------------------------------------
>-
> 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
