Try this:
=IF(ISERROR(MID(A2,FIND(%,A2,1)-2,3)),,MID(A2,FIND(%,A2,1)-2,3))
On Sat, Oct 1, 2011 at 3:08 PM, karan 1237 karan1...@gmail.com wrote:
Hello All,
Hope you all are doing well. I'm here as usual, need your assistance. I'v
text data which have percentage numbers (50% or 60%), I need
As Ashish rightly points out, these functions will work if your percentages
are written in ascending order. However, in cases where your text may look
like this
10+2 with 60% with pcm or 45% in the aggregate, it will return 60%, not 45%
To tackle this issue, try the following array formula
Here's one way of doing it.
Sub CopyDuplicates()
With Range(B2:B Cells(Rows.Count, 1).End(xlUp).Row)
.Formula = =COUNTIF($A$2:$A$ Cells(Rows.Count, 1).End(xlUp).Row
,A2)
.Value = .Value
.Cells(0) = COUNT
.Cells(0).Resize(.Rows.Count + 1).AutoFilter 1, 1
congrate mate
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
for the 2nd year in row...
Congrate Ayush
--
Thanks regards,
Noorain Ansari
Congrats Ayush
On Sun, Oct 2, 2011 at 8:54 PM, B.N.Chethan kumar chetankumar1...@gmail.com
wrote:
congrate mate
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
for
Congrats ayush...
Rgds
sachin
Sent by emoze push m@il on 3G.
-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Subject:$$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..
Date: 02nd October 2011 8:10 pm
Dear Group,
Our Group Manager
Your success precedes you Ayush. We acknowledge and appreciate your
contribution to the Excel community, and so have Microsoft. Congratulations
again on behalf of all those who have and will gain from your selfless
endeavors.
Best Regards
Sam Mathai Chacko (GL)
On Sun, Oct 2, 2011 at 8:54 PM,
Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E$1,1))
EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1))
Data=IF((EntryDate=Sheet2!$A1)*(EntryDate=Sheet2!$B1)=1,Vehicle,)
Congratulation Noorain
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people through his
expertise. He
Congratulation Ayush.
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
for the 2nd year in row...
Congrate Ayush
--
Thanks regards,
Noorain Ansari
Congratulation Ayush..
On Sun, Oct 2, 2011 at 8:55 PM, ashish koul koul.ash...@gmail.com wrote:
Congrats Ayush
On Sun, Oct 2, 2011 at 8:54 PM, B.N.Chethan kumar
chetankumar1...@gmail.com wrote:
congrate mate
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI
Congratt Noorain bhai you rock
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people through
Congrats Our Fankaar Mate ..you are excellent in Excel.. Keep it Up..
On Sun, Oct 2, 2011 at 9:28 PM, XLS S xlst...@gmail.com wrote:
Congratulation Noorain
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.comwrote:
Hello Everyone,
Noorain Ansari has been selected as
As an M$ Excel MVP, I also welcome him to the group
From: NOORAIN ANSARI
Sent: Sunday, October 02, 2011 10:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ New Microsoft MVP Mr. Ayush Jain (2nd Times)..
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the
You can Also use Conditional Fomatting in Excel-2007 to Identify Dulicatte
Recort.
GoTo Conditional Formatting - new Rule - Format Only Unique Or Duplicate
Values .
Regards
Rajan
On Sun, Oct 2, 2011 at 5:45 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Here's one way of doing it.
Sub
Congrats Noorain. You deserved it..
Congrats to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
Paul for your valuable suggestions
Regards
Shiek
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as
Dear Sam,
Thanks for the detailed explanation but I could not understand the range
Data - how to create a range. I have selected data set in for Vehicle
EntryDate created data range for the same. But could not move further since
I could not create Data range.
And yes, thanks a lot for
Amit, please go to Names Manager, and give the name of the range as Data,
and use the formula that I provided below. To go to Name Manager using a
short-cut key, hit CTRL+F3
Post back if you need more help.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 3, 2011 at 12:10 AM, Amit Desai (MERU)
Urgent !!
i Need VB lines codes for
2011/10/1 ChilExcel chilexcel...@gmail.com
hi
i Need VB lines codes for
Alert MsgBox Pair duplicate entry in row
Column D function account and duplicates alerts (NO Problem!)
Attach File , thank you all
--
Visita ;
Thank you Noorain for working so hard to help all of us who need it.
It is very much appreciated
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear Ayush,
Congrats
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft
Congratulation Noorain...
Regards
Amresh
On Sat, Oct 1, 2011 at 12:13 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people through his
22 matches
Mail list logo