Your welcome Mr Renuka...
Pramod
On 15 Oct 2014 10:12, "renuka chari" wrote:
> Thank you mr. Pramod, this is only i am expecting thanks alot..
>
>
>
> On Wednesday, 15 October 2014 08:59:44 UTC+5:30, pramodb35 wrote:
>>
>> Hi Renukachari,
>>
>>
>> Please find the attachment as per your requi
Thank you mr. Pramod, this is only i am expecting thanks alot..
On Wednesday, 15 October 2014 08:59:44 UTC+5:30, pramodb35 wrote:
>
> Hi Renukachari,
>
>
> Please find the attachment as per your requirement..
>
> On Wed, Oct 15, 2014 at 12:10 AM, Paul Schreiner > wrote:
> > I'm sorry
Hi Renukachari,
Please find the attachment as per your requirement..
On Wed, Oct 15, 2014 at 12:10 AM, Paul Schreiner wrote:
> I'm sorry, but there's nothing in the attachment that describes any type of
> "serial number".
>
> In fact, I'm not even sure WHAT it is describing.
> It seems
Try this
=TRIM(MID(SUBSTITUTE($A15;"|";REPT(" ";99));(COLUMN(A1)*99)-98;99))
the idea is replacing a pipe char with 99 times white space using
SUBSTITUTE so we can trim it later to get the exact word
then we break it a part every 99 char using MID function, and then
remove the white space usin
I'm sorry, but there's nothing in the attachment that describes any type of
"serial number".
In fact, I'm not even sure WHAT it is describing.
It seems to be a checklist of some sort.
Does it mean that the serial number is supposed to be a 21-characters and each
character can be of the values
What is criteria for serial #. Please enlighten..
On Tue, Oct 14, 2014 at 11:36 PM, Renukachari Kasee
wrote:
> Dear Group,
>
> Please provide the macro for serial Number as per attached sheet
>
> Thankss
>
> *♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
>
> *P Let us do our best to save nature,
Dear Group,
Please provide the macro for serial Number as per attached sheet
Thankss
*♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sou
If you create a Public variable (in a "Standard" module, outside of any macros)
Like:
public Cur_SysSep as boolean
then, in the beginning of workbook_open use:
cur_SysSep = application.UseSystemSeparators
at the end of the macro, simply use:
Application.UseSystemSeparators = Cur_SysSep
P
Hi
Plz provide VBA code for extract .rar file.
On Oct 14, 2014 7:23 PM, "Dr. Schwartz" wrote:
> I have a workbook that is opened by many users in different environments.
> My goal is to determine the value of *Application.UseSystemSeparators*
> (True/False) using the Workbook_open() and somehow s
Plz provide VBA code for extract .rar file.
On Oct 14, 2014 7:23 PM, "Dr. Schwartz" wrote:
> I have a workbook that is opened by many users in different environments.
> My goal is to determine the value of *Application.UseSystemSeparators*
> (True/False) using the Workbook_open() and somehow save
I have a workbook that is opened by many users in different environments.
My goal is to determine the value of *Application.UseSystemSeparators*
(True/False) using the Workbook_open() and somehow save the value so that I
can set it back using Workbook_BeforeClose(Cancel As Boolean). The order is
The problem seems to be with morning entries between midnight and 1:00am.
in the time() function, 12 is noon rather than midnight.
so the function thinks the time is after noon in stead of after midnight.
To fix that you can subract 12 from the hours.
If the result is negative, the time() functio
Ok, check revise sheet, if payment mode is annual then you need to
calculate emi for a year & not month.
Check revise sheet..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 14, 2014 at 2:10 PM, Falina Gan wrote:
> yearly
>
> On Tuesday, October 14, 2014
yearly
On Tuesday, October 14, 2014 3:34:22 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> May I ask, how do we calculate the ROI as I have upload the excel.
>
> Thanks.
>
--
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) ! Join offic
Is re-payment is monthly or annually?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 14, 2014 at 1:04 PM, Falina Gan wrote:
> To Whom It May Concern,
>
> May I ask, how do we calculate the ROI as I have upload the excel.
>
> Thanks.
>
> --
> Are you =EXP(
To Whom It May Concern,
May I ask, how do we calculate the ROI as I have upload the excel.
Thanks.
--
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) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Dear Paul,
Thank you very much your help, i have applied your formulas in my sheet and
it works perfect. I am facing problem in total hours, it is showing some
wrong figure.
Can you please help on this. Attached is the sheet.
2014-10-13 20:59 GMT+05:30 Paul Schreiner :
> As you undoubtely not
17 matches
Mail list logo
