Re: $$Excel-Macros$$ lookup and sum

thanks On Tuesday, August 9, 2016 11:21 AM, Abhishek Jain wrote: PFA On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS wrote: Dear Expert, please help me out lookup and sum from sheet2

Re: $$Excel-Macros$$ lookup and sum

PFA On Tue, Aug 9, 2016 at 11:11 AM, 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS wrote: > Dear Expert, > > please help me out lookup and sum from sheet2 > > regards > LAKSHMAN > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

$$Excel-Macros$$ lookup and sum

Dear Expert, please help me out lookup and sum from sheet2 regardsLAKSHMAN -- 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

$$Excel-Macros$$ Re: VBA macro - WhatsApp group.

*Plz Add .: +91 9716437516* On Monday, August 8, 2016 at 9:43:01 PM UTC+5:30, Rajeev Ranjan wrote: > > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Guys, Any function of "*Vlookup*" & "*Code*" for the same ??? On Monday, August 8, 2016 at 8:57:54 PM UTC+5:30, sourav devrani wrote: > > Hi Sachin you can also use this one. > > Regards > Sourav Devrani > > On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay > wrote: >

Re: $$Excel-Macros$$ Using Small Formula

=lower(a1) A1 is your first value, then you can drag. On Monday, August 8, 2016, sourav devrani wrote: > A > > B > > C > > D > > How to small these values using Small Formula. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ Re: Extract Text that begins with L

Please see the attached file. Regards Sourav Devrani On Tue, Jul 19, 2016 at 11:43 PM, सचिन शर्मा wrote: > Please check > > Cash paid to L986529 - RAMESH KUMAR K > EMP ID > L986529 > > >- =MID(B2,FIND("L",B2),7) > > >- > *" 7 " = Lenth of EMP ID * > >

$$Excel-Macros$$ Re: VBA macro - WhatsApp group.

please add the my number 9811503853 On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: > > Creating WhatsApp group for VBA macro... Pls msg me your contact, if you > wants to join. > > Add me in WhatsApp and Msg me to - 9500087194 > > Regards, > Prabhu.R > -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin you can also use this one. Regards Sourav Devrani On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Sachin, > > You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * > ($C$5:$C$11)) > > Please change the ref. accordingly. > > On

$$Excel-Macros$$ Using Small Formula

A B C D How to small these values using Small Formula. -- 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 titles.

$$Excel-Macros$$ How to unhide columns in Office 2010 - Windows 10

Hi Friend Greetings! Could you please assist me on how to unhide shortcut of "Ctrl+Shift+0" as it's not working in Windows 10 with Office 2010. Thanks, *With regards,**Pravin Gunjal* *​​* -- 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) !

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin, You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * ($C$5:$C$11)) Please change the ref. accordingly. On Mon, Aug 8, 2016 at 12:52 PM, NOORAIN ANSARI wrote: > Dear Sachin, > > Please try it... > >

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Dear Sachin, Please try it... =VLOOKUP(E6,CHOOSE({1,2},IF(EXACT($B$6:$B$9,E6),$B$6:$B$9,""),$C$6:$C$9),2,0) and press Ctrl+Shift+Enter See attachment for more clarity On Mon, Aug 8, 2016 at 12:25 PM, सचिन शर्मा wrote: > Dear All, > > Kindly help to resolve the

$$Excel-Macros$$ Vlookup Sensitive Case

Dear All, Kindly help to resolve the attached file of Sensitive Case. find the data by Vlookup between *Capital* & *Small* letters *(Eg. A & a)* *Thank & Regards*