Re: $$Excel-Macros$$ Vlookup

Dear SAM, I have created the addin from the above trailing mails. Can u please guide me where am i going wrong or how to use it once the addin is created? Please help On Oct 27, 1:59 am, Aamir Shahzad wrote: > *Done SAM*, wonderful thanks for your cooperation. I think I must have to > save this

Re: $$Excel-Macros$$ Re: Want to hide entire row

Sub hide_data() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim i As Long For i = Sheets(1).Range("a1").SpecialCells(xlLastCell).Row To 2 Step -1 If Sheets(1).Range("I" & i).Value >= 0 Or Sheets(1).Range("l" & i).Value >= 0 Then Sheets(1).Rows(i & ":" & i).Hidden = True En

Re: $$Excel-Macros$$ Table nedeed in MS-Access

Thanks for the advice On 1 December 2011 23:26, João Mavioso wrote: > Hello, > > ** ** > > You can’t import format to access tables, only data. If you need these > “looks” under access I believe only a form or a report can help you. > > ** ** > > Regards. > > ** ** > > *De:* excel-ma

RE: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

Hello all, That may work if your file has no formatting whatsoever. J and than again J maybe no. You can open XLSX files in previous versions of excel using a free plugin/addon from Microsoft. Link below. http://ww

$$Excel-Macros$$ MS Access Help

Hi Experts, I have a excel file which I am trying to link with MS Access for running some queries. The Excel file contains a VLOOKUP, where I have tried to lookup and compare the data from a previous day report. Then I compare that data to see if they are equal or not. I simply use A2=B2 for this,

RE: $$Excel-Macros$$ Table nedeed in MS-Access

Hello, You can’t import format to access tables, only data. If you need these “looks” under access I believe only a form or a report can help you. Regards. De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em nome de Sam Mathai Chacko Enviada: terça-feira, 29 de

$$Excel-Macros$$ Re: Want to hide entire row

Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh < abdulgani.sha...@sarda.co.in> wrote: > I want to hide entire row if value in column "*I*" & column "*L*" is > greater than or equal to "*0*". > In other words if value in column i & l is less than zero then only such > row to be shown oth

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Although the ORIGINAL post said nothing about DUPLICATES Using your sample, In P1 =LARGE(O:O,1) and in P2 =SMALL(O:O,COUNTIF(O:O,"<="&Q1)-ROW(A2)) copied down Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Thursday, December 01, 2011 4:29 PM To: excel-macros@google

RE: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Hi Don, If you mean each row will show the 1st, 2nd, 3rd largest, etc., disregarding duplicates.. doesn't work for me. Tested with this somewhat arbirtary data set: 1 1 1 5 5 8 9 9 11 11 Your formulas return: 11 9 9 8 5 5 5 1 1 1 1 (Even more v

$$Excel-Macros$$ Listbox: reset the pointer

I have code that writes a set of names to an array; when that set of names is complete a userform opens and the array populates a listbox. The user double clicks on a name to select it, and the userform hides. This process repeats numerous times. On the first cycle if the user selects the third na

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

or this copied down =SMALL(I:I,FREQUENCY(I:I,MAX(I:I)-(ROW(A1)-1))) Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Thursday, December 01, 2011 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

You can also use SMALL function like, =SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1)) will give the 2nd largest number, even if you have duplicate or not. ___ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ job

*Recruiter id *kavitha.b.aarch...@gmail.com * * * * *Experience required for the Job:* 1 - 9 years *Annual Salary of the Job:* 3.0 - 14.0 Lacs *Dear Candidate,* Kindly Refer your friends, Colleagues having Experience in Retail/marketing Analytics,Collection Analytics, Statistical modeling, Data

$$Excel-Macros$$ job

Recruiters id Aditi Ghosh Origin Consulting Services E: ad...@originhr.in W: www.originhr.in * * * * *Experience required for the Job:* 2 - 4 years *Job Location:* Gurgaon *Dear Candidate,* Greetings! I am looking to hire Business Analysts to work with our MNC client in Gurgaon. Below are detai

$$Excel-Macros$$ job

*Send your updated resume at anurad...@globali.in * * * * * * * *Experience required for the Job:* 3 - 6 years *Annual Salary of the Job:* 4.0 - 6.0 Lacs *Job Location:* Delhi/NCR *Dear Candidate,* Dear Candidate, I am Anuradha Gusain from Global InnovSource Solutions Pvt. Ltd. We are a Mumbai b

$$Excel-Macros$$ job

