Re: $$Excel-Macros$$ Unique list

[NOORAIN ANSARI]

Dear Joseph,

Please try it..

Sub Unique_List_Creater()
Dim i As Long
Dim col As Long
Dim rw As Long
Dim sh As Worksheet
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set sh = ThisWorkbook.Sheets(3)
sh.Range("F2:F" & sh.Cells(Rows.Count, "F").End(xlUp).Row).
ClearContents
sh.Range("F1").Value = "Unique List"
i = sh.Cells(Rows.Count, "F").End(xlUp).Row + 1
j = 2
For col = 1 To sh.Cells(1, 1).End(xlToRight).Column
For rw = 2 To sh.Cells(Rows.Count, 1).End(xlUp).Row
sh.Cells(rw, col).Copy sh.Cells(j, "F")
j = j + 1
Next rw
Next col
sh.Range("F2:F" & sh.Cells(Rows.Count, "F").End(xlUp).Row).RemoveDuplicates
1
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

see attached sheet for reference


On Thu, Jul 12, 2012 at 9:11 AM,  wrote:

> Hi experts,
>
> The formulae provided by the members is working fine when I have data in
> one column. But if I have to do the same from multiple columns, then how do
> I do?
>
> Thanks,
> Joseph
> Sent on my BlackBerry® from Vodafone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Unique list

[NOORAIN ANSARI]

Dear Seraj,

Please check attached sheet, There is no solution in it.

On Thu, Jul 12, 2012 at 9:51 AM, joseph camill wrote:

> Hi Seraj,
>
> Attached is the reference sheet.
>
> Thanks,
> Joseph
>
> On Thu, Jul 12, 2012 at 9:15 AM, Seraj Alam wrote:
>
>> Hi,
>>
>> Please attach the sheet for reference...
>>
>> Thanks
>> Seraj
>>
>>
>> On Wed, Jul 11, 2012 at 8:41 PM,  wrote:
>>
>>> Hi experts,
>>>
>>> The formulae provided by the members is working fine when I have data in
>>> one column. But if I have to do the same from multiple columns, then how do
>>> I do?
>>>
>>> Thanks,
>>> Joseph
>>> Sent on my BlackBerry® from Vodafone
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & Regards
>> Seraj Alam
>> *+91 989 130 1776*
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Look up errors from 2 sheets.

[Deba Ranjan]

Thanks Every greato great gurus.


Thanks & Regards,
*Deba Ranjan P*





On Thu, Jul 12, 2012 at 9:36 AM, Seraj Alam  wrote:

> Hi,
>
> Please see attached solution of your query and let me knowis it full
> fill your requirement or not???
>
>
>
> On Tue, Jul 10, 2012 at 2:50 AM, Deba Ranjan  wrote:
>
>> That is what the problem, i have like wise thousand datas which manually
>> not possible to enter one by one, i want to look up by some eventual
>> formulas.
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>>
>>
>> On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May wrote:
>>
>>> The lookup names have to be entered the same on both sheets, some need a
>>> space and some don't have a space.  Look more closely at the ones that
>>> yield #N/A.
>>>
>>>
>>> On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan wrote:
>>>
 Hi Experts,

 i am getting error in vlookups in finding the names from 2 sheets.
 i have used index, match formula, but still have some errors. Please look
 into this, might have lack of formulas in this. Please suggest what need to
 use in such cases.









 Thanks & Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Thanks & Regards
> Seraj Alam
> *+91 989 130 1776*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't

Re: $$Excel-Macros$$ Round The Value as User Defined.

[noorain . ansari]

Dear Ashish,
Please use

Mround(A1,5)
Sent from BlackBerry® on Airtel

-Original Message-
From: Ashish Bhalara 
Sender: excel-macros@googlegroups.com
Date: Thu, 12 Jul 2012 09:35:09 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Round The Value as User Defined.

Dear experts,

I want to round the value in following condition.
If the value is 148,149,150,151,152, Output is 150.
If the value is 153,154,155,156,157, Output is 155.
If the value is 158,159,160,161,162, Output is 160.

Kindly know me how its possible.

Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ extracting word from a string

[Priti_Verma]

Hi muneer ,

See the attach file. I think it will help you.

You can use the formula:

=trim(mid(substitute(" "&trim (a2)," ",rept(" ",250)),n*250,250))

 

Where

