Re: $$Excel-Macros$$ Need some formula or MACROS

Thank you dear  vhaibav now i can save more time...   Best regards Delin.F On Friday, 27 March 2015 7:26 PM, Vaibhav Joshi wrote: Your first rule works fine, you can add 2nd rule via conditional formatting mange rule.. check this file i have added rule for your reference. Ch

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. > > > >

$$Excel-Macros$$ Unrelated mails in this group.

Hi ayush, It seems nowadays some ppls are posting unrelated mails in this group..for ex: some mail with sub "Do you want to marry".. Am receiving atleast 4-5 mails daily... Is it possible to block those mails or warn ppls to stop posting this kind of unwanted mails in this excellent group.. Tha

Re: $$Excel-Macros$$ Need some formula or MACROS

Hi Vaibhav Bhai, It's perfect .. !! superb :) 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, accurate thread t

Re: $$Excel-Macros$$ Need some formula or MACROS

Your first rule works fine, you can add 2nd rule via conditional formatting mange rule.. check this file i have added rule for your reference. Cheers!! On Fri, Mar 27, 2015 at 8:34 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS wrote: > Dear Team, > > i need to check my updates are correct ag

$$Excel-Macros$$ Need some formula or MACROS

Dear Team, i need to check my updates are correct against the CMS DATA (Container no & Size) if it is not matching it has to be give some color indications, I don't know how to ask my question... for more details please go through  the attachment   Best regards Delin.F -- Are you =EXP(E:RT) or

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$$ Look formula required

Hi You can use simple vlookup formula, but you need to reverse the table, check attachment & formula is in col G. Cheers!! On Fri, Mar 27, 2015 at 11:41 AM, Rajesh thrissur < rajeshkainikk...@gmail.com> wrote: > Hi Experts > please check the attached table , there i have to select a value from

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

try this... On Fri, Mar 27, 2015 at 12:55 PM, Mandeep Baluja wrote: > put this formula in h2 it will give you large from alternate columns > > =LARGE(IF(MOD(COLUMN(A2:G2),2)<>0,A2:G2),2) > > Press control+ shift +enter to create array formula. > > Regards, > Mandeep > > > > > On Friday, March

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

Try this for finding 2nd largest value, this works even if you have zeros & duplicate nos in range, its array formula... =MAX(IF(A1:A10<>MAX(A1:A10),A1:A10)) Cheers!! On Fri, Mar 27, 2015 at 12:34 PM, Pramod Singh wrote: > Hi All. > > Good question came from amit. > > Excel expert. Can anyone

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

Hey bro, May i know without any sheet function means What ?? not sheet function and not vba function. On Friday, March 27, 2015 at 12:35:01 PM UTC+5:30, pramodb35 wrote: > > Hi All. > > Good question came from amit. > > Excel expert. Can anyone get the large second value from the list w

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

put this formula in h2 it will give you large from alternate columns =LARGE(IF(MOD(COLUMN(A2:G2),2)<>0,A2:G2),2) Press control+ shift +enter to create array formula. Regards, Mandeep On Friday, March 27, 2015 at 11:41:11 AM UTC+5:30, Amit Desai (MERU) wrote: > > Sorry, I have one more is

$$Excel-Macros$$ Re: Look formula required

=SUMPRODUCT((E3>=$J$3:$J$11)*(E3<=$K$3:$K$11)*($L$3:$L$11)) Copy this formula in g3 press control +shift+ enter Regards, Mandeep On Friday, March 27, 2015 at 11:41:15 AM UTC+5:30, kasper wrote: > > Hi Experts > please check the attached table , there i have to select a value from one > table

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

Hi All. Good question came from amit. Excel expert. Can anyone get the large second value from the list without using large function not sheet function and not vba function. Take the range(a1:a15) and make the logic there. Pramod On 27 Mar 2015 11:41, "Mandeep Baluja" wrote: > did you tried t