Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Isolate Unique Date in 2 Columns

 
   Mac (Home) -> Mac Excel RSS
Next:  Close File from VBA  
Author Message
olson.jason

External


Since: Feb 08, 2006
Posts: 1



(Msg. 1) Posted: Wed Feb 08, 2006 6:11 am
Post subject: Isolate Unique Date in 2 Columns
Archived from groups: microsoft>public>mac>office>excel (more info?)

I have 2 columns of names, 1 master list (A), 2nd column (B) contains
names that need to have any that are duplicate to column a be removed.
I need to keep the new names in B isolated so I can add them to an
external list on our server before adding them to the master (A) Is
there a macro that is able to do this? And if so, how do I run the
macro? I've used Excel very little so I am fairly unfamiliar with using
macros (let alone Excel!).

Thanks,
Midnight
Back to top
Login to vote
JE McGimpsey

External


Since: Jul 13, 2005
Posts: 597



(Msg. 2) Posted: Thu Feb 09, 2006 5:02 pm
Post subject: Re: Isolate Unique Date in 2 Columns [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <1139407863.433265.225930.TakeThisOut@g43g2000cwa.googlegroups.com>,
olson.jason.TakeThisOut@gmail.com wrote:

> I have 2 columns of names, 1 master list (A), 2nd column (B) contains
> names that need to have any that are duplicate to column a be removed.
> I need to keep the new names in B isolated so I can add them to an
> external list on our server before adding them to the master (A) Is
> there a macro that is able to do this? And if so, how do I run the
> macro? I've used Excel very little so I am fairly unfamiliar with using
> macros (let alone Excel!).

I'd recommend this page to start:

http://cpearson.com/excel/duplicat.htm
Back to top
Login to vote
Display posts from previous:   
Related Topics:
how to delete rows and columns not used - When I scroll down, or hit END, I want the sheet to stop at the last row and when I scroll to the right, to stop at the last column. I could do this for Excel Windows but not sure how to in Mac. It was a combo of highlighting the document and using ctr...

Deleting rows and columns - I just upgraded from Office 98 to 2004, and in Excel, it appears you can no longer delete rows and columns with <Apple>k. I found, by accident, that <CTRL>k does the same. But is there a way to get it to show up in the menu, as a reminder? Ed

Tab delimited text to columns? - I have a text file with <TAB>s in between sections of the text that I would like put into different Excel columns. When I open the text file in Excel it simply places all text into arbritrary columns. How can I get it to place it into columns base...

Printing shaded columns w/angled headers? - Hi there-- I have several worksheets set up with columns color-coded, and the header rows set to a text angle of 45°. On-screen, they look terrific--the color stripes angle nicely with the text at the top of each column. But when I print the sheets,..

How to hide the ABCDEF... of columns and 123456... of rows - Hi Folks! When looking at an Excel Worksheet, the columns are labeled across the top alphabetically (A-Z and then AA, AB, AC, AD, etc.) and the rows are labeled down the side numerically. Can anyone tell me how to hide the letters and the numbers? ..
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact