One more question
1. If in table one Product No. not sory by (A,B,C) but it alternate (Example
C,A,B or A,C,B)
(See green hightlight)
2. How can I get it on table 4 ?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Friday, September 07,
try this
in tools/references click browse. go to the c:\windows\syswow64
directory. find mscomct2.ocx and add it.
On 8 September 2012 02:58, james D wrote:
> I tried that, nothing
>
> On Friday, 7 September 2012 17:38:42 UTC+1, james D wrote:
>>
>> Hi.
>>
>> I am a VBA developer (Excel mainly)
Hi Experts,
I am also looking for this solution, can you please help.
Regards, Anil Bhange
IP Phone - 800105 | Mobile - +31 6 1192 3971
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Dhananjay Pinjan
Sent: Wednesday, August
Hi All,
First of all thanks to all experts who helping to the world with their
expertise knowledge and giving such a big opportunity to learn Excel and VBA so
closely.
I also wanted to learn similar kind of logics and participate in discussion for
gaining knowledge of SAP FI CO Module, if you
Why cant these guys see that I don't want to take the time (and risk)
of downloading a file unless I know I can contribute and/or I find the
problem interesting.
Another issue I have is that some users change the subject when
replying. this breaks up conversations, So please do not add
anything
Hi Don,
Thanks for your post,
I was trying to understand the formula, if we use array formula then below
highlighted cells also getting fixed and formula is not giving the proper
result,
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0))
Can you please share the formula in excel file, to understand be
The numbers are strings too
=LOOKUP(A2,{"0","1","2","3","4","5","6","7","8","9"},{"#","#","#","#","#","#","#","#","#"})
Regards
David Grugeon
On 8 September 2012 03:57, Paul Schreiner wrote:
> Sorry, I copy/pasted the wrong one.
> I'm still having trouble inserting it as an array function.
>
>
Second Don on it. Ppl should understand its a voluntary forum!
Cheers
Rahul
Sent from BlackBerry® on Airtel
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Fri, 7 Sep 2012 14:36:13
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
Why is your request more URGENT than any other request??
When all else fails, "read the f___ing instructions"
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not b
Is there some reason you cannot “google” it yourself
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: maksood alam
Sent: Friday, September 07, 2012 12:50 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas
Hi
Thats Great !!!
On 9/8/12, dguillett1 wrote:
> me too..
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> From: Paul Schreiner
> Sent: Friday, September 07, 2012 11:16 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Urgent... Pl
me too..
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Friday, September 07, 2012 11:16 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here)
Is it me? or does the
Hi Anil,
a lot of thanks!
for help me, you reduced my workload of a month, in some moment.
Thanks
Pravesh
On 9/7/12, अनिल नारायण गवली wrote:
> Dear Pravesh,
>
> See i have changed the dropdown working .
> pls do the color , as i'm busy with other work.
>
> On Fri, Sep 7, 2012 at 9:48 AM
Strange! I can enter it as an array function =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,
9},{"#","#","#","#","#","#","#","#","#"}) using CSE
Regards,
Sam
On Fri, Sep 7, 2012 at 11:27 PM, Paul Schreiner wrote:
> Sorry, I copy/pasted the wrong one.
> I'm still having trouble inserting it as an array function.
Sorry, I copy/pasted the wrong one.
I'm still having trouble inserting it as an array function.
thanks,
Paul
-
“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 peop
Hi Rajan
Please provide the link to download
*Excel function and formulas by Berend held*
On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma wrote:
> *Google and Download this book*
>
> * *
>
> *Excel function and formulas by Berend held*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838
Thanks sam, for the great support.
On Fri, Sep 7, 2012 at 11:02 PM, Sam Mathai Chacko wrote:
> Here's the file
>
> Sam Mathai Chacko
>
>
> On Fri, Sep 7, 2012 at 11:01 PM, Sam Mathai Chacko wrote:
>
>> Not sure if I can provide a smaller formula :)
>>
>> Because of the length of the formula, if
Not sure if I can provide a smaller formula :)
Because of the length of the formula, if you ever want to try using a UDF,
use this
Function ASTERIK(strText As String, lngLeaveDigits As Long)
Dim lng As Long
Dim lngLen As Long
For lngLen = Len(strText) To 1 Step -1
If IsNumer
Thank you very much Sam, it solved my qurey, and it is the right solution ,
but it is a very long formula , please provide me any short formula if
possible.
On Fri, Sep 7, 2012 at 10:53 PM, Sam Mathai Chacko wrote:
> Didn't you find my solution worthwhile?
>
> Sam Mathai Chacko
>
>
> On Fri, Sep
Hi
This function works for me,
hi you can try dis VBA function
Function astrix(ByVal Txt As String, Optional Ref As Boolean = False) As String
Dim X As Long, CellVal As String
For X = 1 To Len(Txt) - 4
If Mid(Txt, X, 1) = "-" Then
Mid(Txt, X, 1) = "-"
Else
Mid(Txt, X, 1) = "*
Didn't you find my solution worthwhile?
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:52 PM, maksood alam <786maks...@gmail.com> wrote:
> Paul,
>
> I want excel function solution.
>
> On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote:
>
>> superb answer sam..
>>
>> Thx
>>
>>
>> On Friday, September 7,
Paul,
I want excel function solution.
On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote:
> superb answer sam..
>
> Thx
>
>
> On Friday, September 7, 2012 9:21:48 PM UTC+5:30, Sam Mathai Chacko wrote:
>
>> Would this help?
>>
>> Regards,
>> Sam Mathai Chacko
>>
>> On Fri, Sep 7, 2012 at 8:45 PM, maks
Shouldn't they be strings?
=LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{"#","#","#","#","#","#","#","#","#"})
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 10:37 PM, Paul Schreiner wrote:
> Odd...
> I seem to be suffering a temporary loss of cognitive function.
> (can't think straight)
>
> I'm trying
Odd...
I seem to be suffering a temporary loss of cognitive function.
(can't think straight)
I'm trying to use Lookup() to replace numbers with "#"
I THOUGHT I could enter it as an array function like:
=Lookup(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#,#})
but I cannot seem to figure out h
I tried that, nothing
On Friday, 7 September 2012 17:38:42 UTC+1, james D wrote:
> Hi.
>
> I am a VBA developer (Excel mainly) - I have built an Excel dashboard
> which contains a userform with a treeview on it. It all works fine pre
> Windows 7 with Office 2010, but with Windows 7 (and Offi
superb answer sam..
Thx
On Friday, September 7, 2012 9:21:48 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> Would this help?
>
> Regards,
> Sam Mathai Chacko
>
> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786ma...@gmail.com
> > wrote:
>
>> Partially correct, but it show as per below
>>
>>*Num
When you look at the references in the pre Windows 7 (where it's working),
your Excel file must be referencing the mscomctl file from the
Windows\System32 folder. So in your Windows 7, try running regsvr32 as
admin on the mscomctl file (ideally copy that from your working OS to the
other OS).
HTH
Hi.
I am a VBA developer (Excel mainly) - I have built an Excel dashboard which
contains a userform with a treeview on it. It all works fine pre Windows 7
with Office 2010, but with Windows 7 (and Office 2010) the treeview is no
longer visible on the form.
I have been searching most of the
Maksood,
Are you looking for a VBA solution? or an Excel Function solution?
Paul
-
“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 y
Is it me? or does the use of this type of Subject line seem to be
increasing lately?
I think we (those that enjoy lending assistance) ought to each start a log
file.
In it, place the name of each person that says "Urgent", and "Please Help"
or some other useless subject.
Then, they'll received
Hi Paul,
I got confused. *it's working superbly*.
Sorry for the inconvenience caused. Thanks a lot for your quick response.
Thanks,
Rahul
On Fri, Sep 7, 2012 at 7:58 PM, Paul Schreiner wrote:
> What's not working?
> I've attached my macro with your sheet.
> They all get excluded except the t
Hi,
Use
=LEFT(SUBSTITUTE(A17,LEN(A17)-LEN(RIGHT(A17,4))-2,"*"),7)&RIGHT(A17,4)
Where,
A17 is the Address of the cell containing string "555-55-5505".
On 9/7/12, Sam Mathai Chacko wrote:
> Would this help?
>
> Regards,
> Sam Mathai Chacko
>
> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786maks.
Would this help?
Regards,
Sam Mathai Chacko
On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786maks...@gmail.com> wrote:
> Partially correct, but it show as per below
>
>*Numbers*
> *Required out put*
> 555-55-5505
> ***-***-5505
> 555-55-125-0
> ***-**-***-*
> 555-55--23
>
Thanks It works !
>
>
Attapan.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Partially correct, but it show as per below
*Numbers*
*Required out put*
555-55-5505
***-***-5505
555-55-125-0
***-**-***-*
555-55--23
***-**-**55-23
On Fri, Sep 7, 2012 at 8:41 PM, Kuldeep Singh wrote:
>
> Dear Maksood,
>
> You can use this and more clarity see attached f
Dear Maksood,
You can use this and more clarity see attached file.
=RIGHT(SUBSTITUTE(A1,"-",""),4)
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 8:38 PM, wrote:
> **
> First use Substitue fn to subst "-" with "" and then use Right function.
>
> Rgds
> Vabs
> --
> *
First use Substitue fn to subst "-" with "" and then use Right function.
Rgds
Vabs
-Original Message-
From: maksood alam <786maks...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Fri, 7 Sep 2012 20:33:28
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ s
Kuldeep, please read my question in the mail. it should show last four
digit and rest of all should show "*".
if i use right(555-55--23,4) it will show 5-23 but the answer should be
5523.
On Fri, Sep 7, 2012 at 8:29 PM, Kuldeep Singh wrote:
>
> Hi,
>
> Try this one.
>
> =RIGHT(A1,4)
>
> Regard
Hi,
Try this one.
=RIGHT(A1,4)
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 8:15 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi Guys,
>
> Below are the number i want to show only last four digit of the numbers
> and rest of all should be "*", please provide me the solution.
>
> *Numb
Hi Guys,
Below are the number i want to show only last four digit of the numbers and
rest of all should be "*", please provide me the solution.
*Numbers*
*Required out put*
555-55-5505
***-***-5505
555-55-125-0
***-**-***-*
555-55--23
***-**-**55-23
--
Join official faceb
I think you will need to this file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rahul chow
Sent: 07 September 2012 5:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to fi
Use this as array
=MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),$B$9:$F$12)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of attapan_chainarongb...@ck-mail.com
Sent: 07 September 201
For Two Columns Use this Formula .
=MID($A2,FIND("*",SUBSTITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)+3,FIND("Tot"
,$A2,FIND("*",SUBSTITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)+2)-FIND("*",SUBS
TITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)-3)
Can you please tell what amount need to come in las
Hi Paul,
Thanks for your quick reply.
But the macro is not working.
Here i am providng littile bit of explanation about my query.
In the attached fourth row contains Dinner time (8:00 PM to 8:45 PM), So i
want to delete this this row for the sheet.
Row no. 17 Contains lunch time (12:30PM to 1:
Yes please needs that urgently
On Sep 7, 2012, at 8:46 AM, "Rajan_Verma" wrote:
> Will Suggest you a Code ,if you need?
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
> Behalf Of Sara Lee
> Sent: 07
Google and Download this book
Excel function and formulas by Berend held
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: 07 September 2012 2:59
To: excel-macros@googlegroups.com
ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Zibraan
Sent: 07 September 2012 12:31
To: excel-macros@googlegroups.com
Subject: $$Excel-Mac
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n
Will Suggest you a Code ,if you need?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara Lee
Sent: 07 September 2012 10:36
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ pls help urgent
Thank you.
I probably ought to add a few "disclaimers".
The whole discussion of variables and "scope" sometimes falls under a larger
category of "memory management".
For someone new, it often SEEMS like the easiest approach would be to simply
declare everything as "public".
But that itself co
I wrote this macro.
I'm not happy with it.
I'm sure there's an easier way.
The problem is that there are so many conditions that need to be checked.
You have two records in your sample file that seem to be suspicious.
Both are for ID no 72619984.
The End time is before the Start time.
Rather tha
In that case, user Workbook_AfterSave
You can use:
if (ThisWorkbook.Saved) then Sheets("Sheet1").Range("B1").Value = Now()
Paul
-
“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
Hi Singh,
Thank you very very much. U have saved me a lot of manual work.
Regards,
Boreh
On 7 September 2012 14:53, Karan Singh wrote:
> Hi Robinson,
>
> Pl. find attachment. I'v solved both column queries but what is "Tot Trans
> Amt"? I was not able to understand that. I'v done this with lots
You can also try this for 2nd column :
=IFERROR(LEFT(MID(A2,FIND("Tot W/D Trans Amt = KES ",A2,1)+LEN("Tot W/D
Trans Amt = KES "),FIND("Tot W/D Trans Ct ",A2,1)),FIND("Tot W/D Trans
Ct",MID(A2,FIND("Tot W/D Trans Amt = KES ",A2,1)+LEN("Tot W/D Trans Amt =
KES "),FIND("Tot W/D Trans Ct ",A2,1)),1)-
Please do not RE post at a later time. RUDE! And, VERY RUDE to use URGENT. Your
request is NOT more urgent than anyone else.
Since not all students would always have all years I would suggest a vba macro
to do this. Is that OK.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@
but paul now() will give me the current time even if the file is not
saved
On Fri, Sep 7, 2012 at 5:37 PM, Paul Schreiner wrote:
> Zibraan,
> As mentioned, you can use a BeforeSave event macro:
>
> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
> Boolean)
> Sheets(
Zibraan,
As mentioned, you can use a BeforeSave event macro:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("B1").Value = Now()
End Sub
Paul
-
“Do all the good you can,
By all the means you can,
I
Please give a complete explanation of the logic
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: LAKSHMAN PRASAD
Sent: Friday, September 07, 2012 1:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Collecting interest details only at the time o
Your solution did not provide the proper answer and selections should have been
removed. Here is the proper formula solution for all the parameters which
assumes self adjusting defined named ranges for columns a:e
=SUMPRODUCT((cola=I3)*((colb=$M$2)+(colb=$K$2))*((colc=$M$3)+(colc=$N$3)+(colc=$O$
Hi Team,
How do i get the last saved time in (HH:MM:SS) format in cell B2 in a
shared workbook.
Thanks and Regards,
On Fri, Sep 7, 2012 at 12:30 PM, Zibraan wrote:
>
> Hi Team,
>
> How do i get the last saved time in (HH:MM:SS) format in cell B2.
>
> Thanks and Regards,
>
> --
> Join offic
Hi Sundarvelan,
Just paste below formulas In columns I and J and drag this up to i20 and j20
*=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1) in I2 Circle*
*
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),2) in J2 Area
Regards
Prince
*
On Thursday, September 6, 2012 12:37:06 PM UTC+5:30, Sundar
Please advise a formula to get the data in the attached format. i need a
transpose to the data attached.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
Dear All expert
Please help me to find the answer.
1. Table1(BOM) and Table2(Forecast)
2. I used MMULT to get matrix value( array1 * array2) = table3
3. Please see table4 (If Part not sort by (A,B,C) but It alternate by (C,A,B)
4. How can I get this answers(table4) Please advise me
Rdgs
--
Joi
Dear Sundarvelan,
You can try this.
=INDEX($B$2:$B$20,MATCH(K2,$D$2:$D$20,0),1) Paste it I2 &
Ctrl+Shift+Enter.
=INDEX($C$2:$C$20,MATCH(K2,$D$2:$D$20,0),1) Paste it J2 &
Ctrl+Shift+Enter.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 6:46 PM, Rajan_Verma wrote:
> *=INDEX($B$1:$F$20,MATCH(
Hi Singh,
Thanks, its works. What about the other two columns?
Regards,
Boreh
On 7 September 2012 13:40, Karan Singh wrote:
> Hi Robinson,
>
> Pls use below formula and drag it down or Ctrl+D for Tot Dep Trans Amt :
>
> =SUBSTITUTE(MID(A2,FIND("KES
> ",A2),LEN(LEFT(A2,FIND(CHAR(10),A2)-2))-FIND
Hi Robinson,
Pls use below formula and drag it down or Ctrl+D for Tot Dep Trans Amt :
=SUBSTITUTE(MID(A2,FIND("KES
",A2),LEN(LEFT(A2,FIND(CHAR(10),A2)-2))-FIND("= ",A2)),"KES ","")
Rgds
Karan Singh
On Fri, Sep 7, 2012 at 3:34 PM, Robinson Boreh wrote:
> Dear Members,
> I need assistance on
use
ctrl+shift+enter for array formula
---
Regard
ਦੀਪਕ ਗਿਰੋਤ੍ਰਾ
+91-9911568956
੧ਓ ਸਤਨਾਮ ਸ਼੍ਰੀ ਵਾਹੇਗੁਰੁ ੧ਓ
On Fri, Sep 7, 2012 at 3:41 PM, Kuldeep Singh wrote:
>
> Dear Waseem,
>
> You read it properly.
>
> http://www.cpearson.com/excel/ArrayFormulas.aspx
>
> http:
Dear Waseem,
You read it properly.
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.exceluser.com/explore/arrays1.htm
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 3:17 PM, Waseem Saifi wrote:
> thanx kuldeep.
>
> On Fri, Sep 7, 2012 at 3:04 PM, Kuldeep Singh wrote:
>
>>
>> See it
Dear Members,
I need assistance on how to extract figures from a string of text. I
have attached an excel sheet which contains various date in a cell. I
have Tot Dep Trans Amt, Tot W/D Trans Amt and Tot Trans Amt all in one cell
and i need to extract an amount for each amount into its own cell. I h
thanx kuldeep.
On Fri, Sep 7, 2012 at 3:04 PM, Kuldeep Singh wrote:
>
> See it...
>
> http://www.ozgrid.com/Excel/arrays.htm
>
> Regards,
> Kuldeep Singh
>
> On Fri, Sep 7, 2012 at 2:59 PM, Waseem Saifi wrote:
>
>> Hi All Members,
>>I want to learn array formulas in excel 2007.
>>Please s
See it...
http://www.ozgrid.com/Excel/arrays.htm
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 2:59 PM, Waseem Saifi wrote:
> Hi All Members,
>I want to learn array formulas in excel 2007.
>Please send me some useful stuff or refer me any useful link to learn
> array formulas.
>tha
Hi All Members,
I want to learn array formulas in excel 2007.
Please send me some useful stuff or refer me any useful link to learn
array formulas.
thanx in advance.
Regards,
Waseem Saifi
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
but it is a shared workbook, so every time i open this sheet i will give
the current time.
Regards,
On Fri, Sep 7, 2012 at 12:35 PM, wrote:
> **
> Use before save event
>
> And save time in a1
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Kuldeep Singh
> *
Use before save event
And save time in a1
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kuldeep Singh
Sender: excel-macros@googlegroups.com
Date: Fri, 7 Sep 2012 12:33:07
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to get Last Saved ti
You can try this.
=NOW()
Regards,
Kuldeep Singh
On Fri, Sep 7, 2012 at 12:30 PM, Zibraan wrote:
>
> Hi Team,
>
> How do i get the last saved time in (HH:MM:SS) format in cell B2.
>
> Thanks and Regards,
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexc
Hi Team,
How do i get the last saved time in (HH:MM:SS) format in cell B2.
Thanks and Regards,
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread tit
76 matches
Mail list logo
