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).
Clea
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 refer
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 R
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.
Dea
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,
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("*",SUBSTITU
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,
> Josep
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,
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 tot
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
=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
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(" "
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
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 att
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
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 extr
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 Formu
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.
>
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.
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," ","")
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, For
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
> ,whi
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.*
>
> ** **
>
> --
> FORU
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.*
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
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
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
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.
Than
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...!!
>
> R
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
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
>>
>> A
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
>
> --
>
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
33 matches
Mail list logo
