Dear Experts,
Please help me to build the formula, i have waiting any of the experts
formula.
With warm regards,
Rajan Sharma
On Wed, Dec 11, 2013 at 12:48 PM, Rajan sharma wrote:
> Dear all,
>
> I am unable to create the formula as per the attached file, please have
> a
Dear all,
I am unable to create the formula as per the attached file, please have a
look on this and help me to create the formula. Please find the attachment.
With warm regards,
Rajan Sharma
--
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
Hi, Try using below:
Sub prafu()
For Each x In Range("A1:A9000")
x.Value = Format(x.Value)
x.Value = Format(x.Value, "dd-mm- hh:mm")
Next x
End Sub
With warm regards,
Rajan Sharma
On Mon, Nov 18, 2013 at 12:23 PM, Prafull Jadhav
wrote:
> Dear All,
>
&
for the responses.
With warm regards,
Rajan Sharma
On Thu, Nov 14, 2013 at 12:14 PM, Anil Gawli wrote:
> Dear rajan,
>
>
> Pl elaborate more on this query
>
> Warm Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
Dear all experts,
Is my query is valid ? can we lookup the closest data as like the
attachment earlier. Please help on the attachment. Thanks to all.
With warm regards,
Rajan Sharma
On Thu, Nov 14, 2013 at 9:49 AM, Rajan sharma wrote:
> Sorry- attachment missed
> Dear e
in advance.
With warm regards,
Rajan Sharma
--
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 titles. Poor thread
regards,
Rajan Sharma
--
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 titles. Poor thread titles, like Please Help
Great, Thanks a lot Ravi sir, you are just a excel rocker. Thanks a ton.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 4:22 PM, Ravi Kumar wrote:
>
>
>
>
> Is this what u r looking for?
>
>
>
> PFA solution…
>
>
>
>
>
>
>
> *War
Thanks Ravi sir, Actually still my requirement is not yet fulfill. Please
find the attachment, i did manually in the attached excel.
Thanks for the help.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 3:59 PM, Ravinder wrote:
> pfa
>
>
>
> *From:* excel-macros@g
Thanks for the prompt reply Ravi Sir,
I am still stuck in the formula and getting error even after using CSE.
Please write in excel please.
With warm regards,
Rajan Sharma
On Mon, Nov 11, 2013 at 3:51 PM, Ravinder wrote:
>
> =(INDEX($A$1:$A$51,SMALL(IF(($G2=$B$2:$B$51)*(K$1=$D$2
Dear experts,
I have wrote formula in the attached file, but throwing error. Please
modify the formula and where i am wrong.
Thanks in advance.
With warm regards,
Rajan Sharma
--
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
Hi, CSE stands for Control + Shift + Enter ( Enter in same time after
entering the formula)
With warm regards,
Rajan Sharma
On Thu, Oct 31, 2013 at 10:20 AM, kasper wrote:
> Hi
>
> Thanks for the formula, but the formula is not working for me. What is
> "with cse&quo
Hi, Try Below
for Min
=MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE
for Max
=MIN(IF((F1=$B$7:$B$297)*($C$7:$C$297),$C$7:$C$297)) with CSE
With warm regards,
Rajan Sharma
On Wed, Oct 30, 2013 at 5:08 PM, Rajesh thrissur wrote:
> Hi Experts
>
> Please refer the
Hi Prabhakar ,
Use this array formula- =SUMPRODUCT(--($F9=$A$2:$A$241)*($C$2:$C$241=G$8))
i have learnt it from this experts only.
With warm regards,
Rajan Sharma
On Mon, Oct 21, 2013 at 2:31 PM, Prabhakar S H wrote:
> Hi Team,
>
> need your help to get nos by using formula. I
can use Sum, Count, etc in attached file. pfa.
With warm regards,
Rajan Sharma
On Thu, Oct 17, 2013 at 3:19 PM, Sandeep Sharma wrote:
>
>
> -- Forwarded message --
> From: Rajan sharma
> Date: Thu, Oct 17, 2013 at 2:36 PM
> Subject: $$Excel-Macros$$ Wri
Experts,
Please Write Formula without using
1. Where ever there is ifs in last words eg. Countifs, sumifs etc……
2. Please don’t use Index, offset.
3. Please don’t use sumproduct.
4. Please don’t use CountA
But you can use Sum, Count, etc in attached file. pfa.
With warm regards,
Rajan
Premor sir,
I am getting error while run the macros. i have attached my error file.
please check if i may be wrong while executing this code to other file.
With warm regards,
Rajan Sharma
--
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
Dear De Premor sir,
Awesome and miracle solution, i thought of it cannot be done in excel.
But you have proven me wrong. thanks you very very much, you have save my
time a lot by this solution.
Thnks to all
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 1:07 PM, De Premor
Dear All experts,
Any update on my query Please.
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 10:33 AM, Rajan sharma wrote:
> Thanks Amir sir,
>
>I have elaborated my query further in excel file, please find the
> attachment.
>
>
> With warm re
Thanks Amir sir,
I have elaborated my query further in excel file, please find the
attachment.
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 10:22 AM, Aamir Shahzad wrote:
> can you further brief?
>
>
> On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma
> wrote
Any body please suggest formulas or macros. please if it is possible..
Thanks
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma wrote:
> Dear experts,
>
> I want to extract only first and last values or string from Columns,
> Please guide. Ple
Dear experts,
I want to extract only first and last values or string from Columns, Please
guide. Please find the attachment, i have provide sample.
With warm regards,
Rajan Sharma
--
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
:) All this credit goes to this forum, Atually i have learnt from this
forum and just used. Thanks
With warm regards,
Rajan Sharma
On Wed, Sep 4, 2013 at 4:50 PM, Waseem Saifi wrote:
> this is too good Rajan !
>
> Regards,
> Waseem Saifi
>
>
> On Wed, Sep 4, 2013 at
Thanks Premor sir,
Fantastic, Hats off to ur UDF.. thanks a ton.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 4:40 PM, De Premor wrote:
> Try this using UDF
>
> Function SUMPB(Amount As Range, Unit As Range, RngCriteria As Range,
> Criteria As String)
>
Dear Premor sir,
Can your formula provided be done by Vba Macros. Actually i have many
sheets to update your formula, so that it makes effect to all the sheets.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 3:10 PM, Rajan sharma wrote:
> Dear Premor sir,
>
>
Dear Premor sir,
Exactly matching as per my requirement. Thanks a ton. even the formulas
are long it gives my solution.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 2:55 PM, De Premor wrote:
> Hi Rajan, try this long formula on Cell S2 or Just see at attac
Some body can help me for creating the formula please
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 1:58 PM, Rajan sharma wrote:
> Dear experts,
>
> I am struggling in one formula steps, please help me out. please find the
> attachment for more information, please.
&
the
requirement. P and Q are from J and K coulumn.
With warm regards,
Rajan Sharma
--
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
Thanks Ravinder,
Actually my query was, While opening the excel file, can be convert
every text format "error checking in green colur" to number.
Note: if the green color are actually a number but intext format
With warm regards,
Rajan Sharma
On Wed, Aug 7, 2013 at 1:22 PM
Dear Ashish sir,
Thanks for the prompt reply. the code provided is not affecting the
format. Can you plse elaborate a bit more.
With warm regards,
Rajan Sharma
On Tue, Aug 6, 2013 at 8:23 PM, ashish koul wrote:
> try this
> Sub test()
> Dim cl As Range
>
>
experts, can it be possible as per my query ?
With warm regards,
Rajan Sharma
On Tue, Aug 6, 2013 at 5:41 PM, Rajan sharma wrote:
> Dear experts,
>
> i have a excel file which is extracted from a application as seen in
> attached sample file. but the problem is that the nu
Dear experts,
i have a excel file which is extracted from a application as seen in
attached sample file. but the problem is that the numbers are in text
format, i want it to open as number format automatically, can be done like
that.
With warm regards,
Rajan Sharma
--
Are you =EXP(E:RT
Re: $$Excel-Macros$$ Running numbers
> To: excel-macros@googlegroups.com
>
>
> As You Wish, PFA
>
> Pada 19/07/2013 10:50, Rajan sharma menulis:
>
> Dear Experts,
> Thanks for providing me various aspect of running a number, But my
need is not still fulfill.
> Please
Premor sir,
While running the macros, Meanwhile can we do work ? i mean in rest of the
cells. Say i have type 500, now it will start running, but still i could
able to work in rest of the cells.
With warm regards,
Rajan Sharma
On Fri, Jul 19, 2013 at 10:44 AM, Rajan sharma wrote:
>
Yes Premor sir,
Thats what i was expecting. thank you very much.
Thanks to all.
With warm regards,
Rajan Sharma
On Fri, Jul 19, 2013 at 10:40 AM, De Premor wrote:
> As You Wish, PFA
>
> Pada 19/07/2013 10:50, Rajan sharma menulis:
>
> Dear Experts,
>
> Th
- 1,2,3,4,5,6,7,8,9,10
5.5= 1.1,1.2 . till 5.5
Please please help me on this.
With warm regards,
Rajan Sharma
On Thu, Jul 18, 2013 at 10:12 PM, Rupali Joshi wrote:
> Hi
>
> you can try this.
>
> Regards,
> Rupali Joshi
>
>
> On Thu, Jul 18, 2013 at 5:10 AM, Rajan sha
Experts please help me on this.
On Thursday, July 18, 2013, Rajan sharma wrote:
> Dear Experts,
> Please help on this. I want the numbers exactly to display. Please find
the attachment for reference.
> With warm regards,
> Rajan Sharma
>
>
> On Thu, Jul 18, 2013 at 5:05 PM
Dear Experts,
Please help on this. I want the numbers exactly to display. Please find
the attachment for reference.
With warm regards,
Rajan Sharma
On Thu, Jul 18, 2013 at 5:05 PM, Rajan sharma wrote:
> Dear all,
>
> I found my answer, Pls find the attachment. and thanks to all.
Dear all,
I found my answer, Pls find the attachment. and thanks to all.
With warm regards,
Rajan Sharma
On Thu, Jul 18, 2013 at 4:40 PM, Rajan sharma wrote:
> Dear all,
>
> Can we able to run numbers as like the attached excel.
>
>
>
> With warm regards,
> Rajan
Dear all,
Can we able to run numbers as like the attached excel.
With warm regards,
Rajan Sharma
--
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
Dear All,
How can we plot the data below in chart. i am expecting the chart as
like in attached file. plse find the attachment.
Type Total Open Total Closed Total Count A 6 3 9 B 2 2 4
With warm regards,
Rajan Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Dear Ashish sir,
Can you please share me the excel fil. Actually i am unable to download
the file from the mention site. i am eager to see the chart.
With warm regards,
Rajan Sharma
On Sat, Jul 13, 2013 at 3:11 PM, Puttu * wrote:
> really very useful. Thanks
>
>
> On Sat,
Thanks Vijay for sharing different charts. it will help a lot.
With warm regards,
Rajan Sharma
On Wed, Jul 3, 2013 at 10:51 PM, P.VIJAYKUMAR wrote:
> Respected Waseem,
>
> please have a look at these charts.
>
>
> Regards,
> Vijaykumar
>
>
> On Wed, Jul 3,
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.
>>
&g
Hi All,
I got idea and have plotted, please find the attachment. See if it is ok.
if needed please suggest with different charts.
Warm regards,
Rajan Sharma
On Mon, Jul 1, 2013 at 2:42 PM, Rajan sharma wrote:
> Dear Priti Mam,
>
>Thanks for the solution provided.
>
> Now
hment for data and more clarities.
Warm regards,
Rajan Sharma
On Thu, Jun 27, 2013 at 12:27 PM, priti verma wrote:
> Hi vijay,
> Pfa for more clarification
>
>
>
> On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR wrote:
>
>> Respected priti,
>>
>> I tried t
Dear Sam,
Sorry for the late reply. Thanks sir for sharing me the link, really that
was awesome and help me solve my query. thanks
With warm regards,
Rajan Sharma
On Wed, Jun 26, 2013 at 7:35 PM, Sam Mathai Chacko wrote:
>
> http://www.excelfox.com/forum/f2/copy-data-from-multiple-wor
name as "Group_Data".
Thanks experts.
With warm regards,
Rajan Sharma
--
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
Thanks Priti and Vijay and to all, yes it will help me to figure out my
solution. thanks a ton champs.
With warm regards,
Rajan Sharma
On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR wrote:
> Respected Ranjan,
>
> For that type of data you can use a stacked pie chart or a pie of pi
total B area, some
portion of C is covered.
Hope you might have understand my query. thanks sir.
[image: Inline image 1]
With warm regards,
Rajan Sharma
On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR wrote:
> Respected Ranjan,
>
> When you select the data for the chart select the
attached file.
Thanks
With warm regards,
Rajan Sharma
--
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 titles
51 matches
Mail list logo
