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 :
=LOOKUP(1234,S
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, 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.
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 re
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 th
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 loc
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 wrote:
> Can anyone help me out here
>
> On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot wrote:
>
>> Hi Folks,
>>
>> I really need your help, in a
Can anyone help me out here
On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot 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 "Getfilename" option, then
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, June 1, 2017 1:42 PM, Secret
---
>
>
>
>
>
>
>
> *“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 writing
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 etc.
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 delete
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 from
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 =N
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.
>>
>> A
gt;
> Workbooks.Open (MyFile)
>
> use:
>
> Workbooks.Open (path & MyFile)
>
> HTH
>
>
> On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot wrote:
>
>> Hi all,
>>
>> Can anybody pls look into it. I am really hoping that I will get
>> resoluti
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" wrote:
> Dear Experts,
>
> I want to open all files in a folder with suffix of "L1", where i have
> below files in a fo
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 b
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 ch
Can anyone pls help me into this...
On Apr 4, 2016 2:57 PM, "Secret Shot" 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 text only.
>
> Can any o
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,
somet
fOut.writeline Str
> Wend
>
> '
> fIN.Close
> fOut.Close
> MsgBox "finished"
> End Sub
>
> *Paul*
> -
>
>
d
>
> '
> fIN.Close
> fOut.Close
> MsgBox "finished"
> End Sub
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do a
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
ul*
> -
>
>
>
>
>
>
>
> *“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 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 wrote:
> 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 parti
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 wrote:
> 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 parti
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 an
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 you
can,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
> wrote:
>
>
>
> Dear Paul,
>
> thanks for looking in to it. But I am not getting any option to unprot
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 2:50 PM, Secret Sh
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
copie
Thanks Team XLS,
It works for me,
Thanks you so much..
On Sun, Nov 3, 2013 at 6:37 PM, xlstime wrote:
> As desired, Please find attached sample sheet
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Sun, Nov 3, 2013 at 2:06 AM, Secret Shot wro
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 col
Dear Exterts,
I am stuck in my project and need your expert advice that ho can i prevent
duplicate data entry in any colom, but i have to use list validation too at
the same time
So for example my source range is G1:G10 on the basis of this i need to put
list validation on range A1:A10, but i wan
Put "=" sign in cell A2 itself at the bagining of the text... :P
On Sun, Jul 28, 2013 at 1:46 PM, De Premor 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, xlstim
i.Offset(0, 2).Value
> End If
> Next
> Application.ScreenUpdating = True
> Application.Calculation = xlCalculationAutomatic
> End Sub
>
> '=**==
>
> Rgds,
> [dp]
>
>
> On 03/07/201
& "Book1.xls"
> ' copy stuff ...
> Workbooks("Book1.xls").Close savechanges:=False
> Application.ScreenUpdating = True
> Copy_FileData = True
> End Function
>
>
> *Paul*
>
> -
> *“Do
> *“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 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 Friends,
I need your expert advice in a Formula, I will have to create a Smallest
formula to calculate employees leave balance. this formula would calculate
that how many leaves will carry forward
of an employee. Conditions are mention below.
If Employee joining date is before 1-Jan-12 and h
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 @
https://www.face
Submitted :)
On Mon, Nov 26, 2012 at 10:49 PM, Ayush Jain 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
>
> On Nov 26
Dear Experts,
Can anyone help me in this please.
Regards
Pankaj k Pandey
On Thu, Nov 15, 2012 at 12:54 AM, Secret Shot 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 clea
Also this formula is giving incorrect output.. :(
On Tue, Aug 7, 2012 at 9:16 PM, dguillett1 wrote:
> See attached where I added defined names for sumproduct formulas
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *Fro
lesAid Software
> dguille...@gmail.com
>
> *From:* Secret Shot
> *Sent:* Tuesday, August 07, 2012 6:13 AM
> *To:* excel-macros@googlegroups.com
> *Cc:* pankaj. pandey
> *Subject:* $$Excel-Macros$$ Excel Challange - Formula
>
> Dear Members,
>
> I am facing one challa
gt; web-queries/6115870
>
> 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:1
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
Bhopa
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 RULES
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)
wrote:
> Dear
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
--
FOR
Dear Rajan,
Its not working for me... :(,
Regards
Pankaj k Pandey
On Sat, Dec 3, 2011 at 8:50 PM, rajan verma wrote:
> Hope it will help
> http://www.mrexcel.com/forum/showthread.php?t=71323
>
>
> On Sat, Dec 3, 2011 at 8:16 PM, Secret Shot wrote:
>
>> Hay Guy,,
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 wrote:
> Dear Experts,
>
> Can anyone please tell me that how to Enable Activex Setting in Excel
> 2003. I know how to do this in 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 3:34 AM, Secret Shot wrote:
> Dear Experts,
>
> Greeting of the Day,
>
> I am facing a very strength problem, I have created a workbook, which have
>
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 Option>Trust Center> Trust Center Setting>ActiveX Setting
But don't know hot to st thins in Excel 2003, Please help me
I will appreciate quick help
Please
--
Pankaj
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 rendom
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 alrea
61 matches
Mail list logo
