PFA
On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma rajansharma9...@gmail.comwrote:
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
Thanks Priti Mam, Brilliant chart.
With warm regards,
Rajan Sharma
On Tue, Jul 2, 2013 at 1:05 PM, priti verma pritiverma1...@gmail.comwrote:
PFA
On Mon, Jul 1, 2013 at 3:12 AM, Rajan sharma rajansharma9...@gmail.comwrote:
Dear Priti Mam,
Thanks for the solution provided.
Now
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
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 @
=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:
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
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
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) or
Hi Kaushik,
Please check attached file.
On Tue, Jul 2, 2013 at 7:45 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
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,
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
Kaushik,
PFA, to see the formula.
On Tue, Jul 2, 2013 at 5:15 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
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 pritiverma1...@gmail.comwrote:
=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
=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 chandrashekarb@gmail.com
wrote:
Hi,
Am getting a wrong count as 2 I have changed the E5 with date.
Regard,
Chandra
On Tue, Jul 2,
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 having
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*
Try using SUM with CSE
=SUM((C2:C11C3)+((C2:C11C3)*(B2:B11=A)))
Or SUMPRODUCT
=SUMPRODUCT((C2:C11C3)+((C2:C11C3)*(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.
Regards,
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*
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
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 Jadhav.*
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com 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
20 matches
Mail list logo