$$Excel-Macros$$ xlfn

Hello Everyone, I Received one excel file, in which I am seeing formulas starting with ="xlfn.". I am just curious what this xlfn is, this is for the first time I saw such formula. Can any one help me ? Regards, Airen -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

$$Excel-Macros$$ c++ developer

Hi All, I am planning to build a forecasting & network optimization product. Currently I am working in a company & this is my personal part time project. Any one interested in this project can contact me. Currently, I am thinking to develop it in C++. Anyone who is willing to put his efforts p

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

Hi Priyanka, Can you give me the link from where I can download this Odin. I tried it on net but unable to find it out. Thanks Akhilesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

$$Excel-Macros$$ Re: Advanced Filter

Haseeb, Is it possible to apply when I have records of two or more than two column? Thanks Akhilesh -- FORUM RULES (925+ 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 Ne

$$Excel-Macros$$ record a macro

Hi Experts, Is there any way to record a macro between applications? Thanks Akhilesh Airen -- FORUM RULES (925+ 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

$$Excel-Macros$$ Re: Advanced Filter

Brilliant Haseeb, Thanks. Could you please explain. How it works??? Akhilesh -- FORUM RULES (925+ 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 not get

$$Excel-Macros$$ Internet Explorer

Do While objIE.busy While objIE.busy DoEvents Wend Loop objIE.Document.getElementById("quote_currency_input").Value = "Gambian Dalasi" objIE.Document.getElementById

Re: $$Excel-Macros$$ Advanced Filter

Hi Noorain, Thanks for your reply. Provided solution wont work, I dont want empty rows in between. Is there any VBA code?? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a

$$Excel-Macros$$ Advanced Filter

Hi Experts, I have some records in "sheet 1" and some in "sheet 2". Now I want all those records which are in "sheet 2" but not in "sheet 1" and result to be saved in "sheet 2" Thanks Akhilesh Airen -- -

$$Excel-Macros$$ Advanced Filter

Hi Experts, I have some records in "sheet 1" and some in "sheet 2". Now I want all those records which are in "sheet 2" but not in "sheet 1" and result to be saved in "sheet 2" Thanks Akhilesh Airen -- -

$$Excel-Macros$$ sql

Hi, I want to update a table in SQL server from an excel file. Please advise a VBA code. Thanks Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ file browser

Thanks people. Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid

$$Excel-Macros$$ Re: Selecting a date from a database, which equal to or lesser than the selected date

Hi.apply this formula in cell C3 "=B1+MAX(IF(A1:A6-B1<=0,A1:A6- B1,-1000))" followed by hitting shift+control+enter -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht

$$Excel-Macros$$ Re: Selecting a date from a database, which equal to or lesser than the selected date

Hi, In this case it should be 01-oct-2010 Thanks Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ file browser

Hi experts, How to open a file from user via "browse" in VBA Thanks Akhilesh -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join ou

Re: $$Excel-Macros$$ Create worksheet from list

THANKS NOORAIN -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310

Re: $$Excel-Macros$$ Create worksheet from list

Hi dguillett, Also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row " Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailyti

Re: $$Excel-Macros$$ Create worksheet from list

Hi dguillett, I am a learner, could you please tell me meaning of "& r" in Range("J2:J" & r) in above code. Thanks Akhilesh Airen -- -- Some important links for excel users: 1. Follow u

Re: $$Excel-Macros$$ Issue with Selection as collection

Dear markkim, you forgot to write rcell after next Sub selection_area() Dim rcell As Range For Each rcell In Selection rcell.Value = 1 Next rcell End Sub Thanks and Regards Akhilesh Airen -- -- Some important links

Re: $$Excel-Macros$$ count unique values

Thanks Haseeb and other Experts :) Regards Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ count unique values

Hi, i want to count unique values in a selection. I got this formula on net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont know how it works. So please help me understand this formula. -- -- Some impor

Re: $$Excel-Macros$$ Re: need help in soting

Tx Deepak Regards Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com

$$Excel-Macros$$ Re: need help in soting

Members please Help.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1

$$Excel-Macros$$ Re: need help in soting

let there is a table and i want to sort the records of this table using some attribute say pin code. the above algo sort only pin codes.. i want to sort records using coding only.. i don't want to use range().sort -- ---

$$Excel-Macros$$ need help in soting

Sub bubblesort() Dim i As Integer, j As Integer, n As Integer, temp As Single n = Selection.Rows.Count For j = n To 3 Step -1 For i = 1 To j - 1 If Selection.Cells(i, 1) < Selection.Cells(i + 1, 1) Then temp = Selection.Cells(i, 1) Selection.Cells(i,

Re: $$Excel-Macros$$ sorting

Tx Ashish Regards Akhilesh AIren -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

$$Excel-Macros$$ sorting

hello, i have a selection say(A6:H100) now i have to sort this selection by column no 3 tx regards Akhilesh Airen -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ name

How do i name a column in Excel 2003. For eg in excel 2007, i have a table named table1 having column Item...now i could name use table1[Item] as name...but unfortunately this convention is not applicable in Excel 2003...So is there any solution?? -- --

$$Excel-Macros$$ UDF as trigger

hello people there is a limitation of UDF(User Defined Function) that they cant change the value of cell except the one they called in...so i created a sub...now i want to trigger this sub using UDF,but i cant...sop please suggest me solution. Thanks & Regards Akhilesh A

$$Excel-Macros$$ excel to spsss

hey.is there any way to export my data in excel to spss??? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

$$Excel-Macros$$ vba programming

hi all, i've a table in sheet1,now i want to select some rows using check box and then using commmand buttons i've to either move these rows in a table of sheet2 or alter these rows in sheet1 only. T