Dear Noorain,
Your macro is working, but if there is any formula for this.?
And one thing more i think under formula is not working properlywhich was post
by buddy(MR. RAJAN)
IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))*ROW(INDIRECT("1:"&LEN(A1))),ROW(
Dear Amit,
You can use it..
*=INDIRECT(ADDRESS(9+ROW(A3),12))*
See attached sheet
Hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
> Hi Experts
>
> I want to pick value
Hi Mr. Anil
This is not the solution i am looking for. I need to pick this from some
LIST for every cell.
Regards
Amit
On Tue, May 29, 2012 at 11:41 AM, Anil Gawli wrote:
> see the attached sheet
> Regards
> Gawli Anil
>
> On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
>
>> Hi Experts
>
Hello champ.,
This formula is picking up only first disit of cell only.
1001GANG 1
1002COL. 1
1002TEJI 1
1003SUDH 1
Regards
LAKSHMAN
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Monday, May 28, 2012 7:12 PM
Subject: RE: $$Excel-Macros$$ How
see the attached sheet
Regards
Gawli Anil
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
> Hi Experts
>
> I want to pick value in Cell C7, C8, C9 ………from List given in Column
> "L" in attached file.
>
> How it will be possible? Pls help me here.
>
> Regards
>
> Amit
>
>
> --
> FORUM RU
Hi Experts
I want to pick value in Cell C7, C8, C9 ………from List given in Column
"L" in attached file.
How it will be possible? Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Great expertise Noorain sir,
. can we create formula without using vb macors for this
extractions ?
Thanks & Regards,
*Deba Ranjan P*
On Tue, May 29, 2012 at 11:09 AM, Ashish Bhalara
wrote:
> Its a great macro Noorainji, Thanks.
>
> Ashish Bhalara
>
>
> On Tue, May 29, 2012 at
Its a great macro Noorainji, Thanks.
Ashish Bhalara
On Tue, May 29, 2012 at 10:59 AM, NOORAIN ANSARI
wrote:
> Dear Deba,
>
> Please try it
>
> For Number
> *Function Only_Number(rng As Range)
> Dim i As Integer
> For i = 1 To Len(rng)
> If IsNumeric(Mid(rng, i, 1)) Then
> Only_Number = Only_Num
Dear experts,
its a awesome expertise work. Now - Can we extract only words and
numbers separately from Alphanumeric, alphanumericalpha, Numericalpha, or
numericalphanumeric.
eg.
MOHANAN157896
RAJU78785545GAYATRI
787984544RAJANANA
879445JOCKER789
thanks...
T
Hi Rajan,
One quick question on the " {=SUM(--(A2>$A$2:$A$8))+1} ".How does the sum
function is raking the data in "column1".on what basis..Could you please
explain in more elaborated way.
Thanks again,
Prabhakar
On Mon, May 28, 2012 at 7:10 PM, Rajan_Verma wrote:
> ** **
>
> Thanks Noorain t
Dear Rajan,
The file that you have shared is quite awesome. Can you please share us
the coding too as you have protect the code with password. i Think it will
be a great contribution form you side to the fellow members in this forum.
Great job. thanks for sharing such experience.
Thanks & Re
Thanks to all of you. Its working fine.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Mon, 28 May 2012 10:52:43
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Data valid
*Create a Reference to the Source List*
1. Open the workbook that contains the source list -- DataValWb.xls in
this example.
2. Open the workbook in which you wish to use the list in Data
Validation.
3. Choose Insert>Name>Define
4. Type a name for the List, e.g. *MyList*
5. In
thanks a lot Noorain
this is what I was looking for
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Monday, May 28, 2012 9:19 AM
Subject: Re: $$Excel-Macros$$ problem with indirect function
On Mon, May 28, 2012 at 1:48 PM, NOORAIN AN
homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Jean PIERRE
Sent: Monday, May 28, 2012 3:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA code to add many rows at the end of a named range
?
Which is the VBA code to add many rows at
Dear gurus,
I want to learn access report making from begining, please suggest any site or
material which may help
Thanx in advance
Prashant
Sent from my iPhone 4S
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Hi Sandeep,
Definitely, you can use Namerange in data validation list command for your
requirement.
Please ignore the previous sheet & check the new attached sheet for the
same, hope it will help you.
Regards,
Gyana Ranjan Das
On Mon, May 28, 2012 at 9:11 PM, wrote:
> Dear excel guru,
>
> I
Hi Sandeep,
Definitely you can use Namerange in data validation list command for your
requirement.
Please check the attached sheet for the same, hope it will help you.
Regards,
Gyana Ranjan Das
On Mon, May 28, 2012 at 9:11 PM, wrote:
> Dear excel guru,
>
> Is there any way I can keep source
Which is the VBA code to add many rows at the end of a named range ?
The new rows must be part of the named range !
Thank you for your answer !
Regards,
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
Which is the VBA code to add a row at the end of a named range ?
The new row must be part of the named range !
Thank you for your answer !
Regards,
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
use a define name for the dv list in the other sheet such as
dvlist
then in the dv> list > =dvlist
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: chhajersand...@gmail.com
Sent: Monday, May 28, 2012 10:41 AM
To: excel-macros@googlegroup
Install in separate folders and be sure to set your file associations as
desired.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rekha siri
Sent: Monday, May 28, 2012 8:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ compatibility issues wi
Dear excel guru,
Is there any way I can keep source data list in another sheet (other than where
I want to put the data validation) for data validation "list" command.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use conci
Thanks Ansari..
On Mon, May 28, 2012 at 1:56 PM, NOORAIN ANSARI wrote:
> Dear rao,
>
> The -- is used as an unary operator to convert a boolean value ie,
> TRUE/FALSE in to 1/0.
>
> So to negate this, we use unary operator -- with TRUE or FALSE to give 1
> or 0
>
> We can also use, *0+,*1,^1* or
Hello Gurus
i am trying to design an investment automatic rollover . So if an
investment matures i want the details to automatically rollover, and show
the details of the rollover, i have been able to write the initial formula
to rollover first date details when the investment matures but the pro
Awesome..thanks Rajan..for helping me to understand..
Cheers,
Prabhakar
On Mon, May 28, 2012 at 7:10 PM, Rajan_Verma wrote:
> ** **
>
> Thanks Noorain to describe about “- -“ Sign
>
> ** **
>
> *Well here is the logic what I applied to get a sorted list in dropdown*
>
> * *
>
>
>
> * *
Use with On error
Sub MTest()
On Error Resume Next
ActiveSheet.UsedRange.Value = 0
Err.Clear
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chhajersand...@gmail.com
Sent: 2
Thanks Rajan I will try it!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Mon, 28 May 2012 19:17:12
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ macro to make unlocke
Hi Amit,
Thanks and nice example to do study of Count() function.
Mangesh
On Mon, May 28, 2012 at 7:45 PM, Amit Desai (MERU)
wrote:
> Dear Mangesh,
>
> ** **
>
> Please find attached simple solution that could not click when i was
> working under pressure...but later today it clicked me...
Just give the front end.
how you want to attached the file.. where you will put the Email ID and so
on
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of t vinay
Sent: 28 May 2012 7:47
To: excel-macros@g
Hi Rajan,
this is excellent, can you help with the code that you have used. as my
requirement is on the same line.
On 17 May 2012 18:44, Rajan_Verma wrote:
> Try My Excel Outlook J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-
Dear Mangesh,
Please find attached simple solution that could not click when i was working
under pressure...but later today it clicked me...
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Dayne
Sent: 28 May 2012 17:29
To: exce
Hi All,
Please help me on below query.
With regards,
Mangesh
On Mon, May 28, 2012 at 5:12 PM, Mangesh Dayne wrote:
> HI Noorain,
>
> Thanks for your reply.
> However, I didn't get about the red highlighted code.
> I have attached snapshot about what I need. Please find it and help me.
>
> Let
Protect your sheet and Run this :
Sub MTest()
ActiveSheet.UsedRange.Value = 0
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandeep Chhajer
Sent: 28 May 2012 6:37
To: excel-macr
Hi,
If your data in Alphanumeric value in A1 then use it in B1
=IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1
))),1)))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MI
D(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--I
Firstly would like to thank for the advise, Actually one of our users uses
MS office 2007 it took nearly 6hours time to prepare some pivot table and
formulas as the data is over 600k rows. were as in office 2010 using power
pivot he could able to fix it in five minutes.
so please advise, will it b
Dear Excel Guru,
I have a protected sheet where some cells are unprotected.
i want a macro which can make all unprotected cells to zero value.
Thanking you in advance.
--
Regards,
Sandeep Kumar Chhajer.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thre
Hello anil,
I will try your formula but i could not get same result. how it work
plz discraibe.
Regards
same here
--
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
HI Amit,
Thats good but can you share your answer within group so that excel lovers
like me could understand it for future ref. U can attached solved sheet too.
Thanks
With regards,
Mangesh
On Mon, May 28, 2012 at 10:41 AM, Amit Desai (MERU) wrote:
> I got the solution by some R&D.. thanks
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD wrote:
> How to collect only numeric value from a particular cell
> **
>1462NIRM
> 1462
> 1464NIRM
> 1464
> 1465NIRM
> 1465
> 1404--BL
> 1404
> 1031Infr
> 1031
> 8020LOKN
> 8020
>
How to collect only numeric value from a particular cell
1462NIRM 1462
1464NIRM 1464
1465NIRM 1465
1404--BL 1404
1031Infr 1031
8020LOKN 8020
202D.B. 202
922Parmi 922
5071RIFA 5071
1040Harj 1040
5078Harj 5078
1471Raj 1471
1571Raj 1571
414Ruchi 414
2084AJAY 2084
Regards
LAKSHMAN
Dear rao,
The -- is used as an unary operator to convert a boolean value ie,
TRUE/FALSE in to 1/0.
So to negate this, we use unary operator -- with TRUE or FALSE to give 1 or
0
We can also use, *0+,*1,^1* or *N()*
In fact you can also use a multiplier or a divisor of 1
In case you'd like more
On Mon, May 28, 2012 at 1:48 PM, NOORAIN ANSARI wrote:
> Dear Pawel,
>
> Please try this one.
>
> =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE)
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On M
Dear Pawel,
Please try this one.
=INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE)
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote:
> Dear All,
> I have prob
Hi Rajan,
I ma not able to understand the formula that u have created in column2,
especially the "--", what do they signify
=SUM(--(A2>$A$2:$A$8))+1
Please advice
Regards,
Prabhakar
On Thu, May 17, 2012 at 6:22 PM, Rajan_Verma wrote:
> Hi
>
> Please find the attached Sheet
>
> *It p
45 matches
Mail list logo