N=2,3,4,5,,6,7,8.

 

Regards priti verma

 

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

D.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Mohammed Muneer]

 

Good Morning,

Hi Priti,

 

Ya working fine!

 

Thanks to u,

 

Regards,

Muneer,

CC...

__

Hi Muneer

 

To Extract 1st Word use this : =LEFT(A2,FIND(" ",A2,1)-1)

To Extract Last word use this :  =MID(A2,FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2,"
","",LEN(A2)-FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ",""+1)

 

I think the better way is  to extract All word in different columns use
Text To Column Delimited by Space character , 

See the attached file.

 

Thanks 

Priti Verma

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 11 July 2012 10:20
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Extracting a word from the cell...

 

Dear Rajan & Priti Verma,

 

Any one word, left / right / middle.

 

Thanx both of u, for the reply.

 

Like - Sweet, Sewage & Portable.

 

In order to filter my data easily.

 

 

Regards,

Muneer,

CC...

__

Which word you want to extract?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]



 

Hi, Muneer , I want  to ask u ,which word u want to extract , last or
middle

 

Regards 

Priti verma

 

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
  On Behalf Of
Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  

Hi! Everybody,

Dear Group, 

 

I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment.

 

 

 

Regards,

Muneer,

CC

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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 o

Re: $$Excel-Macros$$ Unique list

[Seraj Alam]

Hi,

Please attach the sheet for reference...

Thanks
Seraj

On Wed, Jul 11, 2012 at 8:41 PM,  wrote:

> Hi experts,
>
> The formulae provided by the members is working fine when I have data in
> one column. But if I have to do the same from multiple columns, then how do
> I do?
>
> Thanks,
> Joseph
> Sent on my BlackBerry® from Vodafone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Unique list

[joseph . camill]

Hi experts,

The formulae provided by the members is working fine when I have data in one 
column. But if I have to do the same from multiple columns, then how do I do?

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Time calculation

[NOORAIN ANSARI]

Dear Lokesh,

Please find the attached sheet, Hope it will help to you.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com



On Thu, Jul 12, 2012 at 8:21 AM, Lokesh Loki wrote:

> Hi All,
>
> Please find the attached excel sheet and i need formula for total time
> taken.
>
> Let me know for any clarification.
>
> Regards
> Lokesh.M
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Rush time calculation(solved).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Time calculation

[Lokesh Loki]

Hi All,

Please find the attached excel sheet and i need formula for total time
taken.

Let me know for any clarification.

Regards
Lokesh.M

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Rush time calculation.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Please help me.

[Rajan_Verma]

 

 

=IFERROR(FIND([@Particulars],[@[Specification Marks, If Any]],1)>0,FALSE)

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 11 July 2012 2:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help me.

 

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

  www.excelmacroworld.blogspot.com

 

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.

On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
wrote:

Dear Expert.

 

i have 2 Coll A1 & B2

 

A1 Contain (Foto Fast Elec)

B1 Contain (Fast)

 

I want khow B1 is in A1 or not...

 

Regard

Manoj

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 



 

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

  www.excelmacroworld.blogspot.com

 



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

Re: $$Excel-Macros$$ Re: Extracting a word from the cell.......

[NOORAIN ANSARI]

Excellent Haseeb..

On Wed, Jul 11, 2012 at 10:37 PM, Haseeb A wrote:

> One common way to extract *n*th word. Assuming word separator is 'space'
>
>
>  =TRIM(MID(SUBSTITUTE(" "&TRIM(A1)," ",REPT(" ",250)),n*250,250))
>
> Eg: If we want to extract 3rd word, use it like;
>
> =TRIM(MID(SUBSTITUTE(" "&TRIM(A1)," ",REPT(" ",250)),3*250,250))
>
> If a cell doesn't have specified nth word, will return 'blank'
>
> Regards,
> Haseeb
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Extracting a word from the cell.......

[Haseeb A]

One common way to extract *n*th word. Assuming word separator is 'space'
 
 
 =TRIM(MID(SUBSTITUTE(" "&TRIM(A1)," ",REPT(" ",250)),n*250,250))

Eg: If we want to extract 3rd word, use it like;
 
=TRIM(MID(SUBSTITUTE(" "&TRIM(A1)," ",REPT(" ",250)),3*250,250))
 
If a cell doesn't have specified nth word, will return 'blank'
 
