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

2016-08-08 Thread 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
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 regardsLAKSHMAN-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

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

2016-08-08 Thread Abhishek Jain
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 > =TIME(2,DO:IT,N:OW) ! Join offici

$$Excel-Macros$$ lookup and sum

2016-08-08 Thread 'LAKSHMAN PRASAD' via MS EXCEL AND VBA MACROS
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.

2016-08-08 Thread सचिन शर्मा
*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

2016-08-08 Thread सचिन शर्मा
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: > >> Hi Sachin, >> >> You can

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

2016-08-08 Thread Abhishek Jain
=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 > =TIME(2,DO:IT,N:OW) ! Join officia

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

2016-08-08 Thread sourav devrani
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 * > > > > On Wednesday, July 20, 2016

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

2016-08-08 Thread Rajeev Ranjan
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

2016-08-08 Thread sourav devrani
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 Mon,

$$Excel-Macros$$ Using Small Formula

2016-08-08 Thread sourav devrani
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. P

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

2016-08-08 Thread Pravin Gunjal
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) ! Join

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

2016-08-08 Thread Devendra Sahay
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... > > =VLOOKUP(E6,CHOOSE({1,2},IF(EXACT($B$6:$B$9,E6),$B$6:$B$9, > ""),$C$6:$C$9

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

2016-08-08 Thread NOORAIN ANSARI
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 attached file of Sensitive Case.