Sorry , can't help directly but suggest this:
Presuming you have loaded the Excel Analysis Toolpak,click
Office button/Options/AddIns/Analysis Toolpak + vba Analysis
Toolpak
then click the Excel "?"
?/All Help/Function Reference/STATISTICAL
Here you can find explanations,formulae and E
There are various ways.
you can use additem in your code or you can use "RowSource" property of the
combo box.
for using property what u shud do is you type required data in cells. then name
those cells by selecting all the cells which u want to name then right click it
then select "Name a Range
I am not aware of all the functions but 1st 4 (i guess all) are for statistical
analysis. you can explore them on Excel help with below Functions
Correlation :- CORREL
T-Test :- TTEST
Chi-Square :- CHITEST
From: NOORAIN ANSARI
To: excel-macros@googlegroups.c
I am trying to send information to the referenced website and have it return
a pdf file. I have "referenced" WinnHTTPservers, but this code doesn't seem
to connect to the website.
What am I doing wrong
Dim cr As InternetExplorer
'
Set cr = New InternetExplorer
cr.Visible = True
'
Dim http As W
Hi,
attached is the file which has ur solution (Hopefully).
it has some conditions which u have to follow else output will be wrong
Below are the conditions
1] It will get or clear total and subtotal for both the Halves.i.e. 2008-09 and
2009-10.
2]Do no click on any button more than once unless
I'm having a TERRIBLE time attempting to send my test file to anyone
or this group. My company email client won't allow it to go through.
SO...I'll attempt to show an example of my request within this
posting.
WITH PRINCIPAL
Dates Match Dates Do Not Match
STATUS E
Folks,
Did anyone had a chance to look at the file ?
Any ideas/suggestions are welcome.
Thank you,
Shiva
On Jan 28, 8:43 am, shiva kashyap wrote:
> Ankur,
>
> Please see the attached file. In this file I am only testing 4 worksheets (
> there will be 6 more when final file is generated).
>
>
I have a excel file in which a cell value is 0;
when i look into xml the value is 0.0
and the workaround for this problem is carry any changes and save then
the xml shows 0
WHAT IS THIS TYPICAL PROBLEM
--
--
Some imp
I have a excel file in which a cell value is 0;
when i look into xml the value is 0.0
and the workaround for this problem is carry any changes and save then
the xml shows 0
WHAT IS THIS TYPICAL PROBLEM
--
--
Some imp
alright let us know if you require any help
On Fri, Jan 28, 2011 at 2:51 PM, Seba wrote:
> Hi,
>
> I made the following adjustment (marked with stars). It works fine. Do
> you see any error in code or possible improvements? I will make an
> addtional macro for: removing double entries + deletin
I'm not sure what constitutes a "repetitive record".
Since I would have thought that the last two rows of your
sample data repeat, yet you included all of them in the
sample output...
So, based on what little you've given us...
I put together this macro:
'
now check...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 12:14 PM, Usha Negi wrote:
> Thank you very much for your reply. But I checked subtotal for all zones it
> does not match. also I want to have subtotal after every quarter. Kindly see
> attached file.
>
> Thanks
> Usha
> On Fri, Jan 28,
Please send the excel file.
On Fri, Jan 28, 2011 at 1:31 PM, vikalp wrote:
> hellow everybody,
> kindly help me with the problem i am facing i want to remove
> repititive record from folloeing data and get useful data for the
> perpose of mailmerge example is given bellow
> example data I have
Dear Experts,
Kindly explain below given excel functions with example.
Correlation Multiple Regression T-Test Chi-Square ANOVA Factor Analysis
--
Thanks & regards,
Noorain Ansari
--
--
Some important links fo
I think This might be help you
```Office 2010 Retail Keys`
"""
-
Office Professional Plus 2010 Retail Keys
Hi,
I made the following adjustment (marked with stars). It works fine. Do
you see any error in code or possible improvements? I will make an
addtional macro for: removing double entries + deleting rows with
value=0 + sorting
My modification:
--
Sub co
hellow everybody,
kindly help me with the problem i am facing i want to remove
repititive record from folloeing data and get useful data for the
perpose of mailmerge example is given bellow
example data I have
a b c d
1 x 20 35
1 x 25 35
1 x
Thank you very much for your reply. But I checked subtotal for all zones it
does not match. also I want to have subtotal after every quarter. Kindly see
attached file.
Thanks
Usha
On Fri, Jan 28, 2011 at 11:40 AM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Hi Usha,
>
> check the attac
18 matches
Mail list logo
