Thank you so much
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ravinder negi
Sent: 23 November 2012 06:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ REmove duplicate entries
You can use trim function of excel like =trim(cell referen
Dear Sir/Madam,
Thank you so much but in few entries there is a space so it doesn’t show as
duplicate entry
Regards
Manjunath
From: Orlando José Mézquita Fabián [mailto:orlando.mezqu...@gmail.com]
Sent: 23 November 2012 02:27
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject:
You can use trim function of excel like =trim(cell reference), and it will
remove space from the cell value and then use function remove duplicate which
is available in data->remove Duplicates.
--- On Thu, 11/22/12, Manjunath Narayanappa
wrote:
From: Manjunath Narayanappa
Subject: $$Excel-Ma
did you try a local path instead of a server for strNowPath ?
On Friday, November 23, 2012 2:23:15 AM UTC, Teow wrote:
>
> any idea?
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
Hi Suds,
Can you Please share workbook with us.
Ragards
Prince
On Friday, November 23, 2012 5:05:34 AM UTC+5:30, Suds12345 wrote:
>
> Capture client data from large master client worksheet and place
> individual client data in separate worksheets.
>
> The script below accomplishes what I want
Hi Ganesh
Merge1.txt will include 1.txt, 2.txt, 3.txt
Merge4.txt will include 5.6.7.8.txt files
Merge9.txt will include anything from 10.txt file to next Merge.txt ? Plz
confirm
The data in Merge.txt file will be like the content of 3.txt comes after
the content 2.txt and so on?
Pascal
--
Jo
Hi Amresh,
Such tools for individual or small companies can be done using Excel and
Word mail merge ...
Regards
Pascal
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Hel
Go to the Data Tab and on the 'Data Tools' group select remove duplicates.
This will work for Excel 2007+
On Thursday, November 22, 2012 10:19:18 AM UTC-4, Manjunath Narayanappa
wrote:
>
> Dear Team,
>
>
>
> In the above attached Spreadsheet, I have more than 3777 row in which
> Column C has
any idea?
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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
quick attention or may not b
Capture client data from large master client worksheet and place individual
client data in separate worksheets.
The script below accomplishes what I want up to the eleventh row of
worksheet #1 in an excel file.
It captures the header row and the 11 rows of data for the 1st client .
Opens ,
Reply by be09.
1/ Method 1 (will take 5 minutes): To find the duplicate numbers:
In D3 you use the formula:
=IF(COUNTIF(C3:C37772,C3)>1,"Duplicate"," ")
Select cell D3 and Fill down to the final data. Duplication of any
cell will display text Duplicate, you used Autofillter select
Duplicate and
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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
quick attention or may not be answere
HI Manjunath ,
Public Sub RemoveDuplicate()
Dim varArrData As Variant
Dim lngRow As Long
Dim dicData As Dictionary
Dim strKey As String
Set dicData = New Dictionary
dicData.CompareMode = TextCompare
With ThisWorkbook.Worksheets("Sheet1
Hi Prince,
>From all the column…
Thanks
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 22 November 2012 16:27
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: REmove duplicate entries
Hi Manjunath,
Do you want to remove duplicates from C column only or fro
Hi Manjunath,
Do you want to remove duplicates from C column only or from all columns.
Regards
Prince
On Thursday, November 22, 2012 7:49:18 PM UTC+5:30, Manjunath Narayanappa
wrote:
>
> Dear Team,
>
>
>
> In the above attached Spreadsheet, I have more than 3777 row in which
> Column C has
Dear friends,
I want some method, macro or formula with the help of that i am able to
extract the information of an autocad file in a excel sheet.
For e.g. I have an autocad drawing sheet which is having two figure one is
rectangle and another one is circle, name of both the figure is A and B
resp
Welcome aboard!!
Cheerz
Sent on my BlackBerry® from Vodafone
-Original Message-
From: James Evans
Sender: excel-macros@googlegroups.com
Date: Thu, 22 Nov 2012 04:02:58
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Introduce Yourself !!
Hello to all,
My nam
Welcome Jim :)
Regards
Prince
On Thursday, November 22, 2012 5:32:58 PM UTC+5:30, James Evans wrote:
>
> Hello to all,
>
> My name is James but, you can call me Jim. I work as a Technical Writer in
> the Accounting Section of U.S. Postal. In addition to writing, I work on
> various teams that i
Hello to all,
My name is James but, you can call me Jim. I work as a Technical Writer in
the Accounting Section of U.S. Postal. In addition to writing, I work on
various teams that involve the use of excel. I'm scheduled to retire in 4
years. I then plan to work as a contractor and devote more
Hi Asa,
Is there any alternative for OWC in excel to generate graph on userform
On Mon, Nov 19, 2012 at 10:24 AM, Amol Jadhav wrote:
> Thanks a lot Asa.
>
> Regards,
> Amol Jadhav
>
> On Sat, Nov 10, 2012 at 4:51 AM, Asa Rossoff wrote:
>
>> Hi Amol,
>>
>> I haven't use the Office
Dear Yogi,
first u have to set the page,custom setting then as u go to another
workbook in the page setup u can user the last custom setting which u had
set before.
Regards,
Gawli Anil
On Thu, Nov 22, 2012 at 12:35 PM, yogiyogi123 wrote:
> Hi all..
> i have a doubt in excel qt
> G
21 matches
Mail list logo
