$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Thanks *Suresh.* It's working as required... :) On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote: > > Dear Experts, > > Please help to resolve below requirement. > > File attached for reference. > > > *Numbers .: 1,054,265* > > *Res

$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Thanks Suresh, It's working and shows "*and*" before last 2 "00" digits. but, if value comes less then 100 then "*Hundred And*" still visible (Ex.: 99 = *Hundred and Ninety Nine Rupees Only*) On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote

$$Excel-Macros$$ Need Help in Macros for Currency change in numbers to text

Dear Experts, Please help to resolve below requirement. File attached for reference. *Numbers .: 1,054,265* *Result Shows .: *Ten Lakh Fifty Four Thousand Two Hundred Sixty Five Rupees Only *Required format .: *Ten Lakh Fifty Four Thousand Two Hundred *and *Sixty Five Rupees Only

$$Excel-Macros$$ Re: Question

Question Resolved On Tuesday, October 18, 2016 at 3:23:21 PM UTC+5:30, सचिन शर्मा wrote: > > Dear All, > > Please help to resolve the attached Question > > -- 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 offi

$$Excel-Macros$$ Question

Dear All, Please help to resolve the attached Question -- 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$$ Re: how to sum colored cell only

*Hi, Use below code for the same .:* *Function SumByColor(CellColor As Range, rRange As Range) * *Dim cSum As Long Dim ColIndex As Integer ColIndex = CellColor.Interior.ColorIndex For Each cl In rRange If cl.Interior.ColorIndex = ColIndex Then cSum = WorksheetFunction.SUM(cl, cSum) End If

$$Excel-Macros$$ Re:

Hi Sriram, Kindly use the below formatting. ** Attached file for the same On Monday, June 27, 2016 at 5:17:05 PM UTC+5:30, sriram ji wrote: > > Dear

$$Excel-Macros$$ Re: Query !!!

Thank You so Much, It's Working Perfect :) On Tuesday, August 16, 2016 at 2:10:13 PM UTC+5:30, सचिन शर्मा wrote: > > Dear All, > > > Please help to resolve below query. > > > Share the function to get the same result which in yellow cells > > ** without any supp

$$Excel-Macros$$ Query !!!

Dear All, Please help to resolve below query. Share the function to get the same result which in yellow cells ** without any supporting columns. *Thanks and

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

Hi Saurav, PFA, On Monday, August 8, 2016 at 7:03:25 PM UTC+5:30, sourav devrani wrote: > > A > > B > > C > > D > > How to small these values using

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

Please find the attached sheet. On Tuesday, August 9, 2016 at 11:25:12 AM UTC+5:30, lakshm...@yahoo.com wrote: > > 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

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

SARI <noorain...@gmail.com >> > 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),2,0) >>> and press Ctrl+Shift+Enter >

$$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*

$$Excel-Macros$$ Re: formula proble

Dear, Please find the attached file. On Sunday, July 24, 2016 at 4:18:00 PM UTC+5:30, GENIUS wrote: > > PLEASE SEE THE QUESTION IN THE FILE > -- 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 @

$$Excel-Macros$$ Re: Extracting S

Please use the below module *Function SplitCaps(strIn As String) As String* *Dim objRegex As Object* *Set objRegex = CreateObject("vbscript.regexp")* *With objRegex* *.Global = True* *.Pattern = "([a-z])([A-Z])"* *SplitCaps = .Replace(strIn, "$1 $2")* *End With* *End Function* and

$$Excel-Macros$$ Age Calculation & Sumifs

Dear All, Please help to resolve the below Questions. *Q.1* *Please write the formula in Cell C6 to show tha deiffrence between mention Dates as " 36 Years 8 Month 20 Days".* - *Please share the same format as given in Question.* *Q.2 Please write the formula that easily track total Sum

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

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 at 10:48:09 AM UTC+5:30, Sundarvelan wrote: > > Dear Experts, > > Please help me to extract EMP ID. > > I have the below

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

esley* > - > > > On Tuesday, July 19, 2016 5:29 AM, Sachin Panchal <spanc...@gmail.com > > wrote: > > > Dear sachin > > try this i hope your problem will be solve with my rule > > On Tue, Jul 19, 2016 at 12:42 PM,

$$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

Dear All, PFA, Calculate the incentive according 3 data base ( *DATA 1, DATA 2, DATA 3*) and 3 different grads ( *A, B, C* ) Criteria and achievement both in attached sheet. Regards. *Sachin* # +91 97 16 437516 # +91 72 91 932360 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Re: Help on Vlookup

Hi PFA, Regards, Sachin On Friday, June 17, 2016 at 12:52:48 PM UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s