Regards,
Haseeb

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Numbers into Words

[Mangesh Vimay]

Please send new sheet as previous sheet is protected or provide the
password.


On Wed, Jul 11, 2012 at 4:36 PM, Abdulgani Shaikh wrote:

> Row no.28 Number marked in Yellow
> Row no.32 Words marked in Red
>
>
> On Wed, Jul 11, 2012 at 2:41 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Abdul,
>>
>> In attached sheet, I am unable to found yellow color, Please resend.
>>
>>
>> On Wed, Jul 11, 2012 at 2:36 PM, Abdulgani Shaikh > > wrote:
>>
>>> I want numbers marked in Yellow colour to be written in numbers as given
>>> in attached filed at Red Colour Coloumn .
>>>
>>> By using formula or By using macro whichever is easy.
>>>
>>> Regards
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ analysis

[Priti_Verma]

Hi Amresh,

It seems a very long formula , do you have any another solution.

Priti

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amresh Maurya
Sent: 11 July 2012 4:21
To: excel-macros@googlegroups.com; pritiverma1...@gmail.com
Subject: Re: $$Excel-Macros$$ analysis

Hi ,

kindly find the attached solution.

Regards
Amresh

On Wed, Jul 11, 2012 at 3:53 PM, Anil Gawli  wrote:
> Just see the Attached sheet. Is it ok ..
>
> Thanks & Regads,
> Gawli Anil
>
> On Wed, Jul 11, 2012 at 3:40 PM, NOORAIN ANSARI 
> 
> wrote:
>>
>> or Use.. below formula with ctrl+shfit+enter
>>
>> =SUM(IF(($A$2:$A$1010=$K$9)*($B$2:$B$1010=L$10)*($C$2:$C$1010=$K11),(
>> $F$2:$F$1010),"")
>>
>> On Wed, Jul 11, 2012 at 3:30 PM, Priti_Verma 
>> 
>> wrote:
>>>
>>>
>>>
>>> Hi,
>>>
>>> To all,
>>>
>>> I am new here,please help me ,to find out all details about the 
>>> country ,which is selected by drop down list.
>>>
>>> See the attached file.
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum 
>>> in signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> 
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum 
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. 
>> Forum owners and members are not responsible for any loss.
>>
>>
>> -
>> - To post to this group, send email 
>> to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum 
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. 
> Forum owners and members are not responsible for any loss.
>
> --
>  To post to this group, send email to 
> excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

---

RE: $$Excel-Macros$$ Extracting a word from the cell.......

[Priti_Verma]

Hi Muneer

 

To Extract 1st Word use this : =LEFT(A2,FIND(" ",A2,1)-1)

To Extract Last word use this :  =MID(A2,FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","",LEN(A2)-FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ",""+1)

 

I think the better way is  to extract All word in different columns use Text
To Column Delimited by Space character , 

See the attached file.

 

Thanks 

Priti Verma

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 11 July 2012 10:20
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Extracting a word from the cell...

 

Dear Rajan & Priti Verma,

 

Any one word, left / right / middle.

 

Thanx both of u, for the reply.

 

Like - Sweet, Sewage & Portable.

 

In order to filter my data easily.

 

 

Regards,

Muneer,

CC.

__

Which word you want to extract?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]



 

Hi, Muneer , I want  to ask u ,which word u want to extract , last or middle

 

Regards 

Priti verma

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting a word from the cell...

 

  


Hi! Everybody,


Dear Group, 


 


I want to extract a word from the sentence in cell beside.

 

Plz, find the attachment...

 

 

 

Regards,

Muneer,

CC..

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal o

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

[NOORAIN ANSARI]

Dear JP,

Please see the attached sheet.
Now we can separate

Baddi to Sunder Nagar
or
Sunder Nagar to Baddi

Please check and revert



On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S
wrote:

> Dear Masters,
>
> Greetings!!
>
> Could you please help me to split the Text thruough a Formula for the
> attached example...
>
>
> Thank you.
>
> JP.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of TEXT - HELP REQD ON HOW TO BREAK IT IN TO 3 COLUMNS(JP).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

[Manoj Kumar]

Dear Jp.

find the attachment...

i hope it will help you..

Regard
Manoj

On Wed, Jul 11, 2012 at 5:38 PM, Jayaprakash S
wrote:

