Thanks Sir.
On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA wrote:
> Hi
> X refer to each cell in range A1 to D5.
>
> Thanks
> On 3 Jul 2013 10:41, "Prafull Jadhav" wrote:
>
>> Dear All,
>>
>> Good Morning..
>>
>>
>> I got below macro from net ..Can you explain me what "x" stand here...
>>
>>
>>
>
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, "Prafull Jadhav" wrote:
> Dear All,
>
> Good Morning..
>
>
> I got below macro from net ..Can you explain me what "x" stand here...
>
>
>
> *Sub Upper_()*
>
> *For Each x In Range("A1:D5")*
> *'For Each x In Range("A1:D5")*
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what "x" stand here...
*Sub Upper_()*
*For Each x In Range("A1:D5")*
*'For Each x In Range("A1:D5")*
*
*
*x.Value = UCase(x.Value)*
*'x.Value = UCase(x.Value)*
*
*
*Next*
*
*
*Thanks in Advance.*
*Regards,*
*Prafull Jad
Dear Premor,
Thanks a Lot, you exacly raise my hope back for this, but the only help one
more thing if you can help me with that it would be your greatest help for
me.
Which data is pasted on sheet3 it should be deleted from sheet1, ideally
what i want that data to be removed from sheet 1 and kep
Dear All,
Hope you are doing great.
Kindly go through the requirement and reply me back with the resumes of the
consultants at *ajay.bharbutta8...@gmail.com*
*Position : Java Developer (Front End & Back End )*
*
*
*Location : Dallas,TX*
*Duration : 1+ yrs*
*Interview : Skype or In Person*
*Pref
Try using SUM with CSE
=SUM((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))
Or SUMPRODUCT
=SUMPRODUCT((C2:C11>C3)+((C2:C11>C3)*(B2:B11="A")))
Rgds,
[dp]
Pada 02/07/2013 20:51, Chandra Shekar menulis:
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Rega
Dear all,
Hope you are doing great,
Kindly go through the requirement and reply me back with the resumes of the
consultants at *ajay.bharbutta8...@gmail.com*
*Position : Java Developer (Front End & Back End )*
*
*
*Location : Dallas,TX*
*Duration : 1+ yrs*
*Interview : Skype or In Person*
*Pref
We can use this in VBA Module
Function ConcatRange(Rng As Range)
Dim i As Range
For Each i In Rng
ConcatRange = IIf(IsEmpty(ConcatRange), i.Value, ConcatRange &
", " & i.Value)
Next
End Function
Rgds,
[dp]
Pada 02/07/2013 21:15, KAUSHIK SAVLA menulis:
Hi Team,
I am havin
=SUMPRODUCT(N(DATE(YEAR(C2:C11),MONTH(C2:C11),DAY(C2:C11))>=DATE(2013,8,2)),N($B$2:$B$11="A"))
with CSE
On Tue, Jul 2, 2013 at 7:27 AM, Chandra Shekar wrote:
> Hi,
>
> Am getting a wrong count as 2 I have changed the E5 with date.
>
> Regard,
>
> Chandra
>
> On Tue, Jul 2, 2013 at 7:30 PM, prit
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2, 2013 at 7:30 PM, priti verma wrote:
> =SUMPRODUCT(N($C$2:$C$11>=E5),N($B$2:$B$11="A")) with cse
>
>
> On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> H
Kaushik,
PFA, to see the formula.
On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I am having some data in Cell A1 to A100 and I want to concatenate
> range of data from A1 to A100 with comma as seperator.
>
> Example:
>
> Cells
> A1 10
> A2 20
> A3
Thanks Vijay and Ahmed to resolve the query.
Regards,
Kaushik
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread title
Kaushik:
As your values are in Cells A1 to A2 write in Cell B1 formula =A1 and in
cell B2 = concatenate(B1,",",B2) and now this cell B2
formula copy and paste from cell B3 to B100 then finally the result you are
looking for will be in B100.
Hope this helps
On Tue, Jul 2, 2013 at 5:15 PM
Hi Kaushik,
Please check attached file.
On Tue, Jul 2, 2013 at 7:45 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> I am having some data in Cell A1 to A100 and I want to concatenate
> range of data from A1 to A100 with comma as seperator.
>
> Example:
>
> Cells
> A1 10
> A2 20
> A3
Hi Team,
I am having some data in Cell A1 to A100 and I want to concatenate
range of data from A1 to A100 with comma as seperator.
Example:
Cells
A1 10
A2 20
A3 30
&so on
I want result as 10, 20, 30 & so on.
Please help.
Warm Regards,
Kaushik Savla
--
Are you =EXP(E:RT) o
Hi Experts,
I want to know the Functions name, which we can use in Calculated field of
Pivot table. If possible, please provide me some example as well.
I searched a lot through google, but could not find out anything useful.
--
Regards,
Vijay
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
=SUMPRODUCT(N($C$2:$C$11>=E5),N($B$2:$B$11="A")) with cse
On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar wrote:
> Hi,
>
> Could you please help me in the attached file instruction is there in it.
>
> Thanks in advance.
>
> Regards,
>
> Chandra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
Hi,
Could you please help me in the attached file instruction is there in it.
Thanks in advance.
Regards,
Chandra
--
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.facebook.com/discussex
Hi Sharma,
if the file size is big and if u use many formula in your excel then this
kind of problem you may face often if you didnt close the file properly.
To avoid this kind of issue in future, you can save your file as *.xlsb (
which will save your file as binary format) your file size also
Thanks Priti Mam, Brilliant chart.
With warm regards,
Rajan Sharma
On Tue, Jul 2, 2013 at 1:05 PM, priti verma wrote:
> PFA
>
>
> On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma wrote:
>
>> Dear Priti Mam,
>>
>>Thanks for the solution provided.
>>
>> Now i am trying to plot the same graph
PFA
On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma wrote:
> Dear Priti Mam,
>
>Thanks for the solution provided.
>
> Now i am trying to plot the same graph for different data, i don't
> understand why it is not working. please check and let me know.
>
> As of now, i have inserted some pie-shap
21 matches
Mail list logo
