Hi Excel Savvy
Help me on making a scatter plot (attached file contain raw data).
It may look like am not asking too much or not reading (but not true i have
tried to read the *F1 Help *but it was not useful)
Thanks
--
Dave, these are not sample data thus why am want to remove them.
But thanks for being curious.
One Love as a group.
On Thu, Feb 18, 2010 at 12:09 PM, Dave Bonallack
wrote:
> Hi Jen,
> Sample data has no duplicates. Am I missing something?
> Also, is the data allowed to be sorted?
> Regards - Dav
Sorry Ashish, I am unable to open your file and also find attached list of file
names for your reference.
Regards,
Shrinivas
Citi® Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339
Email - shrinivas.chidur...@citi
hi
check the attachment
are you looking for this
also just to avoid writing that 111 222 manually
can u tell us how account no are related top file names
can u provide few examples of file names
and is it fixed
that sbi is having 111
or hsbc 222
On Thu, Feb 18, 2010 at 4:11 PM, Chidurala, Sh
hi
check the attachment
Sub Macro1()
Dim I As Long
Dim J As Integer
Dim N, Z As Long
Dim x As String
Worksheets(1).Activate
Range("a1").Select
Selection.End(xlToRight).Select
Dim temp As String
temp = ActiveCell.Address
x = Mid(temp, 2, (InStr(2, temp, "$") - 2))
For J = 2 To Wo
Ayush Jain has sent you a link to a blog:
Dear members, An ASCII converter function for quick reference. Best
regards, Ayush Jain
Blog: VBA Macros Code examples
Post: ASCII code converter : Column Number to Alphabetical reference
Link:
http://quickvba.blogspot.com/2010/02/ascii-code-converter-col
Dear all,
Please provide any solution to below mention mail.
Regards,
Shrinivas
Citi® Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339
Email - shrinivas.chidur...@citi.com
-Original Message-
From: excel
Hi Jen,
Sample data has no duplicates. Am I missing something?
Also, is the data allowed to be sorted?
Regards - Dave.
Date: Wed, 17 Feb 2010 23:12:00 +0300
Subject: $$Excel-Macros$$ Help: How to remove duplicate rows
From: janetdicks...@gmail.com
To: excel-macros@googlegroups.com
Hello Fans..
Dear Gurus,
Need ur hepl.
I have 07 sheet in a wookbook with same header row.
Now i want to copy all the data in a single xlxs execpt the header row.
--
With Love,
Mahesh Bisht
--
--
Some important links for exce
