Re: $$Excel-Macros$$ Find Second Highest value from data

2015-03-26 Thread Mandeep Baluja
satendra max cannot be used here until you can create a array formula with some logic. syntax of your max function is wrong. . On Friday, March 27, 2015 at 11:29:10 AM UTC+5:30, Satendra kumar wrote: > > Hi Amit, > > Find below formula for result second highest value. > > =max(renge,2) > > > than

$$Excel-Macros$$ Re: Find Second Highest value from data

2015-03-26 Thread Mandeep Baluja
did you tried the reply given to you. On Friday, March 27, 2015 at 11:24:09 AM UTC+5:30, Mandeep Baluja wrote: > > you can use large function to do that. > > =large(range,2) > > > > > On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote: >> >> Dear Friends, >> >> >> >> P

RE: $$Excel-Macros$$ Find Second Highest value from data

2015-03-26 Thread Amit Desai (MERU)
Sorry, I have one more issue… my current data are in A2, C2,E2,G2 cell. Can there be some other formula or I have to shuffle my data in next to each other only. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satendra kumar Sent: Friday, March 27, 2015

$$Excel-Macros$$ Look formula required

2015-03-26 Thread Rajesh thrissur
Hi Experts please check the attached table , there i have to select a value from one table to another based on the criteria given. pls help me Regards Rajesh -- 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 fo

$$Excel-Macros$$ RE: Find Second Highest value from data

2015-03-26 Thread Amit Desai (MERU)
Dear Mandeep, Oh wow…Thanks a lot.. It worked as needed. Best Regards, Amit From: Mandeep Baluja [mailto:rockerna...@gmail.com] Sent: Friday, March 27, 2015 11:24 AM To: excel-macros@googlegroups.com Cc: Amit Desai (MERU) Subject: Re: Find Second Highest value from data you can use large funct

Re: $$Excel-Macros$$ Find Second Highest value from data

2015-03-26 Thread Satendra kumar
Hi Amit, Find below formula for result second highest value. =max(renge,2) thanks satendra On Fri, Mar 27, 2015 at 11:08 AM, Amit Desai (MERU) wrote: > Dear Friends, > > > > Please let me know if I want to find second highest value from a data > range how shall I do that? > > > > > > Please

$$Excel-Macros$$ Re: Find Second Highest value from data

2015-03-26 Thread Mandeep Baluja
you can use large function to do that. =large(range,2) On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote: > > Dear Friends, > > > > Please let me know if I want to find second highest value from a data > range how shall I do that? > > > > > > Please let me kn

$$Excel-Macros$$ Find Second Highest value from data

2015-03-26 Thread Amit Desai (MERU)
Dear Friends, Please let me know if I want to find second highest value from a data range how shall I do that? [cid:image001.png@01D0687E.4102B990] Please let me know what formula can be used to get 66,000. Best Regards, Amit Desai Disclaimer: This message and its attachments contain confident

$$Excel-Macros$$ Copy data from other application to excel.

2015-03-26 Thread Avinash
Hi Experts, i want a macro which can copy data from another application to excel. below is the code which i am trying to use. i dont have any workbook to explain this example. just a simple logic copy data from other application and paste in to excel then again switch to that application then p

$$Excel-Macros$$ Copy Data from another application to excel.

2015-03-26 Thread Avinash
Hi Experts, i want a macro which can copy data from another application to excel. below is the code which i am trying to use. i dont have any workbook to explain this example. just a simple logic copy data from other application and paste in to excel then again switch to that application then p

$$Excel-Macros$$ Hiring-OBIEE Designer/Lead Developer@Enfield, CT [Please send resumes to r...@technotalent.com]

2015-03-26 Thread Rene Mickey
Hi, Hope you are doing great... Please let me know your interest along with your updated resume (If you are not available please refer this Position) [Please send resumes to r...@technotalent.com] *Position* *Role: OBIEE Designer/Lead Developer* *Location : Enfield, CT* *Duration