to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Regards,
AK
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
Thanks alot Raviinder!
On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei
wrote:
> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *AK
> *Sent:* Wednesday, March 19, 2014 8:15 AM
> *To:* excel-macros@googlegroups.
the prior values in the range (b3 : M3)
Please let me know the solution.
--
Regards,
AK
--
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
1
nd “*Second Review date”* using Review Sheet tab.
For example : end customer id “1-168WAQL” occur once between *First Review
date* (7/31/2011) and *Second Review date* (2/29/2012) so the output in
column F should be 1.
Sample data is attached for reference.
Note : date format is MM/DD/YYY
you can use any Excel function in vba via
Application.WorksheetFunction.
Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4)
arg= parameters required in excel functions
Application.WorksheetFunction.VLookup(range("A1").value,Range("B1:D7"),2,0)
Best Regards,
Anubhav
On Monday, May 1
Thanks Vasant, Haseeb, Rajan and Ashish for your solution .. you guys are
Master !
Regards,
AK
On Fri, Jul 8, 2011 at 5:39 AM, ashish koul wrote:
> =INDEX($1:$1,0,SMALL(IF(D2:AB2>0,COLUMN(D2:AB2),""),1))
>
> press ctrl +shift+ enter
>
> check the attachment
>
&
‘3/31/2010’ so ‘Revenue started from Month’ Column should have
3/31/2010 as the output.
Excel formula or Macro . Anything is fine with me :-)
Thanking you in Advance.
--
Regards,
AK
--
--
Some important links
I have an excel sheet with some data on sheet2 and I need to export
this to an access database secured via workgroups security. The code I
have works fine with database without security workgroup.
Sub EXPORT()
Dim cn As ADODB.Connec
I will not comment on the authentication for those softwares, but
there are a lot of passware recovery softwares which gives you all
types of password you have lost.
Just Google "Lost Passware" and try your luck, you might get some
trial/free versions.
On Jun 28, 12:55 pm, JsinSk wrote:
> You wi
