Hi David,
Though it is working my main sheet. It is giving wrong results.
Can you please recheck? I have attached my actual numbers.
Thanks,
Sharad
On Saturday, August 11, 2012 5:26:32 PM UTC+5:30, David Grugeon wrote:
Hi Sharad
Use the following function in a general module. Then use
Dear dguillett dguille...@gmail.com Sir,
How to do it which stock price show?
And also VBA code create passwords So I cant see code.
Pls Explain it It is very useful for me to update comparative valuation.
Thanks
Amar
On Sat, Aug 4, 2012 at 6:23 PM, dguillett1 dguille...@gmail.com wrote:
Don
Hi Group,
I have a project which is running fine on my system with XP OS but the same
project giving error of Out of Memory 7 on other system with XP platform.
I am using VBA and Acess as data source. I tried my level best to track
the source of error but not able to find it.So can you pls
This is Great Noorain Sir
Thanks Noorain for your effort.
Also, thanks to all the people in the group for help.
On Mon, Aug 6, 2012 at 5:56 PM, Venkat CV venkat1@gmail.com wrote:
Congrats Noorain.
--
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 3, 2012 at 11:10 PM,
Great Job Mr Noorain !!!
Keep on your helps in this and we will expect you as world familiar in this
expert ices.
Thanks Regards,
Ganesh
On Tue, Aug 14, 2012 at 2:21 PM, amar takale amartak...@gmail.com wrote:
This is Great Noorain Sir
Thanks Noorain for your effort.
Also, thanks to all
Hi Prince
Is there any reason not to think that an Out of memory message mens that
the computer is out of memory.
There are a number of possible causes which could include:
Not enough physical memory
Too many other programs running
Not enough disk space for paging memory
A program (not
Ahh... I see what you're trying to do.
Your worksheet has formulas.
on any given day, you want to freeze the previous values
so that they will no longer update.
You PROBABLY only need to freeze the current date,
because yesterday's data would have been frozen yesteday,
and the day before that
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B70,B1:B7))
=MIN(IF(A1:A70,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote:
hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me
Hi David,
Thanks a lot for your help on this. Really appreciate.
Best Regards,
Sharad
On Tue, Aug 14, 2012 at 3:19 PM, David Grugeon da...@grugeon.com.au wrote:
Sorry. I worked it for each input value being the cash flow for a year.
I see that you have put down a Year 0 and the cash flows
Dear Pravin,
Please use
=VLOOKUP(VALUE(A3),Sheet2!$B$1:$C$1886,2,0)
On Tue, Aug 14, 2012 at 5:32 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends
I have use a v-look up in Sheet 1 from Sheet 2 of the attached file.
*Please see the Sheet 1*
Look up value is available in column *A*
One problem is that your numbers in sheet1 are actually text strings.
while the matching column B in sheet2 are actual numbers.
I simply selected column A in sheet1 and replaced 1 with 1, 2 with 2, 3 with 3
and it converted the text to numbers
and located these values.
Paul
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
Send YOUR file to ME with this msg and I’ll take a look.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Tuesday, August 14, 2012 2:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ pls help me solve my query.
Dear
Hi Jayendra,
Please share a sample workbook with example
On Mon, Aug 13, 2012 at 11:31 AM, jayendra gaurav jayendra.gau...@gmail.com
wrote:
pls support me
On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav jayendra.gau...@gmail.com
wrote:
Team,
I am using excel 2007.
I have one file
thank u vijayajith and noorain ansari for your reply,
but i think u have mis understood my query.
i have written my query with a comment in another cell again,
Thanks and Regards.
--- On Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
From: NOORAIN ANSARI
Dear Kenil,
There is no attachment with this mail.
Please send attachment with comment.
On Tue, Aug 14, 2012 at 6:19 PM, Kenil Gala keni...@yahoo.com wrote:
thank u vijayajith and noorain ansari for your reply,
but i think u have mis understood my query.
i have written my query with a
Hello Group and Ayush,
Over the last few days, I have been missing some emails especially from
Noorain.
I use Thunderbird and all the emails from Noorain come marked with a
Suspected Scam warning. Result is that Thunderbird automatically
transfers such emails to the Trash Folder (These
File is same above name *GetYahooMultipleHistoryALL_SAS_P1.xls which
attached above.*
On Tue, Aug 14, 2012 at 6:13 PM, dguillett1 dguille...@gmail.com wrote:
Send YOUR file to ME with this msg and I’ll take a look.
Don Guillett
Microsoft Excel Developer
SalesAid Software
Hi Guys,
Challenge is to Delete all Sheets Except one without any loop and mapping
table.
Keep Excelling
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
That file is mine and an example. I do custom programming at only $75 hourly
with UN protected code.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Tuesday, August 14, 2012 8:26 AM
To: excel-macros@googlegroups.com
Subject: Re:
Dear Karan,
Please follow rule no 5
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Tue, Aug 14, 2012 at 8:38 PM, karan karan.bhatia...@gmail.com wrote:
*Please send me the updated resumes @ ka...@hmgamerica.com
Network Engineer
A suggested way to do it in
http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/
Here's a slightly modified version of the same
Sub kTest()
Dim var As Variant
With Application
var = .Transpose(.Evaluate(Row(2: Sheets.Count )))
.DisplayAlerts = 0
Yes Sir,
Perfect
Thanks a Ton.
Thanks Regards,
--- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05
I am available for custom excel projects at only $75 hourly .
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kenil Gala
Sent: Tuesday, August 14, 2012 12:20 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and
I expect your IP is processing the email and identifying/deleting spam.
Contact them and ask them to whitelist the group for you.
On 14 August 2012 23:00, Ashish Pradhan ashlyprad...@gmail.com wrote:
Hello Group and Ayush,
Over the last few days, I have been missing some emails especially
Paul,
It's great this what I wanted
Thank you so so so so much
Pawel
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Tuesday, August 14, 2012 12:22 PM
Subject: Re: $$Excel-Macros$$ macro for detecting date in row
Dear Ayush,
Please ban thiS user
Sent from BlackBerry® on Airtel
-Original Message-
From: Karan Bhatia karan.bhatia...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 15 Aug 2012 01:36:30
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Required
Dear Ayush,
Please allow me to send the greetings to my friends for a moment.
Happy independence day to all
my Indian brothers
Happy Independence Day
-
Regards,
Muneer,
CC...
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
What is your issue.? Please explain
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please
I want word wrap option to be active in excel - its effect should be
like this.
Condition 1 : the word / font train should not cross the page break
line.
Condition 2 : on the completion of one line the font should adjust the
line previous and jump to the another cell or row to
Dear Rajan,
See the attached sheet (Word Wrap 1)
Ref: to the reply
And thanx for the reply
Regards,
Muneer,
CC
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
31 matches
Mail list logo