In the example Kumar Raje Gowda should be 1.
Another one
=COUNT(INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)):INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+MIN(IFERROR(MATCH("*",INDEX($A$2:$A$595,MATCH(J2,$A$2:$A$595,0)+1):$A$595,0),
Kris
--
FORUM RULES (934+ members already BANNED for violat
I have a huge problem I just can not solve.I'm trying to concatinate
several things. I have a user form with 15 optionbuttons. If specific
optionbutton are clicked then do a certain thing.. Such as If
optionbutton1 is clicked then put Always"350" Optionbutton1 is always
"S" then whatever is in Labe
Can you attach a sample file to better understanding of you query?
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Jan/Sun/2012 03:24
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Concatinate
I have a hug
Hi Group,
Excel is not recording macro to work with shapes .How to fill Color in
shapes by VBA
Regards
Raghav
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Proble
Sub FillColor()
dim sh as shape
set sh= activeSheet.shapes("MyShape")
sh.fill.forecolor=rgb(255,0,0)
end Sub
On Sun, Jan 1, 2012 at 5:24 PM, bhupendra singh raghav <
raghav.bhupen...@gmail.com> wrote:
> Hi Group,
> Excel is not recording macro to work with shapes .How to fill Color in
> shapes b
Sub changeShapecolor()
ActiveSheet.Shapes("Rectangle 2").Fill.ForeColor.SchemeColor = 12’blue
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: bhupendra singh raghav
Sent: Sunday, January 01, 2012 5:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fill Color in
I've looked everywhere. I can not find where you attach a file. Thanks
so much for your help!
On Jan 1, 5:08 am, "Rajan_Verma" wrote:
> Can you attach a sample file to better understanding of you query?
>
> Rajan.
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:ex
Great sir ji
From: Kris [mailto:krishnak...@gmail.com]
Sent: Jan/Sun/2012 08:51
To: excel-macros@googlegroups.com
Cc: Excel Member
Subject: Re: Search DOUBT
Hi,
PFA.
Kris
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
Hi Bob,
Just email it to the group. If you are posting to the group online, use
email instead. excel-macros@googlegroups.com.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Sunday, January 01, 2012 6:42 AM
To: MS EXCEL
Hello Faisal & Evey one,
This is what my understanding,
*If any code repeats after a dest, just before this code consider as final
dest.*
Eg:
Row 101.
DMS-BAH-AUH-CGK-AUH-DMM
AUH repeats after CGK, so final dest, CGK.
Row 109,
DMS-BAH-DAM-BAH-DMM
BAH repeat after DAM, so final dest, DAM
Dear Ashish,
Try this one
=INDIRECT(ADDRESS((MATCH("*"&$B$3&"*",$B$9:$B$14,0)+8),3))
See attached sheet.
On Thu, Dec 29, 2011 at 6:51 PM, Ashish Bhalara
wrote:
> Dear Experts,
>
> I need to use vlookup function to look value by fulfill some particular
> condition. The example to understand the
Dear all
Date also stored in texthow i convert to date pl advice
Regards
chandru
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advi
In that case my UDF would be
*Dim dic As Object
Function FINALDEST(ByRef v) As String
Dim x, i As Long
If TypeOf v Is Range Then v = v.Value2
x = Split(v, "-")
If dic Is Nothing Then Set dic = CreateObject("scripting.dictionary")
With dic
Hi All,
I have written a function to strip HTML from a String kept in a Cell.
How to use this UDF (User Defined Function), you can visit this link:
http://www.learnexcelmacro.com/2011/12/strip-html-how-to-remove-html-tags-from-a-string-in-vba/
-
Hi,
For Numbers,
Select each column on by one. Go to Data > TextToColumns > Next > Next
check on General > Finish.
For date, check Date Instead of General and select DMY > Finish.
Kris
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poo
Dear all,
Any VBA code is there ?
regards
chandru
On Mon, Jan 2, 2012 at 10:46 AM, Kris wrote:
> Hi,
>
> For Numbers,
>
> Select each column on by one. Go to Data > TextToColumns > Next > Next
> check on General > Finish.
>
> For date, check Date Instead of General and select DMY > Finish.
Sub kTest()
Dim rngDate As Range
Dim rngNum As Range, i As Long
Set rngDate = Range("c3:c7688")
Set rngNum = Range("d3:e7688")
rngDate.TextToColumns Destination:=rngDate.Cells(1),
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveD
17 matches
Mail list logo