> Dear Deba Rajan Sir,
>
> thank you... Your formula is working fine except for
>
> "Baddi to Sunder Nagar" Case..
>
> Any updation in your formula
>
> thank you.
>
> Jp.
>
>
> On Wed, Jul 11, 2012 at 5:31 PM, Deba Ranjan  wrote:
>
>> Dear Jaya,
>>
>>  You can also use:-
>> First Word:-
>> =IFERROR(LEFT(A3,FIND(" ",A3,1)),"")
>>
>> Second word-
>> =TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND("
>> ",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,""))
>> Third word:-
>> =RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3,"
>> ","#",LEN(A3)-LEN(SUBSTITUTE(A3," ","")
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>>  
>>
>>
>> On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear JP,
>>>
>>>Select the range Press ALT+D+E Click Delimited Next Click Space Click
>>> Finish
>>> Regard
>>> Manoj
>>>
>>>
>>> On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S <
>>> bhat.jayaprak...@gmail.com> wrote:
>>>
 Dear Masters,

 Greetings!!

 Could you please help me to split the Text thruough a Formula for the
 attached example...


 Thank you.

 JP.

 --
 FORUM RULES (986+ members already BANNED for violation)

 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)  Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
> desirable habit for success - Swamy Vivekananda. This message is for
> the designated recipient only and may contain privileged, proprietary,
> or otherwise private information. If you have received it in error,
> please notify the sender immediately and delete the original. Any other
> use of the email by you is prohibited.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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 at

Re: $$Excel-Macros$$ switch on anf off calculation

[dguillett1]

sub yourmacro()
Application.Calculation=xlCalculationManual 
your macro
Application.Calculation=xlCalculationautomatic
end sub


Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: pawel lupinski 
Sent: Wednesday, July 11, 2012 1:56 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ switch on anf off calculation

Thanks for that but how to do this ? how to set it up, sorry but not very good 
at it, I've just started to learn VB.
Can you help me?

Thanks

Pawel

From: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com"  
Sent: Wednesday, July 11, 2012 3:05 AM
Subject: Re: $$Excel-Macros$$ switch on anf off calculation


Use this line in your macro :-


Application.Calculation=xlCalculationManual 


Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.

From: pawel lupinski 
To: "excel-macros@googlegroups.com"  
Sent: Wednesday, 11 July 2012 7:03 AM
Subject: $$Excel-Macros$$ switch on anf off calculation


Hi All,

can you  help me on this. I have quite large excel file, because there is a lot 
of calculation, I'd like to switch off excel calculation and when I'll be 
closing file schitch on calculation. I mean by macro (manually I know how to do 
this :) )

thanks a lot

Pawel
-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, 

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

[Deba Ranjan]

Dear Jaya,

 You can also use:-
First Word:-
=IFERROR(LEFT(A3,FIND(" ",A3,1)),"")

