HI PAUL
THANKS A LOT PAUL..IT REALLY WORKED..THAT WAS A PATIENT ANSWERFULL
PRAISES FOR YOU
JUST ANOTHER DOUBT..CAN THIS BE DONE THROUGH WINDOWS DOS COMMAND..I DONT
WANT USERS TO DO ALL THIS.. ANY HOW AM RUNNING A SHELL COMMAND FROM EXCEL
..IS THERE ANY WAY TO DO THIS WORK ALSO..
REGARDS
L
Oh. . . . . that's awsome :)
It is a good approach if u dont want to keep the history (previous month).
Best Regards,
DILIPandey
On 10/13/10, renuka chari wrote:
> HI DILIP THANKS
> FINALLY I GOT A ANSWER WITH OUT USING FORMULA SELET ENTIRE COL AND FIND
> (CTRL+F) ENTER 10/11/2010 & REPLACE 11
Hi Siti Vi
Sorry for that..This was the new query..i should have posted new link
for this ...anyhow i apologize for this
Reagrds
L SUDHEER
On Wed, Oct 13, 2010 at 7:38 PM, Paul Schreiner wrote:
> How is this related to "Delete of a value Deltes that from every sheet" ??
>
> is this a ne
You explained the logic in a precise and logical manner.I really appreciate
your way of explaining.
So nice of you Mr.Paul.
Thanks & Regards,
C.G.Kumar
On Wed, Oct 13, 2010 at 7:48 PM, Paul Schreiner wrote:
> Let's examine what you're asking:
>
> (Now) returns the current date and time.
>
>
Heloo Everyone,
I have this problem whenever i try to create a refreshable web query. As
soon as i eneter the link in the web address bar the window appears which
asks something like "this page contains a script, do you wish to continue?"
now i do click yes, but this message appears again so fast
Here is my formula
=IF($H$2<='C:\Documents and Settings\All Users\Documents\Budget
\Finances\2010\[Budget_Estimation_Tys.xls]Sheet1'!$B$2,"Within
budget","Over budget")
H2 is the Average per month calculation , this is correct and the
formula is working correctly for averaging.
B2 is the estimat
Assume an email has n attachments of a combination of .txt and .xlsx files.
How do I read the contents of the attachment(which is a .xlsx or .txt) and
compare them with n files that I have on a local disk.
For e.g. Email has File1.txt and File2.xlsx as attachments.
Local drive has ABC.xlsx and DEF
On Thu, Oct 14, 2010 at 7:03 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Function_num
> (includes hidden values) Function_num
> (ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4
> 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM
Function_num
(includes hidden values) Function_num
(ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4
104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM 10 110
VAR 11 111 VARP
*use =subtotal(109,your-range)*
Note: 109 stands for SUM with ignores hidden valu
On Thu, Oct 14, 2010 at 6:49 AM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> use =subtotal(9,your-range)
>
> Note: 9 stands for SUM
> Please check the help for other function-num in help file.
>
>
>
>
>
>
> On Thu, Oct 14, 2010 at 12:26 AM, Rajesh K R
> wrote:
>
>> hi sriniv
use =subtotal(9,your-range)
Note: 9 stands for SUM
Please check the help for other function-num in help file.
On Thu, Oct 14, 2010 at 12:26 AM, Rajesh K R wrote:
> hi srinivasan
> thanks for your answer, but i have one more doubt is it possible to
> get a sum of the filtered values using a
hi srinivasan
thanks for your answer, but i have one more doubt is it possible to
get a sum of the filtered values using a macro or formula.
expecting your answer.
regards
rajesh
On 10/11/10, Srinivasan Ethirajalu wrote:
> updated one
>
>
> On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethi
Paste the below formula in D2
=IF(COUNTIF(A$2:A2,A2)=1,"Unique / First occurrence","Duplicate")
and copy paste the formula to the down cells in D column
On Wed, Oct 13, 2010 at 8:43 PM, vinod rao wrote:
> HI
>
> I have multipal duplicate numbers and excluding one for others it should
> say d
HI DILIP THANKS
FINALLY I GOT A ANSWER WITH OUT USING FORMULA SELET ENTIRE COL AND FIND
(CTRL+F) ENTER 10/11/2010 & REPLACE 11/11/2010 THEN FINALLY I GOT THAT.
On 12 October 2010 15:23, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
HI
I have multipal duplicate numbers and excluding one for others it should say
duplicate. how do i enter formula in 2003/2007
Thanks
Vinod
--
--
Some important links for excel users:
1. Follow us on TWITTER for tip
Thanks dilip .
On Wed, Oct 13, 2010 at 5:51 PM, Dilip Pandey wrote:
> Hi Rajasekhar,
>
> I believe you are using Excel 2007, this is what I have figured out after
> seeing your example of Pivots.
> I would suggest you to record macro with all the steps which you are doing
> manually and
A lot is going to depend on what your data looks like and what
you're trying to accomplish.
For instance
To ME, when you say that you want the "formula" to change,
my first interpretation is that if you select "Groceries",
you want the average, but if you select "Utilities",
then you want th
Nice try..
but you can't just make up your own Events.
If you go into the VBA Editor, and select the ThisWorkbook module,
in the Editor window, select "Workbook" in the left-hand pull-down.
Then look at the Right-Hand pull-down.
These are the ONLY workbook related events that excel allows.
The
How do you wish to supply the list of files?
Or are they all in a single folder?
Is it possible to create a Workbook_Open macro in each file? or would you
prefer
not to?
Is the macro name the same in each workbook?
If you're wanting to run macros in each file in a folder,
you can search this
Thanks dilip thanks alot its working good, but there is no option to change
month with out using formula
On 12 October 2010 15:23, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
> "&TEXT(TIME(HOUR(A1),MINUTE(A1),SECO
Let's examine what you're asking:
(Now) returns the current date and time.
Day(Now) returns the DAY portion of the current date and time.
So, when I run this today (10/13/2010), Day(Now) returns 13.
So.. the results of Day(Now) can ONLY be 1 to 31 (depending on the month)
it will NEVER be 0
Th
How is this related to "Delete of a value Deltes that from every sheet" ??
is this a new query?
Paul
>
>From: sudheer lolla
>To: excel-macros@googlegroups.com
>Sent: Wed, October 13, 2010 7:00:18 AM
>Subject: Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET
>
>Hi
>
>
>I ha
Is the XLSTART folder on a network drive?
How are you opening "any other excel"?
Are you double-clicking on an excel file?
First: a couple of definitions:
when you double-click the Excel icon (not a file, but the Excel application
icon)
It opens an "instance" of Excel.
It's like loading the ent
could you please put some sample data in an excel sheet and send it out and
then i can guide you
On Sun, Sep 26, 2010 at 9:39 AM, startingexcel wrote:
> Hi Experts,
>
> I have created a bit map after failing to get the pattern, I am not
> sure how to attach a document here, if anyone wants to he
Hiren,
This is simple table function. This is a one way table, it fills the
employee costs for the various range of employees in the rows of the table.
Go to help and type "data table" and you will understand the concept.
Cheers
Thanks
Rajesh Manjrekar
Excel consultant-9323045443
On Thu, S
Thanks Vishal
Its working
Can u explain how u done this (If its posible)
Once Again Thanks
Dharmesh Shah
On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
> NOW OPEN FILE AND U WILL SEE ADDIN MANU AND DHARMESH SUB MANU
>
>
> On Tue, Oct 12, 2010 at 12:39 PM, Dharmesh Shah
> wrote:
>
>
Hi Vijay,
Check the below attached lik...
http://www.ehow.com/how_5176467_embed-flash-game-excel-spreadsheet.html
On Wed, Oct 13, 2010 at 4:00 PM, viju mobile wrote:
> Hi All,
> Can anybody suggest me that how to insert flash game file in excel?
> Vijay Joshi
>
> --
>
> ---
Hi Rajasekhar,
I believe you are using Excel 2007, this is what I have figured out after
seeing your example of Pivots.
I would suggest you to record macro with all the steps which you are doing
manually and then try editing those codes as per your automation needs.
Alternatively, if you break do
Thanks Anand.. :)
Best Regards,
DILIPandey
On Wed, Oct 13, 2010 at 12:15 PM, anandydr wrote:
> Hi,
>
> The formula by Dilip works perfectly on the sample data provided,
> can't think of a better solution.
>
> Warm regards,
> Anand Kumar
>
> On Oct 12, 2:53 pm, Dilip Pandey wrote:
> > Hi Renuka
Hi
This is a very peculiar problem which am facing
i have an *xlsb* which has some macros and is placed in *XLSTART* folder
when an excel is opened the *XLSB* is attached to the *XLSX* file
i*am saying attached because when any other excel is opened,XL is popping up
message saying "XYZ.xlsb is
This is some urgent basis... Anyone can help me from this...
On Oct 13, 1:11 pm, sivam wrote:
> Hi,
> This is my situation. I want to remove some charaters
> like(,) from a single cell.
> For ex "Hi This Is Ram". Here "Ram" is bold letters. I want to
> remove that symbol from the cell witho
*Hi *
*
*
*I have developed a custom button with name "Only one applicable".After user
clicks that it does some functions.*
*i want this button to be disabled later.*
*
*
*AT ANY TIME USER SHOULD BE ABLE TO CLICK THAT BUTTON ONLY ONCE.LATER THAT
HAS BE GRAYED OUT.*
*
*
*HOW CAN THAT BE DONE I USED
gb
On Wed, Oct 13, 2010 at 2:18 PM, kaza deepu wrote:
> Hi Kashan Abbas,
>
> Find attached it may helps you.
>
>
> On 10/13/10, Kashan Abbas wrote:
>>
>> Dear All,
>>
>>
>> I have extracted a report from sap .The first column has been merged with
>> multiple information for which i need separe
Hi Kashan Abbas,
Find attached it may helps you.
On 10/13/10, Kashan Abbas wrote:
>
> Dear All,
>
>
> I have extracted a report from sap .The first column has been merged with
> multiple information for which i need separe column.
>
> The detail of information in first column is given as first
Oops, I forgot to mention, if you type the formula as I wrote it;
=SUMPRODUCT(--($G9:$AS9<=BV$3)*($G$9:$AS9>0),$G$4:$AS$4) and then
press Ctrl+Sfit+Enter, Excel automatically adds the braces {} to
denote an array formula. DO NOT type them yourself, or it will be
interpreted as text...
On Oct 13,
Dear Shantanu,
Siti Vi is quite right, you do need Ctrl+Shit+Enter to enter the array
formula. Also, you could simplify your formula a little by using a
double minus for the SUMPRODUCT, and do away with the IF. Minus minus
(--) converts SUMPRODUCTs TRUE/FALSE values to 1s and 0s. So you get:
=S
Hi,
This is my situation. I want to remove some charaters
like(,) from a single cell.
For ex "Hi This Is Ram". Here "Ram" is bold letters. I want to
remove that symbol from the cell without affecting the bold
character "Ram"
I also tried many ways. But i cannot remove those symbols without
af
Hi,
The formula by Dilip works perfectly on the sample data provided,
can't think of a better solution.
Warm regards,
Anand Kumar
On Oct 12, 2:53 pm, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
> "&TEXT(TIME(HOUR
i want to run this macro for today only , i am using following code but is
not working
if (day(now) ) = 0 then
' my code
end if
Looking your comments ...
On Wed, Oct 13, 2010 at 11:41 AM, siti Vi wrote:
> only work on day 5 to 10 of the month
>
>
> sub blablabla()
>
> if day(date) >= 5 and da
39 matches
Mail list logo
