Hi,
Check this May be if it can help you.
Function GetNumberS(strData As String) As String
Dim objRge As Object, REMatches As Object
Set objRge = CreateObject("vbscript.regexp")
With objRge
'.Pattern = "[0-9][0-9][0-9][0-9]"
.Pattern = "(\d+)"
End With
Please provide sum sample data and the condition that you want to impose on
that.
Regards
Prince
On Friday, March 1, 2013 1:11:23 AM UTC+5:30, santosh wrote:
>
> Hello Group,
>
> Need a small help on how to calculate the max with two or more conditions.
>
> --
> Regards
> Santosh
> santoshkum.
Hello xlstime!
Your formula won't work
Values in the array will be multiplied by 0 if it dose not meets the
criteria. It will be multiplied by 1 if it meets the criteria.
So using MIN function in SUMPRODUCT will give 0, if there is any value in
the array which does not meets the criteria.
O
HI,
May be It Can help You.
=SUMIF(D2:AB2,AC2,D3:AB3)
regards
Prince
On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> need formula for sum in attach
>
> Regards,
> Deepak
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(
Dear Noorin,
Your VBA Solution is Good.But I ask you if we use UDF VBA code then how to
know what type words write in cell to extract output.which Code you
provide,I put in model & come in excel then next stage I dont know what
words type in cell to extract output from VBA code.
So pls Guide me,h
Dear All Friends
Thanks a lot everybody who give time for my solution.
Regards
Amar
On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote:
> I don't understand Mr.Bé Trần Văn
>
>
> On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn
> wrote:
>
>> Learn test.
>>
>>
>> 2013/2/28 The Viper
>>
>>> can't get t
Hi Santosh,
u can try sumproduct with min or max
try this
=SUMPRODUCT(MIN((A2:A10=Criteria1)*(B2:B10=Criteria2)*(C2:C10)))
On Fri, Mar 1, 2013 at 1:11 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hello Group,
>
> Need a small help on how to calculate the max with two or more
Hi Venkat,
try to use Sumif with index match function
=SUMIF($A$2:$A$7,F9,INDEX($A$1:$C$7,,MATCH($F8,$A$1:$C$1,0)))
Thanks
Team XLS
On Fri, Mar 1, 2013 at 7:20 AM, Venkat CV wrote:
> Hello Everyone,
>
> I have enclosed sample file were i required formula assistance If I
> select 2 Criteria'
I don't understand Mr.Bé Trần Văn
On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn wrote:
> Learn test.
>
>
> 2013/2/28 The Viper
>
>> can't get throuh formula?
>>
>> pfa
>>
>>
>>
>> On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote:
>>
>>> solved .
>>>
>>>
>>> On Thu, Feb 28, 2013 at 3:41 PM,
Dear Santosh,
Please try it..
For Max with two condition
=MAX(IF(($A$2:$A$20=$F6)*($B$2:$B$20=$G6),$C$2:$C$20,""))
with ctrl+Shift+enter
for Min with two conditon
=MIN(IF(($A$2:$A$20=$F6)*($B$2:$B$20=$G6),$C$2:$C$20,""))
With ctrl+shift+enter
See attachment, Hope it will help for you..
On
=SUMIF(A2:A7,F9,OFFSET(A2:A7,0,CODE(F8)-64))
Regards
David Grugeon
On 1 March 2013 11:50, Venkat CV wrote:
> Hello Everyone,
>
> I have enclosed sample file were i required formula assistance If I
> select 2 Criteria's and needs to sum up based on ROW&Column criteria's
>
> Thanks in advance..
Dear Souvik,
Please mail on below Email ID
macros+unsubscr...@googlegroups.com
On Fri, Mar 1, 2013 at 8:25 AM, SOUVIK ROY wrote:
> Please unsubscribe me from this group.
>
> --- On *Fri, 1/3/13, Venkat CV * wrote:
>
>
> From: Venkat CV
> Subject: $$Excel-Macros$$ Multiple Column& Rows conditio
Please unsubscribe me from this group.
--- On Fri, 1/3/13, Venkat CV wrote:
From: Venkat CV
Subject: $$Excel-Macros$$ Multiple Column& Rows conditions Sum
To: "Google"
Date: Friday, 1 March, 2013, 7:20 AM
Hello Everyone,
I have enclosed sample file were i required formula assistance If I
sel
Hello Everyone,
I have enclosed sample file were i required formula assistance If I
select 2 Criteria's and needs to sum up based on ROW&Column criteria's
Thanks in advance..
--
Best Regards
Venkat
Chennai
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO
That's WAY too vague.
Can you give us some sample data and how you want to calculate it?
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 l
Hello Group,
Need a small help on how to calculate the max with two or more conditions.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www
nooran ji good one thanks
On Mon, Feb 25, 2013 at 1:44 PM, NOORAIN ANSARI wrote:
> Dear Harkesh,
>
> Please try it..
>
>
> Function special_Charcters(rng As Excel.Range)
> Dim i As Integer
> Dim j As Integer
> For i = 1 To Len(rng)
> If Not Mid(rng, i, 1) Like "[0-9,A-Z,a-z]" Then
> special_Char
Learn test.
2013/2/28 The Viper
> can't get throuh formula?
>
> pfa
>
>
>
> On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote:
>
>> solved .
>>
>>
>> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
>>
>>> Dear All,
>>>
>>> I have facing some hyperlink issue in sheet,I attached sheet in d
Dear Experts,
I want to create time bar or time capture on Excel.
Please teach me how to create with the help of macro
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail plea
can't get throuh formula?
pfa
On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote:
> solved .
>
>
> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
>
>> Dear All,
>>
>> I have facing some hyperlink issue in sheet,I attached sheet in detailed
>> information,Pls tell me It is possible?
>
solved .
On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
> Dear All,
>
> I have facing some hyperlink issue in sheet,I attached sheet in detailed
> information,Pls tell me It is possible?
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>
Dear All,
I have facing some hyperlink issue in sheet,I attached sheet in detailed
information,Pls tell me It is possible?
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.fa
This thread makes me think you are typing in the names of your named
ranges. It is bettter to press F3 and double click the name to add it.
Makes sure there are no typos in the name.
Regards
David Grugeon
On 28 February 2013 18:03, Bé Trần Văn wrote:
> Go to Insert> Name> Define, Define Nam
23 matches
Mail list logo