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

Dear Prabhu, Thanks a lot.. this will fit in my data sets. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Friday, March 27, 2015 9:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find Second Highest value from

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

Hi amit, You can use the below formula to get 2nd highest number. =large(range,2) Note : range can be continues cells or selected cells like - A1:A5 or A1, A4,A5. On 27-Mar-2015 1:46 PM, "Ashish Kumar" wrote: > Hi, > > Check this one too.. for auto Highlight Second Highest Value. > > > >

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

Hi, Check this one too.. for auto Highlight Second Highest Value. Regards Ashish -- 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) Use concise

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

y. >> >> >> >> >> >> >> > > > > >> *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On >> Behalf Of *Satendra kumar >> *Sent:* Friday, March 27, 2015 11:29 AM >> *To:* excel-...@googlegroups.com &

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

lf Of *Satendra kumar > *Sent:* Friday, March 27, 2015 11:29 AM > *To:* excel-...@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Find Second Highest value from data > > > > Hi Amit, > > > > Find below formula for result second highest value. > >

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

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

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

11:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Find Second Highest value from data 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) mailto:amit.de...@merucabs.com>>

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

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$$ Find Second Highest value from data

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