Please send your CV to -tgo...@teksystems.com or Call Tanya Gowda 080-30705491/962040 Dear Candidate There is an urgent requirement from one of th Fortune 100 US Based Client who are looking for Position- System Analyst Requirement Gathering MS Access MS excel Should analyse system issues

Re: $$Excel-Macros$$ Indirect Function

thanks Noorain / Chethan Kumar. Regards, Aamir Shahzad On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu wrote: > hi chethan > > can u explain how u use "getphoto" in Indirect example 3. > > Thanks & regards > Dhartikumar Sahu > > > On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar < > chetankum

Re: $$Excel-Macros$$ Excel to Word

can you attach the sample document and send it to the group On Thu, Dec 1, 2011 at 11:10 PM, hanumant shinde wrote: > Hi Experts, > > Can somebody please suggest something for the below problem. > i am stuck due to this issue. i tried google but in vein. > please help me out. > > > *From:* hanu

Re: $$Excel-Macros$$ Excel to Word

Hi Experts,   Can somebody please suggest something for the below problem. i am stuck due to this issue. i tried google but in vein. please help me out.   From: hanumant shinde >To: Excel Group >Sent: Tuesday, 29 November 2011 8:02 PM >Subject: $$Excel-Macros$$ Excel to Word > > >Hi, > > >i wan

Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs

Be surya in sky ,and don't come here to shine with cheap stuff around. Respect the motive of this forum and I hope Ayush doesn't vanish u with this cheap act, be careful !!! Cheers Rahul. Sent from BlackBerry® on Airtel -Original Message- From: Ashish Pradhan Sender: excel-macros@goo

Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs

Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...

Re: $$Excel-Macros$$ Re: Almost all calculator in one sheet

2011/11/30 Silviu Felician > Hello, > > Your file is awesome, but it would be best if you gave us also the > password, most sheets in this file are locked and I want to be able to play > with the formulas and not just use the file as it is. Thanks! > > -- > FORUM RULES (934+ members already BANNE

$$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs

Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011/12/1 dguillett1 > =LARGE($I$3:$I$23,ROW(A1)) > copy down to give 5,4,4,3,3,2 > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Aindril De > *Sent:* Thursday, December 01, 2011 4:21 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ How to Extract

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

=LARGE($I$3:$I$23,ROW(A1)) copy down to give 5,4,4,3,3,2 Don Guillett SalesAid Software dguille...@gmail.com From: Aindril De Sent: Thursday, December 01, 2011 4:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Dear All, Thanks for the help. I tried your solutions: The solutions with Large work with almost all the lists. But If you try this on a list 1,2,2,3,3 =LARGE(A1:A5,2) does not work None except Divaker's formula worked on that. I am wondering why.! Any Guesses? On Thu, Dec 1, 2011 at 5:48 PM, Di

$$Excel-Macros$$ About Marcros in 2007

Hi,Friends Any body give the refernce of MACRO IN EXECEL 2007, How can create and how do work the with macros Pls give me some example and reference Aivi K -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

I think u r luking for second small value =SMALL(A32:A40,2) On Thu, Dec 1, 2011 at 4:17 PM, Aindril De wrote: > Dear Noorain, > > Thanks for the response. > I have already tried this. This does not work. If you use this on the list > i have mentioned. It generates 4 and not 2,, which should b

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

try this one, =LARGE(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+1) On Thu, Dec 1, 2011 at 5:32 PM, Aindril De wrote: > Thanks all.. > > > On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh wrote: > >> =LARGE(A1:G1,2) >> Regards >> jeet >> >> On Thu, Dec 1, 2011 at 3:51 PM, Aindril De wrote: >> >>> Hi Fr

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Thanks all.. On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh wrote: > =LARGE(A1:G1,2) > Regards > jeet > > On Thu, Dec 1, 2011 at 3:51 PM, Aindril De wrote: > >> Hi Friends, >> I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to >> extract the second biggest number from this li

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

=LARGE(A1:G1,2) Regards jeet On Thu, Dec 1, 2011 at 3:51 PM, Aindril De wrote: > Hi Friends, > I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to > extract the second biggest number from this list. > Note: This list cannot be sorted. I have already found out how to do it > fro

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Dear Noorain, Thanks for the response. I have already tried this. This does not work. If you use this on the list i have mentioned. It generates 4 and not 2,, which should be the correct answer. Please note. This list has duplicate values. Regards, Andy On Thu, Dec 1, 2011 at 4:10 PM, NOORAIN AN

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Dear Aindril, Please use this one, =LARGE(A32:A40,2) - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Dec 1, 2011 at 3:51 PM, Aindril De wrote: >

$$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UD