--
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,
Urgent, Need Help, F
Great Ankur SirExcellent😀😀
On Sun, Jun 24, 2018 at 12:02 AM, ankur wrote:
> hi amar takale
>
> *Solution is attached as per your requirement ,i have not used sumproduct*
>
> *May this file help you*
>
>
>
>
>
> *With Regards:*
>
> *CMA** Ankur P
> delete the original message. Further, you are not to copy, disclose, or
> distribute this e-mail or its contents either partly or completely. Before
> opening any attachments please check them for viruses and defects."
>
>
> On Sat, Apr 28, 2018 at 2:16 PM, amar takale wrote:
>
>
Any Solution?
On Mon, Apr 30, 2018 at 7:29 PM, amar takale wrote:
>
> --
> 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 RUL
sponds click here for Message *
>
> On Sat, Apr 28, 2018 at 11:46 AM, amar takale
> wrote:
>
>>
>> --
>> 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
--
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,
Urgent, Need Help, F
any one see this issue?
On Thu, Feb 22, 2018 at 6:11 PM, amar takale wrote:
>
>
--
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 c
??
On Thu, Feb 22, 2018 at 10:07 AM, amar takale wrote:
> Thank for reply sir
>
> I explain my issue in excel sheet
>
> On Thu, Feb 22, 2018 at 6:10 AM, who wrote:
>
>> Hello,
>>
>> I do not see another way, unless you can find a different web site to get
any one help me
On Thu, Feb 22, 2018 at 6:11 PM, amar takale wrote:
>
> --
> 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 RUL
s this close to what you want?
>
> Thanks, David
>
> On Wednesday, February 21, 2018 at 3:25:23 AM UTC-8, amar takale wrote:
>
>>
>> --
> 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
--
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,
Urgent, Need Help, F
Thanks Genius
you are really Genius person.
On Sat, Feb 17, 2018 at 2:51 PM, GENIUS wrote:
> See the result inside the workbook
>
> --
> 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.f
Dear All
I want vba code where I serach any any Specific word in all excel tabs
where it is input (hidden or unhidden).
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.faceb
no,I have got it but how to done it?I will try but not success,if possible
can you Create line chart in my attached excel so I got confidence.
On Fri, Jun 16, 2017 at 2:12 PM, Rajan Verma
wrote:
> so you have already got it.
>
> Regards
> Rajan
>
> On Fri, 16 Jun 2017 at 12:
http://www.exceldashboardtemplates.com/how-to-show-gaps-in-a-line-chart-when-using-the-excel-na-function/
On Thu, Jun 15, 2017 at 12:53 PM, Rajan Verma
wrote:
>
> show me some image to replicate the chart.
>
> Regards
> Rajan Verma
>
> On Tuesday, 6 June 2017 05:39:58 UTC
he window that would pop up, check(tick
> mark) logarithmic scale under Axis option category. You will get a break
> chart in excel.
>
>
> Thanks & regards,
> *Sandeep Kumar Baranwal*
> Lead Solution Advisor
> Model validation and Valuation, Deloitte US India
> Gurga
any ideas friends
On Thu, Jun 8, 2017 at 11:51 AM, 'Storey Thomas' via MS EXCEL AND VBA
MACROS wrote:
>
>
> On Thu, 6/8/17, amar takale wrote:
>
> Subject: Re: $$Excel-Macros$$ Required break chart in excel
> To: e
any reason for this issue?
On Thu, Jun 8, 2017 at 9:47 AM, amar takale wrote:
> ???
>
> On Tue, Jun 6, 2017 at 4:52 PM, amar takale wrote:
>
>> Dear All
>>
>> When I save my excel then show message in attached doc screen shot,why
>> this message show?
???
On Tue, Jun 6, 2017 at 4:52 PM, amar takale wrote:
> Dear All
>
> When I save my excel then show message in attached doc screen shot,why
> this message show? There are no external link in excel.
>
> Regards
>
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
Hi friends
Good Morning
Any Idea?
On Tue, Jun 6, 2017 at 5:09 PM, amar takale wrote:
> Dear all friends
>
> I Required break chart in excel.between data if there are blank cell then
> chart show break.
>
> Actually in blank cell there are formula(yellow cell) which show bl
Dear all friends
I Required break chart in excel.between data if there are blank cell then
chart show break.
Actually in blank cell there are formula(yellow cell) which show blank cell
(If +is error+blank formula).
Finally I need prepare Break chart on yellow cell data range ,Can We do
this?
R
places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
>
> On Tuesday, January 10, 2017 11:48
> PM, amar takale
> wrote:
>
>
>Dear
e a bit in system
> resources.
> this kind of thing can be easily done
> with VBA.
> I can help with this if you'd like.I've done it
> before with
>nearly 300
> workbooks.
>
> Paul-
> “Do
>
Dear Friends
There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in
folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash
Flow from 10 years).I Required Separate one Output Excel sheet where I
extract specific data (like Net sales, Net Profit, Share Cap
04 AM,
> "margaretatolliver via MS EXCEL AND VBA MACROS"
>
> wrote:
>
>
> ------ --
>
> On Thu, 12/29/16, amar takale
> wrote:
>
>
>
> Subject: Re: $$Excel-Macros$$ CRM (Customer relationship
> management
s@googlegroups.com> wrote:
>
>>
>> --------
>> On Thu, 12/29/16, amar takale wrote:
>>
>> Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management )
>> excel template
>> To: excel-macros@googlegroups.com
>> Date: Thursday, December 29, 2016, 6:19 AM
Dear Paul Sir
Good Morning
Can you see in this matter?
Regards
Amar T
On Thu, Dec 29, 2016 at 9:49 AM, amar takale wrote:
> Dear Sir
>
>
>
> Can you send me Example excel Sheet.
>
> On Thu, Dec 29, 2016 at 6:52 AM, cronincarmelita via MS EXCEL AN
> On Wed, 12/28/16, mintaspriggs via MS EXCEL AND VBA MACROS
>
> wrote:
>
>Subject: Re: $$Excel-Macros$$ CRM (Customer
> relationship
> management ) excel template
>To: excel-macros@googlegroups.com
>Date: Wednesday, December 28,
t; excel-macros@googlegroups.com> wrote:
>
> Subject: Re: $$Excel-Macros$$ CRM (Customer relationship management )
> excel template
> To: excel-macros@googlegroups.com
> Date: Wednesday, December 28, 2016, 10:41 AM
>
>
> ----
> On Wed, 1
Dear Friends
Any Ides?
On Tue, Dec 27, 2016 at 10:02 AM, amar takale wrote:
> Dear All Friends,
>
> Goog Morning
>
> Can anyone send me CRM (Customer relationship management ) excel template
> (customer discussion date by date & their follow up discussion) in excel.With
&
Dear All Friends,
Goog Morning
Can anyone send me CRM (Customer relationship management ) excel template
(customer discussion date by date & their follow up discussion) in excel.With
the goal of improving business relationships with customers. I know this is
not possible in excel due to many issu
03 please use it and let me know. i have sent
> you request on hangout accept it man
>
> On Sat, Nov 26, 2016 at 10:56 AM, amar takale
> wrote:
>
>> Dear Sourav
>>
>> Good morning
>>
>> but how can I create & save .xml file on desktop.I use excel
use this tool and let me know if you need any changes.
>
> Xml file name will be "Test.xml"
>
> Do Formatting in Sheet2 hehe.
>
>
> On Fri, Nov 25, 2016 at 2:36 PM, amar takale wrote:
>
>> no
>>
>> On Fri, Nov 25, 2016 at 11:15 AM, sourav d
no
On Fri, Nov 25, 2016 at 11:15 AM, sourav devrani <
souravdevrani1...@gmail.com> wrote:
> Hi Amar any Progress
>
> On Fri, Nov 25, 2016 at 10:13 AM, amar takale
> wrote:
>
>> ok
>>
>>
>> On Fri, Nov 25, 2016 at 10:00 AM, sourav devrani <
&g
;> whenever i lose it.
>> On 24 Nov 2016 18:18, "amar takale" wrote:
>>
>>> how to it?
>>>
>>> On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani <
>>> souravdevrani1...@gmail.com> wrote:
>>>
>>>> Do one thing bro
how to it?
On Thu, Nov 24, 2016 at 6:12 PM, sourav devrani wrote:
> Do one thing bro Scrap the data from Web.
>
> On Thu, Nov 24, 2016 at 6:09 PM, amar takale wrote:
>
>> See screen shot.If possible you also try why it show like that.
>>
>> On Thu, Nov 24, 20
se web scrapping and fetch data from web into excel and every Click of
> Button your data will be refreshed accordingly your web data.
>
> On Wed, Nov 23, 2016 at 11:26 AM, Kush Shama
> wrote:
>
>> Use import wizard. Select web query and paste the link.
>> On 18 Nov 2016
On Mon, Nov 21, 2016 at 10:00 AM, amar takale wrote:
> Any experts help me on this issue?
>
> On Fri, Nov 18, 2016 at 12:57 PM, amar takale
> wrote:
>
>> I want update below link excel.All data show in excel like in website &
>> update data after click refre
Any experts help me on this issue?
On Fri, Nov 18, 2016 at 12:57 PM, amar takale wrote:
> I want update below link excel.All data show in excel like in website &
> update data after click refresh button
>
> https://www.nse-india.com/live_market/dynaContent/live_
> watch/equit
I want update below link excel.All data show in excel like in website &
update data after click refresh button
https://www.nse-india.com/live_market/dynaContent/live_watch/equities_stock_watch.htm
Is it possible in excel
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
PM, Paul Schreiner
wrote:
>
> *See answers below:*
>
>
> On Friday, November 4, 2016 2:00 AM, amar takale
> wrote:
>
>
> Dear Paul Sir,
>
> This is fabulous work!
> I think this must be flashing on the front page! :D. And I am Extremely
> sorry for so late reply
--
>
>
>
>
>
>
>
> *“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 long as ever you can.” - John Wesley*
> -
&
Dear Hilary sir pls look into this matter.
Also from Paul sir expect lot.
On Mon, Oct 24, 2016 at 5:42 PM, amar takale wrote:
> Dear Sir
>
> Thanks for reply.but my requirement not this way (And I am use excel
> 2003). I want to search any string from specific cell (D2) then data
data
Regards
Amar
On Mon, Oct 24, 2016 at 4:18 PM, Hilary Lomotey wrote:
> See attached, HTH. Cheers
>
> On Mon, Oct 24, 2016 at 5:35 AM, amar takale wrote:
>
>> Dear Friends
>> any one help me on this issue
>>
>> On Fri, Oct 21, 2016 at 12:09 PM, amar tak
Dear Friends
any one help me on this issue
On Fri, Oct 21, 2016 at 12:09 PM, amar takale wrote:
>
> --
> 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.c
Array formula press (Ctrl+Shift+enter)
={LARGE($A$2:$A$21,{1;2;3;4;5})}
On Tue, Apr 19, 2016 at 3:50 PM, amar takale wrote:
> use this formula
>
> =LARGE($A$2:$A$21,{1;2;3;4;5})
>
> On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal
> wrote:
>
>> Dear Sir
>>
>
use this formula
=LARGE($A$2:$A$21,{1;2;3;4;5})
On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal wrote:
> Dear Sir
>
> Required formula for top 3 unique value & bottom 3 unique value excluding
> "Zero".
>
> On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal
> wrote:
>
>> Hello Sir
>>
>> formula re
> *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 long as ever you can.” - John Wesley*
> -
he Format tab, you can change it as
> you may like, including the text.
>
> HTH
>
> On Wed, Mar 2, 2016 at 10:25 AM, amar takale wrote:
>
>> Dear Paul Sir
>>
>> I was trying every method as per my knowledge to rename it but not
>> success.
>> So then
Dear Paul Sir
Pls look into this topic.I think we will use (If+Search) formula but I cant
possible how to modified it.
Regards
Amar
On Mon, Feb 29, 2016 at 7:49 PM, amar takale wrote:
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
t;
> *“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 long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, March 1, 2016 3
Dear Friends
This possible to edit this logo bcos I like this to rename my excel sheet
name.
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.facebook.com/discussexcel
FORUM
--
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,
Urgent, Need Help, F
eans 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 long as ever you can.” - John Wesley*
> -
>
>
> On Wednesday, February 24, 2016 4:46 AM, amar takale
> wrote:
>
>
>
> Dear Paul Sir thanks very much fo
ement to match the "current" row.
> *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 long as ever you can.” - John Wesley*
> -
--
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,
Urgent, Need Help, F
Dear Mandeep
pls help me on this issue
On Fri, Feb 19, 2016 at 6:33 PM, amar takale wrote:
> Pls look in this issue
>
> -- Forwarded message --
> From: amar takale
> Date: Thu, Feb 18, 2016 at 5:55 PM
> Subject: Re: $$Excel-Macros$$ Re: VBA Code for Crea
Dear All,pls guide me above issue & How many name range we kept in
excel,there are any limitation?
On Wed, Feb 17, 2016 at 2:14 PM, amar takale wrote:
> Dear Mandeep,I want also VBA Code create unique sector name range in sheet
>
> On Tue, Feb 16, 2016 at 5:38 PM, amar takale wro
Dear Mandeep,I want also VBA Code create unique sector name range in sheet
On Tue, Feb 16, 2016 at 5:38 PM, amar takale wrote:
> Dear Mandeep Sir,
>
> Hi,I have small issue in this matter (all is OK in sheet as per my mind)
> but when code create name range then (Ctrl+F3) then it
l create name range through
data validation.
Another small request can we extract unique sector name in column A in
output sheet & then from B column code work as previous.
Regards
Amar
On Mon, Jan 25, 2016 at 6:32 PM, amar takale wrote:
> Dear Mandeep sir,
>
> Suprb..
>
Dear Mandeep
Very Helpful and thanks providing this helpful knowledge regarding date
solution.
And Thank you very much for all
Regards
Amar
On Mon, Feb 8, 2016 at 3:06 PM, Mandeep baluja
wrote:
> Hey Amar,
>>
>
> While doing manipulations with date you must ensure the Format of System
Dear all thanks for reply but i cant understand what you say.I except only
date formula in column D.
On Sun, Feb 7, 2016 at 9:36 PM, GENIUS wrote:
> LOOK AT THE ATTACHMENT
>
> --
> 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 Fac
Dear All
Here I required Date formula for Age Calculation but in cell date there are
some issue Value or text cell format,I cant understand. pls look matter,i
try it helper column but some date issue again.
Pls provide Date formula without helper column
Regards
Amar
--
Are you =EXP(E:RT) or =N
Dear Mandeep sir,
Suprb..
Thank you all for your help. I greatly appreciated it
Regards
Amar
On Mon, Jan 25, 2016 at 1:24 PM, Mandeep Baluja
wrote:
> Check this out !!! Regards, Mandeep baluja
>> https://www.linkedin.com/messaging/thread/6086488646137958400
>
> https://www.facebook.com
Dear All
Here I want VBA code for creating Name Range (Ctrl+F3).If there are few
companies then it is possible to create name rage for each sector but if
there are more than 100 companies with different sector in both column then
there are a lot of time consuming.So i want this code.
If we click
Dear Mandeep Sir
Wow.
Perfect,You are done it………
I am really thankful for its wonderful VBA Coding. Sorry for late reply due
to heavy workload.
It's Great output for this Group.
Regards
Amar
On Tue, Jan 19, 2016 at 4:51 PM, Mandeep Baluja
wrote:
> Check this out and let me know !!
s in kept.if I will search then all sheet will
be open one by one & a lot of time waste.Through VBA Code I search that
number or word excel sheet directly So a lot of time save for me.thats it.
Regards
Amar Takale
On Tue, Jan 19, 2016 at 11:39 AM, Mandeep Baluja
wrote:
> This can be achi
Dear All experts team,
Good morning!
Question: how to search specific text or numbers in excel folder.
I have folder where there are a lot of excel sheet ( more than 100) & I
have to search specific text or numbers in all excel from that folder.If I
search specific text or numbers through VBA co
Dear Mandeep thank for reply,can you give me this sheet after adjust this
code in one module
On Mon, Dec 7, 2015 at 5:38 PM, Mandeep Baluja
wrote:
> Hi Amar,
>
> There are many ways to do it, it depends on you what you're looking for
> ,This can be achieved with the help of Helper Column, with F
Dear Mandeep sir
I required output is same as you send exact i want. I say you there are
need k sheet for criteria(more & less than 0)? if we give this criteria in
code then it is ok or not?
Regards
amar
On Mon, Dec 7, 2015 at 3:45 PM, Mandeep Baluja
wrote:
> Find the attachment and let me know
Exactly ,continuous positive growth means all arrows should move upwards
after click Positive Button & same for negative.
On Mon, Dec 7, 2015 at 2:24 PM, Mandeep Baluja
wrote:
> How to judge the negative trend, I can't see any value which is negative
>> here, What pattern needs to follow,
>> con
Dear All
Here I want VBA code for sorting Positive & Negative numbers (%)
Criteria Match like: J to P Column Collect all cell Positive growth (%)
J to P Column Collect all cell Negative growth (%)
If I click Positive tab then all positive growth rows sort one click, same
as negative
(Mea
r,*
>
> My query is different.
>
> which i had mentioned in excel sheet
>
>
>
>
> *Regards, Kumar Bhanushali*
>
>
>*Re: $$Excel-Macros$$ Re: Latest Value & date extract formula required*
> *amar takale * to: excel-macros
> 30-06-15 05:44 PM
>
>
ook.com/groups/825221420889809/
> https://www.linkedin.com/profile/view?id=312532939
>
>
>
> On Tuesday, June 30, 2015 at 12:58:29 PM UTC+5:30, amar takale wrote:
> PFA
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:
n.com/profile/view?id=312532939
>
>
>
> On Tuesday, June 30, 2015 at 12:58:29 PM UTC+5:30, amar takale wrote:
>>
>> PFA
>>
> --
> 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 th
PFA
--
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,
Urgent, Need Help
is is for you bro.., do post query in following for further doubts...
>
> ExcelVbaLab.com
>
> Cheers!!
> ExcelVbaLab.com
>
> On Sat, Jun 20, 2015 at 3:03 PM, amar takale wrote:
>
>> PFA
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
PFA
--
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,
Urgent, Need Help
, Mar 7, 2015 at 11:48 AM, amar takale wrote:
>
>> pfa
>>
>> On Sat, Mar 7, 2015 at 11:47 AM, amar takale
>> wrote:
>>
>>> Dear Paul
>>> Superb idea for simple formula.but i do same as per use offset formula
>>> but chart not change as per
eing late. Kindly find the attachment.
>>
>> On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote:
>>
>>> Dear experts
>>>
>>> I want to update chart as per date change in cell I3 & J3.means between
>>> date range. i think it done by offset f
thanks vaibhavji
On Sat, Feb 28, 2015 at 11:35 AM, Pol Ktk wrote:
> very nice & easy solution
>
> On 23 February 2015 at 20:36, Vaibhav Joshi wrote:
>
>> Convert all date in same format:
>>
>> While receiving data from different sources many time it happens that
>> data received is not in same
PFA
On Fri, Feb 27, 2015 at 6:21 PM, amar takale wrote:
> Dear Sourab
>
> How to do it in one attempt only *1 in column B.When I extract date from
> our database software then paste it one excel then I do *1 to all date but
> answer is Value,why?
>
> Regards
> Amar
>
HAV
>
> WORKING PERFECTLY
>
> On Thu, Feb 26, 2015 at 12:01 PM, amar takale
> wrote:
>
>> pls look sheet where sheetl1 not change as per you saying. Pls explain me
>>
>> On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote:
>>
>>> Dear Amar
>>>
s!!
>
> On Wed, Feb 25, 2015 at 5:11 PM, amar takale wrote:
>
>> Dear Vabs bro thanks very much for this knowledgeable trick.
>> I discuss here attached file for date issue not converted in same format
>> as per your trick,why? i always use text to column operation trick
Dear Vabs bro thanks very much for this knowledgeable trick.
I discuss here attached file for date issue not converted in same format as
per your trick,why? i always use text to column operation trick for same
format.
On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi wrote:
> Cheers Chandan & Gaura
Can any body help me
On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote:
> Dear experts
>
> I want to update chart as per date change in cell I3 & J3.means between
> date range. i think it done by offset formula through name range.
>
> pls guide me
>
> Regards
>
Dear experts
I want to update chart as per date change in cell I3 & J3.means between
date range. i think it done by offset formula through name range.
pls guide me
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 Fac
Dear Experts Pls tell me solution.
On Tue, Jan 20, 2015 at 10:59 AM, amar takale wrote:
> any solution?
>
> On Mon, Jan 19, 2015 at 4:24 PM, amar takale wrote:
>
>> Dear Experts
>>
>> Can anybody tell me why this word not change its pagesetp format. We can
>>
any solution?
On Mon, Jan 19, 2015 at 4:24 PM, amar takale wrote:
> Dear Experts
>
> Can anybody tell me why this word not change its pagesetp format. We can
> change word page setup through VBA code OR destroy this word file page
> setup through VBA code.
>
> Regards
&g
Dear Experts
Can anybody tell me why this word not change its pagesetp format. We can
change word page setup through VBA code OR destroy this word file page
setup through VBA code.
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) ! J
Dear all my excel master friends
Wishing you a fabulous 2015 with full of great achievements and experiences
Regards
Amar
On Thu, Jan 1, 2015 at 12:13 PM, Sandeep Sharma
wrote:
> Welcome and wish u Happy new year all Group members.
>
>
> With Regards
> Sandeep Kumar Sharma
>
> “Always laugh wh
BAEXCELSQL?ref=hl
>
> On Wednesday, December 24, 2014 5:20:56 PM UTC+5:30, amar takale wrote:
>>
>>
> --
> 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.facebo
Dear zafar
PFA
On Thu, Dec 25, 2014 at 5:17 PM, Zafar Iqbal wrote:
> Format of B5:D5 is TEXT and B7:D7 is General. If Both rows will have same
> formats then you will get same answer & visa vera.
>
>
> On Wednesday, December 24, 2014 2:50:56 PM UTC+3, amar takale wrote:
&
ec 24, 2014 at 6:44 PM, amar takale wrote:
>>
>> Dear experts team,
>>
>> I required formula to extract data as par my criteria but it is very
>> complex criteria but my thought is that everything is possible in
>> excel.
>>
>> Appreciate the he
Dear All our experts members,
Wish u all A Merry Christmas
May the Joys of the season
Fill your heart with goodwill and cheer.
May the chimes of Christmas glory
Add up more shine and spread
Smiles across the miles
Today & In the New Year.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Dear experts team,
I required formula to extract data as par my criteria but it is very
complex criteria but my thought is that everything is possible in
excel.
Appreciate the help.
Let us know in case of any further assistance.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
--
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,
Urgent, Need Help, F
ompleted...", vbInformation
>
> End Sub
>
>
>
> Regards,
> Mandeep Baluja
> Excel Specialist.
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
> On Tuesday, December 2, 2014 1:01:46 PM UTC+5:30, amar takale wr
ashish this is not useful for me
On Tue, Dec 2, 2014 at 2:01 PM, Ashish Kumar wrote:
> Hi Amar,
>
> Check this :-
>
> SubJect - Copy paste data from one sheet to another based on click
>
> Query Raised in Group - 28th Nov, 2014.
>
> Status - Resolved.
>
>
>
> Regards
> Ashish
>
> --
> Are you =EX
Dear all
Pls suggest me VBA code for move or copy define name range one sheet
to another sheet.Then it is helpful & time saving for me.
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 @
h
1 - 100 of 459 matches
Mail list logo
