HI Experts,
I am facing some challange in terms of understanding on of excel formula in
attached sheet.
Forumula is small and working fine and giving me result, but i am not able
to understand how its working.
SO kindly hlp mw understand the workability of this formula.
Formula :
Can anyone help pls..
On Sun 27 May, 2018, 1:56 PM Secret Shot, wrote:
> Dear Members,
>
> I am conducting Excel training in my office, is there any one can help me
> with any feedback form which i can give my students post training to fill.
>
> Thanks in advance please.
Can anyone pls help me here
On Sun 27 May, 2018, 1:56 PM Secret Shot, <secrets...@gmail.com> wrote:
> Dear Members,
>
> I am conducting Excel training in my office, is there any one can help me
> with any feedback form which i can give my students post training to fill.
>
Dear Members,
I am conducting Excel training in my office, is there any one can help me
with any feedback form which i can give my students post training to fill.
Thanks in advance please.
--
Pankaj Pandey
Bhopal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi All,
We are looking for Excel VBA and Access Expert who have excellent knowledge
of Excel, Macro, VBA, Dashboard designing, MS Access, Macro automation and
all.
Position for our head office Bangalore.
Salary can be negotiated based on current package.
Interested person please send me your
Hi Experts,
I have created a macro to automate my work.
Its working fine on my laptop, but if i am using same file for same folder
in my dasktop, its skip a action. its not giving any error but also not
doing what it soupose to do.
Below is the line of code which is not getting excuted, means
Hi Experts,
I am having a problem with one of my macro.
In my daily job, I have to do below mention task. .
I will have one Excel file, in which i will have sheet1, and on sheet1 i
will ahve a list of files.
on the basis i will have to move certen file from one location to subfolder
in same
Hi Experts, Can please anyone help me, i really needing for some help here.
On Sat, Jul 8, 2017 at 2:19 PM, Secret Shot <secrets...@gmail.com> wrote:
> Can anyone help me out here
>
> On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot <secrets...@gmail.com> wrote:
>
>>
Can anyone help me out here
On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot <secrets...@gmail.com> wrote:
> Hi Folks,
>
> I really need your help, in a case i am working.
>
> I am getting data in a word file, and i need a macro which can open that
> word file using "G
Hi Folks,
I really need your help, in a case i am working.
I am getting data in a word file, and i need a macro which can open that
word file using "Getfilename" option, then copy all data from that file and
paste into a excel sheet (Paste special).
I am trying below code but it is not working.
--
>
>
>
>
>
>
>
> *“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 Thursday
-
>
>
>
>
>
>
>
> *“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 Team,
I have one very large excel table which i made from Raw data, accidentally
raw data has been deleted and the only option i have is that table to
convert back in raw data.
Its about my job so pls help, i have attached of the sample of what i am
talking about. if anyone can me in
Hi Experts,
I have recently joined a job where i have to design new dashboard for any
new clients comes in.
I am okay with dashboard designing, but my boss has asked me to define a
proper process for dashboard designing , step wise step like discussion -
data gathering - planning - designing
Hi Experts,
I am stuck with one problem. I have one file which have numbers in it. but
while capturing they got stored as Text.
Now i want any formula to convert into normal Text. also there look like
another space in the cell but when i try to remove it backspace, last digit
of number got
Dear Expert,
I am trying to write Macro which navigate google chrome window (Entier open
and if already open than jump to mention window) and select particulate
link and click there (It can be either text based or courser location based
click)
after performing clicks it should download data
Hi Experts,
I have data of 1000 Emails, and text from body of the Emails is stored in a
cell. I want to do sentiment analysis to get customer inshght.
Can any one suggest any free Speech analysis tool of any Excel based Add-in.
Many Thanks
--
Pankaj Pandey
Bhopal
--
Are you =EXP(E:RT) or
Pls add 7899768143
On Aug 8, 2016 9:43 PM, "Rajeev Ranjan" <06raj...@gmail.com> wrote:
> please add the my number 9811503853
>
> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>
>> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you
>> wants to join.
>>
>>
ur first macro, instead of:
>
> Workbooks.Open (MyFile)
>
> use:
>
> Workbooks.Open (path & MyFile)
>
> HTH
>
>
> On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot <secrets...@gmail.com> wrote:
>
>> Hi all,
>>
>> Can anybody pls look into it.
Hi all,
Can anybody pls look into it. I am really hoping that I will get resolution
from this forum.
On Apr 28, 2016 1:35 AM, "Secret Shot" <secrets...@gmail.com> wrote:
> Dear Experts,
>
> I want to open all files in a folder with suffix of "L1", where i have
Dear Experts,
I want to open all files in a folder with suffix of "L1", where i have
below files in a folder
04 L1.Xlsx
04 L2.Xlsx
05 L1.Xlsx
05 L2.Xlsx
06 L1.Xlsx
06 L2.Xlsx
I want macro to open Only files which contain "L1", (Means 04 L1.Xlsx, 05
L1.Xlsx, 06 L1.Xlsx).
I created 2 macros but
Dear Expert,
Request you to kindly help me in the below query
I have date and time in text format in one cell like this
Apr 22 2016 1:58PM
I need a excel formula, whether inbuilt or customized to get the date and
time in actual formet like below
22 Apr 2016 1:58 PM
and it should be able to
Can anyone pls help me into this...
On Apr 4, 2016 2:57 PM, "Secret Shot" <secrets...@gmail.com> wrote:
> Dear Experts,
>
> I have some text in a cell like "Date Range: 3/31/16 - 3/31/16"
>
> I want to extract the date in a another cell like date not as te
Dear Experts,
I have some text in a cell like "Date Range: 3/31/16 - 3/31/16"
I want to extract the date in a another cell like date not as text only.
Can any one help me with any dynamic formula which can extract the date
from this cell text considering where the date can me change daily,
t RowNum
> fOut.writeline Str
> Wend
>
> '
> fIN.Close
> fOut.Close
> MsgBox "finished"
> End Sub
>
> *Paul*
> -
> Wend
>
> '
> fIN.Close
> fOut.Close
> MsgBox "finished"
> End Sub
>
> *Paul*
> -----
>
>
>
>
>
Dear Experts,
Greeting of the day,
I am new to XML coding, and got stuck somewhere.
Olease help me, I have one XML file with me, in which I want to change some
text using excel macro.
also the Replace what and Replace with text need to be taken from worksheet
cells.
I am attaching XML file as
;
>
>
> *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.
Dear Expert,
I am stuck in one very simple macro, and not able to find what's the
problem is.
Please help me with it as my entire work got stuck because of it.
I have three macros for same task, where first 1 is working perfectly and
opening the workbook "CUSTOMIZED REPORT.xlsx", But rest 2 are
Hi Guys,
Still waiting for some resolution in this group.
Pls help.
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot <secrets...@gmail.com> wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment
Hi Guys,
Cant anyone here help me pls. Does no one know OUTLOOK MACROS
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot <secrets...@gmail.com> wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment
Dear Experts,
I want help in macro which can attach 4 mail with standard subject line
into one mail as an attachment and send that mail to a particular distor
list. .
For example I receive mail1, mail2, mail3, mail4
then I want all 4 mails to be attaches in on mail (Mail All) as an
attachment
Hi experts,
Please in helping a dynamic formula to sum the value basis on Monday to
Sunday week. where the first day is dynamic of every month.
I have attached the excel file for explanation of problem . . .
please help, quick help would be much appreciate.
--
Pankaj Pandey
Bhopal
--
Are
At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, January 25, 2016 2:51 PM, Secret Shot <secrets...@gmail.com>
> wrote:
>
>
>
> Dear Paul,
>
> than
>
>
> *“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 Friday, January 22, 2016
Dear Experts,
I am, facing a problem with creating a macro, here is the attached workbook
where I need help,
I have several sheets named numerical, and few named as Set 1, set 2
etc and one mail sheet named ""List".
Now the list mention in "List sheet", based on that the data should be
Thanks Team XLS,
It works for me,
Thanks you so much..
On Sun, Nov 3, 2013 at 6:37 PM, xlstime xlst...@gmail.com wrote:
As desired, Please find attached sample sheet
.
Enjoy
Team XLS
On Sun, Nov 3, 2013 at 2:06 AM, Secret Shot secrets...@gmail.com wrote
Dear Experts,
I am working on a project and stuck at a very critical stage, I want help
in a macro for sheet protection.
where the condition is that I have to option in sells of column A using
(data validation) options are Pending and confirm, Now whenever i
select Confirm in any cell of column
Put = sign in cell A2 itself at the bagining of the text... :P
On Sun, Jul 28, 2013 at 1:46 PM, De Premor d...@premor.net wrote:
create defined name in example : *Eval**A2* that referring to
=EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59,
= xlCalculationAutomatic
End Sub
'=**==
Rgds,
[dp]
On 03/07/2013 0:19, Secret Shot wrote:
Dear Expert,
I need some help on one my query, I have a data set for example for few
Emp name and date of months from 1 to 31st, now on another sheet have i
have
the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Secret Shot secrets...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, May 16, 2013 12:52:34 PM
*Subject:* $$Excel-Macros$$ Macro to open
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
*-
--
*From:* Secret Shot secrets
Dear Group,
I need your expertise, in creating Macro to hide rows, requirement is
mention in attach file. I attached a sample file to explain my requirement.
please Help.
--
Pankaj Pandey
Bhopal
--
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 Group,
Kindly help me, i want to create Circles around the cells. means if i have
some Numbers in any excel sheet and i want circle to be created on cell who
have numbers less then 30.
please help me.
--
Pankaj Pandey
Bhopal
--
Join official Facebook page of this forum @
Submitted :)
On Mon, Nov 26, 2012 at 10:49 PM, Ayush Jain jainayus...@gmail.com wrote:
Thanks Vinay
Dear Group, only 6 days left for the quiz, give it a try and you will
learn something new
Looking forward to your active participation
Thanks
Best regards
Ayush Jain
Group manager
Dear Experts,
Can anyone help me in this please.
Regards
Pankaj k Pandey
On Thu, Nov 15, 2012 at 12:54 AM, Secret Shot secrets...@gmail.com wrote:
Dear Experts,
I am Preparing for MS Excel Expert Exam, can any one help me with the
study material and tips. i have already cleared my MS
SalesAid Software
dguille...@gmail.com
*From:* Secret Shot secrets...@gmail.com
*Sent:* Tuesday, August 07, 2012 6:13 AM
*To:* excel-macros@googlegroups.com
*Cc:* pankaj. pandey pankaj.pan...@firstsource.com
*Subject:* $$Excel-Macros$$ Excel Challange - Formula
Dear Members,
I am facing one
Also this formula is giving incorrect output.. :(
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 dguille...@gmail.com wrote:
See attached where I added defined names for sumproduct formulas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Secret Shot
http://www.vertex42.com/News/excel-web-query.html
http://www.jkp-ads.com/Articles/WebQuery.asp
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, May 9, 2012 at 8:18 PM, Secret Shot secrets...@gmail.com wrote:
Dear Expeart,
I want
Dear Expert,
I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.
Kindly help pls. i have tried with rank formula but it dosent work.
--
Pankaj Pandey
Dear group,
I want to make bucket of age like 0-2,2-4,4-6 etc.
However I can do this by if formula.
But that is very lanthy formula and also excel 2003 dose not support nested
if greater then 7.
So can anyone pls help me with any shortest way to do it pls.
Regards
Pankaj k pandey
--
FORUM
hi Noorain,
Can I Macro run thourth VBA Macro. Form Example I have to do certain
activity with dumps after axtracting, so can i write any macro to run i
macro first and then run Excel Macro..
Pls suggest.
Regards
Pankaj k Pandey
On Fri, Feb 17, 2012 at 5:46 PM, Amit Desai (MERU)
Dear Group,
I have design a VBA tool to capture data on Excel sheet. In this tool we
fill a VBA Form and data got captured on Excel sheet.
But most of the time i am getting Error no 9 Subscript Out of Range
Unable to identified that why is occure. Kindly Help.
--
Pankaj Pandey
Bhopal
--
Hay Guy,,
Can any one please Help me in this, this is really critical..
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 3:34 AM, Secret Shot secrets...@gmail.com wrote:
Dear Experts,
Greeting of the Day,
I am facing a very strength problem, I have created a workbook, which have
2
Hay Guy,,
Can any one please Help me in this, this is really critical..
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 4:26 AM, Secret Shot secrets...@gmail.com wrote:
Dear Experts,
Can anyone please tell me that how to Enable Activex Setting in Excel
2003. I know how to do
Dear Rajan,
Its not working for me... :(,
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 8:50 PM, rajan verma rajanverma1...@gmail.comwrote:
Hope it will help
http://www.mrexcel.com/forum/showthread.php?t=71323
On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot secrets...@gmail.com wrote:
Hay
Dear Experts,
Greeting of the Day,
I am facing a very strength problem, I have created a workbook, which have
2 Text box and 2 Command Button in on a worksheet. but when i
am opening this workbook so some time after opening the Text box and
Command not appearing. This problem is occurring
Dear Experts,
Can anyone please tell me that how to Enable Activex Setting in Excel 2003.
I know how to do this in 2007.
Excel OptionTrust Center Trust Center SettingActiveX Setting
But don't know hot to st thins in Excel 2003, Please help me
I will appreciate quick help
Please
--
Pankaj
Dear Experts,
It there any Formula to count worksheets in a Excel File. I know VBA code
for this but i want any Formula or any combination of formula's only to
solve this. kindly Help. This is very critical for me.
Thanks in Advance..
--
Pankaj Pandey
Bhopal
--
FORUM RULES (934+ members
59 matches
Mail list logo
