Good Collections Maries..
and you also follow excel macro group on regular basis.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Sun, Mar 18, 2012 at 1:30 PM,
Go to data- remove duplicates
Krishnan
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Karan Singh karan1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 19 Mar 2012 13:07:52
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Really this link will pay more to each excel user.
Excellent collection !
Divaker
On Mon, Mar 19, 2012 at 12:32 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Good Collections Maries..
and you also follow excel macro group on regular basis.
--
Thanks regards,
Dear Karan,
Please use below code..
Dim i, j As Integer
Application.ScreenUpdating = False
For i = 1 To Range(A65536).End(xlUp).Row
For j = 1 To Range(B65536).End(xlUp).Row
If Range(A i).Value = Range(B j).Value Then
Range(B j).Delete Shift:=xlUp
End If
Next j
Next i
I am using Excel 2007
I have a list of single letters A to F in column H2 to H26
These letters are are mixed but only one capital letter per cell
I want to go to this list and replace each letter by its numerical value.
So A becomes 1, B becomes 2, C becomes 3 and so on to the letter F
Can you
My heartly thanks to all of you.
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He
Hi,
Try it,
Dear Brother,
Heartily congratulation to you. Really feeling proud to be your friend.
Keep it up.
On Mon, Mar 19, 2012 at 1:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
My heartly thanks to all of you.
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.comwrote:
Hi,
Also try below code for your quary,
Sub numeric()
Dim MyCell As Range
For Each MyCell In Selection.Cells
MyCell.Value = Asc(UCase(MyCell)) - 64
Next
End Sub
Code
On Mon, Mar 19, 2012 at 12:15 PM, Maries talk2mar...@gmail.com wrote:
Hi,
Try it,
Hello Expert
in the attached file, when i select from the drop down list in cell B8, i
get a value error in column F (colored yellow). i want a formula that will
give me the correct value in column F when the value in column D under
periodic withdrawals is blank.
kindly note however that if i
On Mar 15, 3:48 pm, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Hi
I am facing the below error while running below macro. Please can you advise
on the same.
Thank you for your help !
Sub Convert_HTML_to_Excel()
Application.ScreenUpdating = False
Dim fldpth As String
can u write what error you got.
or you can also send screen-shot of error
Divaker
On Mon, Mar 19, 2012 at 3:30 PM, SHREE chidurala.sh...@gmail.com wrote:
On Mar 15, 3:48 pm, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Hi
I am facing the below error while running below
Hi Hilary,
Enter the below formula in F13 and drag it down
=IF(OR(A13=,D13=),,E13-D13))
HTH,
Waheed
On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey resp...@gmail.com wrote:
Hello Expert
in the attached file, when i select from the drop down list in cell B8, i
get a value error in column F
Hi Noorain,
Congrats
On Mar 15, 3:49 am, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He has been
Thanks both for your help,
On Mon, Mar 19, 2012 at 10:24 AM, Shaik Waheed waheedb...@gmail.com wrote:
Hi Hilary,
Enter the below formula in F13 and drag it down
=IF(OR(A13=,D13=),,E13-D13))
HTH,
Waheed
On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey resp...@gmail.com wrote:
Hello
Hi Expert,
Can anyone give me a hint to findout last and second last copied item.
Divaker
--
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
Hello Pandey,
If you are using excel 2007 or later , you can use Clipboard CTRL+C
pressed twice.
On Monday, March 19, 2012 1:53:08 PM UTC+2, Divaker Pandey wrote:
Hi Expert,
Can anyone give me a hint to findout last and second last copied item.
Divaker
--
FORUM RULES (986+ members
THANKS CHIEF
On Mon, Mar 19, 2012 at 12:03 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi Hilary,
You can also use
=IFERROR(IF(A13=,,E13-D13),)
or
=IF(ISERROR(IF($A14=,,$E14-$D14)), ,IF($A14=,,$E14-$D14))
See attached sheet.
On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey
Hi Noorain,
Congratulations
Thanks for helping us always.
Regards,
Kaushik
--
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
Divaker,
I am facing the below error while running macro. Please can you advise on the
same.
[cid:685132014@19032012-07C1]
Regards,
Shrinivas
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Divaker Pandey
Sent:
If xl2003,
toolsoptionssecurity remove
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Chidurala, Shrinivas
Sent: Monday, March 19, 2012 9:21 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Error while running macro
Divaker,
I am facing
One possible formula to use vlookup if there is a match. See att
=IF(ISNA((MATCH($J4,'Week One'!$A:$A,0))),0,VLOOKUP($J4,'Week
One'!$A$2:$C$118,2,0))+IF(ISNA((MATCH($J4,'Week
Two'!$A:$A,0))),0,VLOOKUP($J4,'Week Two'!$A$2:$C$118,2,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
Don,
Thank you for such a quick response. I like the formula and will analyze
it until I understand every part of it. The problem with this approach is
the projects are actually names and therefore a clean list would have to be
manually sorted to eliminate duplicates and then pasted into Column
Dear John,
See attached sheet..hope it help to you.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Mar 19, 2012 at 8:30 PM, John A. Smith
Hi Don,
Still i am facing the same problem.
Regds
Shrinivas
On Mar 19, 7:35 pm, dguillett1 dguille...@gmail.com wrote:
If xl2003,
toolsoptionssecurity remove
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Chidurala, Shrinivas
Sent: Monday, March 19,
Hi Noorain Sir,
If I write xlExcel7 instead of 51, the macro is running but the some part of
disclaimer in the report are missing in output and if I ok in below screen shot
then it is running properly.
ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51
Please can you advise on the same.
Hi Maries,
Nice Collections...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Sun, Mar 18, 2012 at 1:53 PM, Maries talk2mar...@gmail.com wrote:
Hi,
*Check below Weblinks.*
*MVP's* *Web Link* Alan Beban
Hi Karan,
Try Advanced filter and select Unique records..And you can Copy and paste
it in New Column..
[image: Inline image 1]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh
Hi Divakar,
Copy data twice You will get Clipboard..You Can see Last Second Copied Data.
[image: Inline image 1]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 5:23 PM, Divaker Pandey divake...@gmail.com
Hi Amit,
Try Transpose Option on Paste special..if Helps..
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Hi,
** **
Is there any formula to
See the attached File
=INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Mar/Mon/2012 06:03
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ copy paste in
=CODE(UPPER(A1))-64
A1 contains your letter
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Mar/Mon/2012 01:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Replace letters with numbers
Hi,
Try it,
=CODE(UPPER(A1))-64
A1 contains your letter
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Mar/Mon/2012 01:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Replace letters with numbers
Hi,
Try it,
Hi Pankaj
PFA,
Try :
=RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2A$2:A$9))
HTH
Mahesh
On Mon, Mar 19, 2012 at 3:27 AM, dguillett1 dguille...@gmail.com wrote:
Shorter. Also enter using CSE (ctrl+shift+enter)
=COUNTIF($F$2:$F$9,F2)+**SUM(IF(F2=$F$2:F2,1,0))
Don Guillett
Microsoft
Don,
That was what I was hoping for, but when I click the button, it dulpicates
some of the entries. Is it me or the macro?
Thank you.
John
On Mon, Mar 19, 2012 at 1:30 PM, dguillett1 dguille...@gmail.com wrote:
See attached which works for as many sheets as you may have after the
Hi Divaker,
If you mean the last two things copied within Excel, and you want to
identify them from VBA,
Take a look at http://www.mrexcel.com/forum/showthread.php?t=167292
Keep in mind that the commandbar containing the Office Clipboard's name
varies by Excel version. Here's how I think it
I think I misunderstood your need. I thought you wanted the name to stay
with the data, allowing you to insert columns and have the name still refer
to the same data. This method does that.
If you want the name to stick to the column/range reference without regard
to inserted columns (always
I have a macro that will hide unused rows in a spreadsheet, print the
active sheet, then unhide the rows.
Spreadsheet is from cell A1 to P175. Base info is recorded in various
cells on rows 1 to 4.
Cells 5 to 16 display output.
The main Data input starts in cell A18 to G 167. A18 is a
Hi Howard,
No worries :) Ask as many questions as needed. Best to send your replies
to the list though, so you get the benefit of other replies (if only because
I may not have time to reply myself). This also allows other VBA learners
can benefit from the conversation.
A defined name
Hi Mel,
No need to select any ranges. You are not printing based on the selection,
so it's irrelevant.
Here are a few things you could try:
1. Hide the rows without looping. (Beware though that any method that
hides rows will force those rows and their dependencies to be recalculated
in
Hi,
PFA.
=OFFSET($A$1,ROW($A$20)-ROW(),0)
Regards,
MARIES.
On Mon, Mar 19, 2012 at 8:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
See the attached File
** **
=INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1)
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com
41 matches
Mail list logo