$$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*
>
> *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 
>
> Thanks and Regards
> *Sachin Sharma*
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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:
>
> 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 
>
> Thanks and Regards
> *Sachin Sharma*
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Invoice_Format.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

Thanks and Regards
*Sachin Sharma*

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Invoice_Format.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$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 official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Question Resolved.xlsx
Description: MS-Excel 2007 spreadsheet

$$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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Quetion.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 Next cl SumByColor = cSum *

*End Function*

*Thanks and RegardSachin*

On Thursday, October 6, 2016 at 9:55:20 AM UTC+5:30, GENIUS wrote:
>
> please find the question in the workbook
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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 Friends,
>
> Please find attached the file, help required.
>
> Thanks in Advance.
>
> Sriram G
>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Need Help.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 supporting columns.
>
>
>
> <https://lh3.googleusercontent.com/-E8VgjYMea88/V7LQjr9O5GI/CyE/rBGKJ6PwF1Y9YdbWCEkoQTAktJSp_Cs-ACLcB/s1600/Untitled.png>
>
>
> *Thanks and Regards*
> *Sachin Sharma.*
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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 Regards*
*Sachin Sharma.*

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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 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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Using Small Formula.xlsx
Description: MS-Excel 2007 spreadsheet

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 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 official Facebook page of this forum @ 
> https://www.facebook.com/ 
> discussexcel 
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@ googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/ group/excel-macros 
> .
> For more options, visit https://groups.google.com/d/ optout 
> .
>
>
> -- 
> 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. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


sum.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 to join.
>>
>> Add me in WhatsApp and Msg me to - 9500087194
>>
>> Regards,
>> Prabhu.R
>>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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 <devendras...@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, Aug 8, 2016 at 12:52 PM, NOORAIN ANSARI <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
>>>
>>> See attachment for more clarity
>>>
>>> On Mon, Aug 8, 2016 at 12:25 PM, सचिन शर्मा <sachin.ba...@gmail.com 
>>> > wrote:
>>>
>>>> Dear All,
>>>>
>>>> Kindly help to resolve the attached file of Sensitive Case.
>>>>
>>>> find the data by Vlookup between *Capital* & *Small* letters *(Eg. A & 
>>>> a)* 
>>>>
>>>>
>>>> <https://lh3.googleusercontent.com/-pNmCPcMGvNI/V6gspe2z--I/CwM/uSAUbllr0Isrx1HdhshhrIrHq5Cw4ZJ3ACLcB/s1600/Untitled.png>
>>>>
>>>>
>>>> *Thank & Regards*
>>>> *Sachin*
>>>>
>>>> -- 
>>>> 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. Poor thread titles, like Please 
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security 
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>  
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners 
>>>> and members are not responsible for any loss.
>>>> --- 
>>>> You received this message because you are subscribed to the Google 
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send 
>>>> an email to excel-macros...@googlegroups.com .
>>>> To post to this group, send email to excel-...@googlegroups.com 
>>>> .
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>
>>> -- 
>>> With Regards,
>>> Noorain Ansari
>>> http:// <http://www.noorainansari.com>noorainansari.com 
>>> <http://www.noorainansari.com>
>>> http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com 
>>> <http://www.excelvbaclinic.blogspot.com> 
>>> <http://accesssqclinic.blogspot.in/> 
>>>
>>> -- 
>>> 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. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>  
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>>> members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>

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

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Vlookup Sensitive Case.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


CORRECTION IN FORMULA.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 use function " *=SplitCaps *" & " *Left(Text Cell,Find(" ",Text 
Cell)-1) *"

*Attachment for your reference .:*


Regards.

*Sachin*

# +91 97 16 437516

# +91 72 91 932360



On Saturday, July 23, 2016 at 11:40:14 AM UTC+5:30, GENIUS wrote:
>
> How do i extract S from Column A thru formula, for example like column B
>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


EXTRACTING S .xlsx
Description: MS-Excel 2007 spreadsheet

$$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 of Sale of below 
mention Name,Year and Brands.*


*Data **Attached.*

Regards.

*Sachin*

# +91 97 16 437516

# +91 72 91 932360

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 sentence in D2 Cell, and i need to extract the EMP ID 
> which starts with L
>
> D2 = Cash paid to L986529 - RAMESH KUMAR K towards Accomdation Charges on 
> 09.05.2016 to 11.05.2016 amount:4100-- for Corporate Approved by Mr.Arvind
>
> Thanks
> N.Sundarvelan
> 9600160150
>

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 sentence in D2 Cell, and i need to extract the EMP ID 
> which starts with L
>
> D2 = Cash paid to L986529 - RAMESH KUMAR K towards Accomdation Charges on 
> 09.05.2016 to 11.05.2016 amount:4100-- for Corporate Approved by Mr.Arvind
>
> Thanks
> N.Sundarvelan
> 9600160150
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

[सचिन शर्मा]

Thanks Paul,

For answer and your observation,

Now it's working correctly.

Regards.

*Sachin*

# +91 97 16 437516
# +91 72 91 932360

On Tuesday, July 19, 2016 at 4:51:00 PM UTC+5:30, Paul Schreiner wrote:
>
> I think your logic MAY be flawed.
>
> In your example, TL2 has:
> 95 94 78
>
> Data1 (95) matches Bucket B.
> Data2 (94) matches Bucket A.
> Data3 (78) matches Bucket B.
>
> so 0 should be returned?
>
> Based on your criteria, none of the Team Leaders would receive "Incentive".
>
> Is that correct?
> ---
> If you changed your criteria to:
> *Bucket* *Data 1* *Data 2* *Data 3* *Incentive* 
> A >95 >85 >90 2000 
> B >80 >70 >75 1000 
> C >70 >60 >50 500 
>
>
> Then TL2 and TL4 would receive "Incentive".
>
> I've included formulas for both scenarios.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> 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, सचिन शर्मा <sachin.ba...@gmail.com 
> > wrote:
>
> 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)) 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. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
> -- 
> Regards,
> Sachin panchal
> -- 
> 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. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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. Poor thread titles, like Please Help, 
Urgent, Need He

$$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)) 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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$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 
=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. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


1.xlsx
Description: MS-Excel 2007 spreadsheet