Second word-
=TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND("
",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,""))
Third word:-
=RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3,"
","#",LEN(A3)-LEN(SUBSTITUTE(A3," ","")



Thanks & Regards,
*Deba Ranjan P*





On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar wrote:

> Dear JP,
>
>  Select the range  Press ALT+D+E  Click Delimited  Next  Click Space  Click
> Finish
> Regard
> Manoj
>
>
> On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S  > wrote:
>
>> Dear Masters,
>>
>> Greetings!!
>>
>> Could you please help me to split the Text thruough a Formula for the
>> attached example...
>>
>>
>> Thank you.
>>
>> JP.
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Text - Splitting - Help Required through Formula

[Jayaprakash S]

Dear Masters,

Greetings!!

Could you please help me to split the Text thruough a Formula for the
attached example...


Thank you.

JP.

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

TEXT - HELP REQD ON HOW TO BREAK IT IN TO 3 COLUMNS.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ analysis

[NOORAIN ANSARI]

or Use.. below formula with ctrl+shfit+enter
=SUM(IF(($A$2:$A$1010=$K$9)*($B$2:$B$1010=L$10)*($C$2:$C$1010=$K11),($F$2:$F$1010),"")

On Wed, Jul 11, 2012 at 3:30 PM, Priti_Verma wrote:

> * *
>
> *Hi,*
>
> *To all,*
>
> *I am new here,please help me ,to find out all details about the country
> ,which is selected by drop down list.*
>
> *See the attached file.*
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ analysis

[Ahmed Honest]

Use Pivot Table you should get the desired



On Wed, Jul 11, 2012 at 1:00 PM, Priti_Verma wrote:

> * *
>
> *Hi,*
>
> *To all,*
>
> *I am new here,please help me ,to find out all details about the country
> ,which is selected by drop down list.*
>
> *See the attached file.*
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Ahmed Bawazir
*احمد باوزير*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ analysis

[Anil Gawli]

Show us a sample format.
For Idea.

Thanks & Regards,
Gawli Anil

On Wed, Jul 11, 2012 at 3:30 PM, Priti_Verma < wrote:

>  * *
>
> *Hi,*
>
> *To all,*
>
> *I am new here,please help me ,to find out all details about the country
> ,which is selected by drop down list.*
>
> *See the attached file.*
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Split tif page using EXCEL VBA

[Ganesh S]

On Tuesday, July 10, 2012 7:34:49 PM UTC+5:30, Ganesh S wrote:
>
>
> Hi All,
>
> I got the below coding from some other sites.. but while executing this 
> macro, i got error messages and i can't solve this coding issue. Please 
> help me to get resolve or any new coding to split tif images thru excel vba 
> macro.
>
> "*
>
> Option Explicit
>
> Dim ImageFile As Long
> Dim BitMapImage As Long
>
> Private Sub cmdFile_Click()
> cmdSplit.Enabled = False
>
> ' create a open dialog so that you can select
> ' the multipage tiff to split
> CommonDialog.InitDir = App.Path
> CommonDialog.DialogTitle = "Select Multi Page TIFF"
> CommonDialog.DefaultExt = "*.TIF"
> CommonDialog.Filter = "TIF Files|*.TIF|TIFF Files|*.TIFF"
> CommonDialog.ShowOpen
>
> If (Len(CommonDialog.Filename) > 0) Then
>
> ' apply the selected image to the Kodak
> ' thumbnail control to display icons of the
> ' different pages
> imgThumb.Image = CommonDialog.Filename
> imgThumb.Refresh
>
> ' use the FreeImage DLL to open the multipage
> ' TIFF file, and use the GetPageCount function
> ' to determine if there are multiple pages to
> ' process
>
> ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _
> CommonDialog.Filename, False, True)
>
> If (FreeImage_GetPageCount(ImageFile) > 1) Then
> cmdSplit.Enabled = True
> End If
>
> ' update caption bar with filename + page count
> Caption = CommonDialog.Filename & " " & _
> FreeImage_GetPageCount(ImageFile) & " page(s)"
>
> ' close the multi-page TIFF file
> Call FreeImage_CloseMultiBitmap(ImageFile)
> End If
> End Sub
>
>
> Private Sub cmdSplit_Click()
> Dim pages As Integer
> Dim i As Integer
>
> ' use the FreeImage DLL to open the multipage
> ' TIFF file, and use the GetPageCount function
> ' to determine if there are multiple pages to process
> ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _
> CommonDialog.Filename, False, True)
>
> pages = FreeImage_GetPageCount(ImageFile)
>
> i = 0
> Do While i <= (pages - 1)
> ' use the lock page function to copy that
> ' page into a new variable BitMapImage
> BitMapImage = FreeImage_LockPage(ImageFile, i)
>
> ' save that page out to a new filename
> Call FreeImage_Save(FIF_TIFF, BitMapImage, _
> App.Path & "\page" & i + 1 & ".tif")
>
> ' unlock the page
> Call FreeImage_UnlockPage(ImageFile, i, False)
>
> i = i + 1
> Loop
>
> ' close the multi-page TIFF file
> Call FreeImage_CloseMultiBitmap(ImageFile)
>
> ' feedback to user that process is complete
> MsgBox pages & " pages, split from " & _
> CommonDialog.Filename, vbInformation, "Complete"
> End Sub
>
> *
>
> I will expect your views and suggestion to get solution for this coding. 
> Please let me know if you have any clairifications.
>
> Thanks & Regards,
> Ganesh 

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ no of sheets in a workbook

[सुनिता पौडेल]

wow you consider learner m wondering what your expertise be :O
you all are rockstar here
thank you very very much for the help
I crave learning from you wonderful people. Thank you for takin time to
prepare the screen shot tuts

Regards,
Sunita

On Wed, Jul 11, 2012 at 2:53 PM, Deba Ranjan  wrote:

