=SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2)
REGARDS
JEET SINGH
On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote:
>
> Dear experts
>
> I have an excel file to tra
PFA
On Tue, Nov 20, 2012 at 10:20 PM, renuka chari wrote:
> hi Excel beginner,
> i don't know your name?
> but you gave me a wonderful solution
> thanks allot.
> but is there any easy formula for that..
> this mega formula usage in my sheet every time is difficult for me...
> is ther
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars = "\/:*?"" {}[](),!`~\:;'._-=+&^%$<>|"
For i = 1 To Len(sSpecialChars)
sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), "")
Next
removeSpecial = sInput
End
Dear Friend,
Plz find the attached file.
On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
> Dear Experts
>
> ** **
>
> Kindly see the attached sheet and urgently req.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM
t1!$B$1:$B$2270=13)))
> use it with Ctr+Shift+Enter
>
> Regards
> Prince
>
> On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet singh wrote:
>>
>> Dear all,
>>
>> I want to count multiple criteria in a column. I have done this query in
>> excel,
excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Please Help
>>
>> ** **
>>
>> I did NOT look at your attachment because you did not provide a
>> meaningful subject line in your post and you did not explain your problem
>> in the body of
ANY UPDATE
On Thu, Sep 6, 2012 at 10:28 AM, jeet singh wrote:
>
>
> Dear All,
>
> plz find the attachment and help
>
> Regards
> Jeet
>
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
PFA
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Help me to find the circle and area. Please find the attached file for
> your reference.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexc
=IF(MID(A2,4,2)="10",0,"10 is not in middle")
On Tue, Aug 28, 2012 at 11:54 AM, ravinder negi wrote:
> Here is the solution.
>
> --- On *Sun, 8/26/12, Kuldeep Singh * wrote:
>
>
> From: Kuldeep Singh
> Subject: $$Excel-Macros$$ Only MID Function
> To: excel-macros@googlegroups.com
> Date
