Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Generate a List of Text in Excel
Name: Betty Mc Kenzie Date: December 14, 2007 at 06:19:13 Pacific OS: Win XP CPU/Ram: 2.0 Gig Product: Dell
Comment:
On worksheet 1 - I have a 2 columns and several rows of data. Column A has product names that are repeated. On worksheet 2 I want Cell A3 to show a list of the product names from worksheet 1 - but I want only one occurrence of the product name. Example:
A (Worksheet 1) Coca Cola Sprite Coca Cola Ginger Sprite
Name: Bryco Date: December 15, 2007 at 04:57:00 Pacific
Reply:
Yes with a little effort.
Select your data in Column A. Go to: Data, Filter, Advanced Filter. Choose: Copy to another location Choose: Unique records only. Select a Copy To location somewhere onto Sheet1 Click Ok Then copy that data and paste it onto Sheet2 in A3 as desired.
This function will not allow copying to a location outside of the working sheet.
HTH Bryan
P.S. I am using Excel 97 and perhaps your version may allow copying to another sheet directly. At this moment I don't know if MS changed that ability or not.
0
Response Number 2
Name: DerbyDad03 Date: December 15, 2007 at 13:45:52 Pacific
Reply:
Or run this code:
Sub ViewSingles() With Sheets(1) LastRow = .Cells(Rows.Count, "A").End(xlUp).Row .Range("A1:A" & LastRow).Copy Destination:=Sheets(2).[A3] End With
With Sheets(2) LastRow = .Cells(Rows.Count, "A").End(xlUp).Row For Rw = LastRow To 4 Step -1 If .Cells(Rw, "A") = .Cells(Rw, "A").Offset(-1, 0) Then .Cells(Rw, "A").Offset(-1, 0).EntireRow.Delete Next End With End Sub
0
Response Number 3
Name: Betty Mc Kenzie Date: December 17, 2007 at 08:01:34 Pacific
Summary: I have imported a list of contacts into excel, I have about 550 email addresses. They are just text though, I'd like the to all be clickable email addresses in the email column. I know there's a way ...
Summary: I'm trying to produce a summary of the words in a specific document, with a list of each word and how often they appear. Is there such a function or add-on for Microsoft Word? Or perhaps another text ...
Summary: If you can sort your list of dates in descending order, which is required by the MATCH function if you want to find a value that is greater than the lookup_value, this should work: Assume your descend...
0 