> Its Ok Sunita Ji, You are part of this lovely forum, Definitely help you
> out, Let me tell you, i am also a learner in this group.
> Hence any way , i will send you ASAP by through screen shot step by step
> from the beginning for better understanding. I just preparing it the same.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>
>
> On Wed, Jul 11, 2012 at 2:32 PM, सुनिता पौडेल  wrote:
>
>> Dear Deba ji,
>>
>> Can you please check where I went wrong? Sorry for giving you trouble
>> again and again...
>>
>> Regards,
>>
>> Sunita
>>
>> On Wed, Jul 11, 2012 at 2:35 PM, Deba Ranjan  wrote:
>>
>>> Dear Sunita Ji,
>>>
>>> After Alt + F11,
>>> Go to View And Select Project Explorer,
>>> Selcect Projects Windows too, it will help to change its Properties.
>>> Select the desrie requirements in the Project Explorer, Double click the
>>> desire objects, you will find the codes. And refer the before attached file.
>>>
>>>
>>> Thanks & Regards,
>>> *Deba Ranjan P*
>>>
>>>
>>> 
>>>
>>>
>>> On Wed, Jul 11, 2012 at 2:15 PM, सुनिता पौडेल wrote:
>>>
 Dear Deba ji,

 While I do Alt+f11 blank workbook shows. What to do?
 However I inserted userform and followed upto step 10. Here i got
 stuck. Do I have to copy the codes twice ? I am so blank

 Regrds


 On Wed, Jul 11, 2012 at 11:06 AM, Deba Ranjan wrote:

