the true condition and color if condition is True.
> Actually this is no only F7 once we apply in all range this will change the
> F7 to F8, F9, F10 ,F11
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ganesh N
>
Subject: Re: $$Excel-Macros$$ Request help on conditional formatting
Thanks Ravinder!!!
Ravinder may i know why we are using $F7 ? before =Max. Else can you explain
how it works ?
Thanks & Regards
Ganesh N
On Mon, Feb 10, 2014 at 10:16 AM, Ravinder
wrote:
=$F7=MAX($F$7:$F$11)
Thanks Ravinder!!!
Ravinder may i know why we are using $F7 ? before =Max. Else can you
explain how it works ?
Thanks & Regards
Ganesh N
On Mon, Feb 10, 2014 at 10:16 AM, Ravinder wrote:
> =$F7=MAX($F$7:$F$11) try this formula in condition formatting option or
> pfa
>
>
>
> *From:* excel-macr
=$F7=MAX($F$7:$F$11) try this formula in condition formatting option or pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ganesh N
Sent: Sunday, February 09, 2014 9:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request help on condi
Choose E7: E20, Condition 1: Cell Value Is selected, the right pane is used
Formula function:
= F7: F20> 50
Click the Format button to select the color
2014-02-09 22:45 GMT+07:00 Ganesh N :
> Hi team,
>
> Any one can help me to know how to highlight the name based on other
> column value (need
Thanks Very much Ashish Sir & Excel user group
On Wed, Dec 12, 2012 at 12:00 AM, Ms Excel user wrote:
> Hi Amar,
>
> Try this array formula
> =INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0))
>
>
>
>
>
> On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote:
>
>> Hi All Champs
>
Hi Amar,
Try this array formula
=INDEX($F$7:$F$27,MATCH(MONTH(H8),MONTH($E$7:$E$27),0))
On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote:
> Hi All Champs
>
> I will Request all anyone suggest me unique value from same month (formula)
>
> Regards
> Amar
>
>
> --
> Join offic
=MAX(IF(MONTH($E$7:$E$27)=MONTH(H8),$F$7:$F$27,""))
press + ctlr + shift+ enter
On Tue, Dec 11, 2012 at 1:13 PM, amar takale wrote:
> Hi All Champs
>
> I will Request all anyone suggest me unique value from same month (formula)
>
> Regards
> Amar
>
>
> --
> Join official Facebook page of thi
Hi
Protect sheet n keep cell format as locked.
Thanks//Vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: amar takale
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Nov 2012 12:42:16
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request fo
hi ashsih koul,
it is working
very thanks ,
regards,
shivaprasad.
On Fri, Oct 19, 2012 at 9:16 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad
> wrote:
>
>> hi ashish koul,
>>
>> please find the attachment of example.
>>
>
check the attachment see if it helps
On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad wrote:
> hi ashish koul,
>
> please find the attachment of example.
>
> i mentioned formula also but showing 0 value.
> please provide the macro.
>
>
> regards,
> shivaprasad.
>
> On Fri, Oct 19, 2012 at 9:02 PM,
hi ashish koul,
please find the attachment of example.
i mentioned formula also but showing 0 value.
please provide the macro.
regards,
shivaprasad.
On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote:
> can u share any excel file with input and output u like to have
>
>
> On Fri, Oct 19, 20
can u share any excel file with input and output u like to have
On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad wrote:
> hi ashish koul,
>
> please provide the example attachment.
>
>
> regards,
> shivaprasad.
>
>
> On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:
>
>> try this udf
>>
>> Funct
hi ashish koul,
please provide the example attachment.
regards,
shivaprasad.
On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote:
> try this udf
>
> Function numeric_value(x As String)
> Dim a As String
> a = ""
> For i = 1 To Len(x)
> If IsNumeric(Mid(x, i, 1)) Then
> a = a & Mid(x, i, 1)
>
try this udf
Function numeric_value(x As String)
Dim a As String
a = ""
For i = 1 To Len(x)
If IsNumeric(Mid(x, i, 1)) Then
a = a & Mid(x, i, 1)
End If
Next i
numeric_value = a
End Function
On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad wrote:
> hi experts,
>
> how to separate the number,
> i m
dear cute,
please try it, first change ur formar in mm/dd/ format
=NETWORKDAYS(DATEVALUE(MID(B4,FIND("/",B4,1)+1,1)&"/"&LEFT(B4,1)&"/"&RIGHT(B4,4)),TODAY())
On Mon, Aug 27, 2012 at 10:34 PM, Cute Awesome wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com
jan_Verma
> wrote:
> > Try the attached Workbook,
> >
> >
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of dguillett1
> > Sent: Thursday, August 18, 2011 2:54 AM
> >
> > To: excel-macros@goo
cel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Request for Directory Audit Macro
>
>
>
> Look in the vba help index for DIR
>
>
>
> From: crazybond
>
> Sent: Wednesday, August 17, 2011 3:30 PM
>
> To: excel-macros@googlegroups.com
>
> Subjec
http://akoul.blogspot.com/2011/07/print-file-names-in-folder-to-excel-on.html
http://akoul.blogspot.com/2011/06/rename-files-in-vba.html
On Thu, Aug 18, 2011 at 5:27 AM, XLS S wrote:
> Hey Crazybond,
>
> Please find the attachment ...
>
> On Thu, Aug 18, 2011 at 2:00 AM, crazybond wro
Look in the vba help index for DIR
From: crazybond
Sent: Wednesday, August 17, 2011 3:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Request for Directory Audit Macro
Hi Experts,
Can a vba code/macro be created/ is available in case one needs to do the audit
on the directo
See the below web site ..
http://www.exceluser.com/explore/sumproduct_12.htm
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Request for
*hi sant ram
plz check links below
for sumproduct
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
for array formulas
http://www.cpearson.com/excel/ArrayFormulas.aspx
for substitute
http://www.excelitems.com/2010/05/substitute-function.html
*Have A Nice Time & Enjoy Life
Regards:
Thanks you two, I integrated both suggestions into my vba and it
processed instantly. Very helpful :)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
HI,
Try out the following:
Sub trial()
Dim rng As Range
Dim what(9) As String
what(1) = "FD"
what(2) = "EX"
what(3) = "NA"
what(4) = "NB"
what(5) = "NC"
what(6) = "HN"
what(7) = "CLD"
what(8) = "Location"
what(9) = "of"
For i = 1 To 9
Do
Se
Hi Jason,
One way of speeding this up is to use:
Application.ScreenUpdating=False
at the beginning of your code.
(And don't forget the Application.ScreenUpdating=True at the end.)
But I'm sure we could speed it up in other ways as well.
Any chance of attaching the file, or a sample file?
Reg
I don't think any of us could legally send you a copy of Office 2010. You
should contact the company you purchased it from and ask them to help you.
On Wed, Mar 3, 2010 at 1:55 AM, sudhir kumar wrote:
> Hi Dear all,
>
>
> Can any one send me setup of MS office 2010.
> It was download from net
26 matches
Mail list logo