> Dear Sunita Ji,
>
> Hope below step may help you, Rest By our Lovely Experts will
> elaborate you more.
>
> 1. Go to Developer
> 2. Click Insert
> 3. Button (Form Control)
> 4. Assign Macros to Buttons
> 5. View Code (Alt + F11)
> 6. We need 1 Userform, so insert userform
> 7. Insert 1 List Box in the userform
> 8. Insert 3 command buttons in the Userform
> 9. Insert I checkBox
> 10.Double click the desrire buttons or List box and Insert the codes.
>(See the attached file of the user form and codes)
> 11. Initialize UserForm and write code given below.
>
> See the attached file and by pressing Alt + F11 , please see the
> coding , hope you will understand the basic.
>
>
>
> Eg:-
>
> Option Explicit
>
> Public OriginalSheet As Object
>
> Private Sub CommandButton1_Click()
> MsgBox Sheets.Count
> End Sub
>
> Private Sub Label1_Click()
>
> End Sub
>
> Private Sub UserForm_Initialize()
> ' Recorded by deba to show Sheet Names
> Dim SheetData() As String
> Dim ShtCnt As Integer
> Dim ShtNum As Integer
> Dim Sht As Object
> Dim ListPos As Integer
>
> Set OriginalSheet = ActiveSheet
> ShtCnt = ActiveWorkbook.Sheets.Count
> ReDim SheetData(1 To ShtCnt, 1 To 4)
> ShtNum = 1
> For Each Sht In ActiveWorkbook.Sheets
> If Sht.Name = ActiveSheet.Name Then _
>   ListPos = ShtNum - 1
> SheetData(ShtNum, 1) = Sht.Name
> Select Case TypeName(Sht)
> Case "Worksheet"
> SheetData(ShtNum, 2) = "Sheet"
> SheetData(ShtNum, 3) = _
>   Application.CountA(Sht.Cells)
> Case "Chart"
> SheetData(ShtNum, 2) = "Chart"
> SheetData(ShtNum, 3) = "N/A"
> Case "DialogSheet"
> SheetData(ShtNum, 2) = "Dialog"
> SheetData(ShtNum, 3) = "N/A"
> End Select
> If Sht.Visible Then
> SheetData(ShtNum, 4) = "True"
> Else
> SheetData(ShtNum, 4) = "False"
> End If
> ShtNum = ShtNum + 1
> Next Sht
> With ListBox1
> .ColumnWidths = "100 pt;30 pt;40 pt;50 pt"
> .List = SheetData
> .ListIndex = ListPos
> End With
> End Sub
>
> Private Sub CancelButton_Click()
> OriginalSheet.Activate
> Unload Me
> End Sub
>
> Private Sub cbPreview_Click()
> If cbPreview Then Sheets(ListBox1.Value).Activate
> End Sub
>
> Private Sub ListBox1_Click()
> If cbPreview Then _
> Sheets(ListBox1.Value).Activate
> End Sub
>
> Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
> Call OKButton_Click
> End Sub
>
> Private Sub OKButton_Click()
> Dim UserSheet As Object
> Set UserSheet = Sheets(ListBox1.Value)
> If UserSheet.Visible Then
> UserSheet.Activate
> Else
> If MsgBox("Unhide sheet?", _
>   vbQuestion + vbYesNo

Re: $$Excel-Macros$$ Numbers into Words

[NOORAIN ANSARI]

Dear Abdul,

In attached sheet, I am unable to found yellow color, Please resend.

On Wed, Jul 11, 2012 at 2:36 PM, Abdulgani Shaikh wrote:

> I want numbers marked in Yellow colour to be written in numbers as given
> in attached filed at Red Colour Coloumn .
>
> By using formula or By using macro whichever is easy.
>
> Regards
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ no of sheets in a workbook

[Deba Ranjan]

Dear Sunita Ji,

After Alt + F11,
Go to View And Select Project Explorer,
Selcect Projects Windows too, it will help to change its Properties.
Select the desrie requirements in the Project Explorer, Double click the
desire objects, you will find the codes. And refer the before attached file.


Thanks & Regards,
*Deba Ranjan P*





On Wed, Jul 11, 2012 at 2:15 PM, सुनिता पौडेल  wrote:

> Dear Deba ji,
>
> While I do Alt+f11 blank workbook shows. What to do?
> However I inserted userform and followed upto step 10. Here i got stuck.
> Do I have to copy the codes twice ? I am so blank
>
> Regrds
>
>
> On Wed, Jul 11, 2012 at 11:06 AM, Deba Ranjan  wrote:
>
>> Dear Sunita Ji,
>>
>> Hope below step may help you, Rest By our Lovely Experts will
>> elaborate you more.
>>
>> 1. Go to Developer
>> 2. Click Insert
>> 3. Button (Form Control)
>> 4. Assign Macros to Buttons
>> 5. View Code (Alt + F11)
>> 6. We need 1 Userform, so insert userform
>> 7. Insert 1 List Box in the userform
>> 8. Insert 3 command buttons in the Userform
>> 9. Insert I checkBox
>> 10.Double click the desrire buttons or List box and Insert the codes.
>>(See the attached file of the user form and codes)
>> 11. Initialize UserForm and write code given below.
>>
>> See the attached file and by pressing Alt + F11 , please see the coding ,
>> hope you will understand the basic.
>>
>>
>>
>> Eg:-
>>
>> Option Explicit
>>
>> Public OriginalSheet As Object
>>
>> Private Sub CommandButton1_Click()
>> MsgBox Sheets.Count
>> End Sub
>>
>> Private Sub Label1_Click()
>>
>> End Sub
>>
>> Private Sub UserForm_Initialize()
>> ' Recorded by deba to show Sheet Names
>> Dim SheetData() As String
>> Dim ShtCnt As Integer
>> Dim ShtNum As Integer
>> Dim Sht As Object
>> Dim ListPos As Integer
>>
>> Set OriginalSheet = ActiveSheet
>> ShtCnt = ActiveWorkbook.Sheets.Count
>> ReDim SheetData(1 To ShtCnt, 1 To 4)
>> ShtNum = 1
>> For Each Sht In ActiveWorkbook.Sheets
>> If Sht.Name = ActiveSheet.Name Then _
>>   ListPos = ShtNum - 1
>> SheetData(ShtNum, 1) = Sht.Name
>> Select Case TypeName(Sht)
>> Case "Worksheet"
>> SheetData(ShtNum, 2) = "Sheet"
>> SheetData(ShtNum, 3) = _
>>   Application.CountA(Sht.Cells)
>> Case "Chart"
>> SheetData(ShtNum, 2) = "Chart"
>> SheetData(ShtNum, 3) = "N/A"
>> Case "DialogSheet"
>> SheetData(ShtNum, 2) = "Dialog"
>> SheetData(ShtNum, 3) = "N/A"
>> End Select
>> If Sht.Visible Then
>> SheetData(ShtNum, 4) = "True"
>> Else
>> SheetData(ShtNum, 4) = "False"
>> End If
>> ShtNum = ShtNum + 1
>> Next Sht
>> With ListBox1
>> .ColumnWidths = "100 pt;30 pt;40 pt;50 pt"
>> .List = SheetData
>> .ListIndex = ListPos
>> End With
>> End Sub
>>
>> Private Sub CancelButton_Click()
>> OriginalSheet.Activate
>> Unload Me
>> End Sub
>>
>> Private Sub cbPreview_Click()
>> If cbPreview Then Sheets(ListBox1.Value).Activate
>> End Sub
>>
>> Private Sub ListBox1_Click()
>> If cbPreview Then _
>> Sheets(ListBox1.Value).Activate
>> End Sub
>>
>> Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
>> Call OKButton_Click
>> End Sub
>>
>> Private Sub OKButton_Click()
>> Dim UserSheet As Object
>> Set UserSheet = Sheets(ListBox1.Value)
>> If UserSheet.Visible Then
>> UserSheet.Activate
>> Else
>> If MsgBox("Unhide sheet?", _
>>   vbQuestion + vbYesNoCancel) = vbYes Then
>> UserSheet.Visible = True
>> UserSheet.Activate
>> Else
>> OriginalSheet.Activate
>> End If
>> End If
>> Unload Me
>> End Sub
>>
>>
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>>
>>
>> On Wed, Jul 11, 2012 at 9:55 AM, सुनिता पौडेल wrote:
>>
>>> Dear Noorain, Don and all,
>>>
>>> While doing as per your infomation the list of file names shows in the
>>> first sheet. Please teach me as to how to assign a button so that when I
>>> click it shoes the list box like the one Mr.Deba has attached.
>>>
>>> Thanking all the wonder people,
>>>
>>> Sunita
>>>
>>>
>>>
>>>
>>> On Tue, Jul 10, 2012 at 6:44 PM, dguillett1 wrote:
>>>
   Sub listfiles()
 For i = 1 To Sheets.Count
 Cells(i, 1) = Sheets(i).Name
 Next
 End Sub

 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  *From:* amitkmr 
 *Sent:* Tuesday, July 10, 2012 12:41 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ no of sheets in a workbook

 Dear Sir,

 Do we have a shortcut to know the number and name of the sheets in a
 workbook and also list them in sequence.

 Amit Kumar

 --
 FORUM RULES (986+ members alread

Re: $$Excel-Macros$$ Please help me.

[NOORAIN ANSARI]

Dear Suman,

It is working fine with table, Pls see the attached sheet.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jul 11, 2012 at 1:43 PM, Suman  wrote:

> Hi,
> Guru Ji,
> Its not working when i applying in table. Please guide...!!
>
> Regards,
> @Suman
> Send on the move with Galexy y.
> On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI" 
> wrote:
>
>> Dear Manoj,
>>
>> You can also try
>> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>>
>> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
>> wrote:
>>
>>> Dear Expert.
>>>
>>> i have 2 Coll A1 & B2
>>>
>>> A1 Contain (Foto Fast Elec)
>>> B1 Contain (Fast)
>>>
>>> I want khow B1 is in A1 or not...
>>>
>>> Regard
>>> Manoj
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Suman(test).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Please help me.

[Suman]

Hi,
Guru Ji,
Its not working when i applying in table. Please guide...!!

Regards,
@Suman
Send on the move with Galexy y.
On Jul 11, 2012 1:28 PM, "NOORAIN ANSARI"  wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please help me.

[Manoj Kumar]

Thanks Noorain Ji...
its working..


On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote:

> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar 
> wrote:
>
>> Dear Expert.
>>
>> i have 2 Coll A1 & B2
>>
>> A1 Contain (Foto Fast Elec)
>> B1 Contain (Fast)
>>
>> I want khow B1 is in A1 or not...
>>
>> Regard
>> Manoj
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please help me.

[NOORAIN ANSARI]

Dear Manoj,

You can also try
=IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar wrote:

> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Please help me.

[Amresh Maurya]

Hi,

use below formula

=find(B1,A1)

Regards
Amresh

On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar  wrote:
> Dear Expert.
>
> i have 2 Coll A1 & B2
>
> A1 Contain (Foto Fast Elec)
> B1 Contain (Fast)
>
> I want khow B1 is in A1 or not...
>
> Regard
> Manoj
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com