Copy Unique Entries To Another Column

May 3, 2007

From column A,(lets say cell 10 onwards) I need to copy all the unique entries into column B (cell 10 onwards). However, I dont know what length column A will be. What would be the best way in VBA/Excel to do so ?

View 4 Replies


ADVERTISEMENT

Identifying Unique Entries Based On Unique Entries In Another Column?

May 29, 2014

I have a list of data and I want to identify the unique entries for both columns but the second column has to unique to the unique values in the first column.

Example List

Fruit
Color
Apple

[Code]....

View 9 Replies View Related

Unique Entries In Each Column Of 620 Columns?

Jun 18, 2012

I have 620 columns of data with each column consisting of 17 rows. I need to be able to count the number of unique entries in each column. I recorded a macro that would do what I wanted, but it just used absolute references for each column, which would make the process rather tedious. Is there a way to make the macro less restrictive?

Sub Macro1()
Columns("B:B").Select
ActiveSheet.Range("$B$1:$B$17").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub

View 1 Replies View Related

Filtering For Unique Entries Based On One Column

May 1, 2009

This may be a basic question but I haven't been able to find the solution:

I'm using Excel 2003. I have a list with repetitive entries in one column and unique entries in the other columns. Example

0001 a
0001 b
0002 c
0002 d
0003 e
0003 f

I need to filter the list so that only unique entries in the first column show up, but I need the rest of the information to carry with it. Example:

0001 a
0002 c
0003 f

I can't use the Avanced Filter > Unique Entries Only function because the information in the adjoining columns is not unique.

View 6 Replies View Related

Check Column For Unique Entries And Add One Further Condition

Sep 17, 2009

I need to count all unique entries in column A (list of names) (this bit I can do!)...however:

Column B gives each name a value of A or B, I need to count all unique names with an A and all unique entries with a B.

eg

Matt A
Matt A
Matt A
Bob A
Tom B
Tom B

This would give a count of 2 for A's and 1 for B's.

View 14 Replies View Related

Calculating The Number Of Unique Entries In A Column

Jul 17, 2009

how to calculate the number of unique entries in a column? I have a column of email addresses and i would like to know how many of them are unique.

View 9 Replies View Related

Count Unique Entries In One Column That Meet Conditions

Jan 17, 2010

I tried to ask this question yesterday -- but it was a follow-up question stuck at the bottom of a thread. So, with your indulgence, here is a simpler version of the question, complete with an attached spreadsheet, if you wish to use it. I also closed the other thread by marking it "Solved", since it answered my initial question.]

The situation:

I have two columns of data. The data is not in alphabetical order, and every column includes duplicate values.

namegender
jones m
martinf
smithf
collinsf
wilsonm
jones m
martinf
hughesm
wilsonm
martinm
smithf
west f
jones m
west f
martinm


The challenge:

In one cell, count the number of unique names that appear in the name column 3 or more times... with the additional condition that each unique name (which appears at least 3 times) must include at least one one woman!

The correct result: ...

View 6 Replies View Related

Advance Filter Check Unique Column Entries

Jul 7, 2009

How do you remove entries from a column such that only unique entires are left?

Say the spreadsheet contains only a single column:

david
kris
tony
hayley
kristy
john
david
test
hello
david

I tried an "advanced filter" with "unique records only" checked. It gets rid of one david, but not 2 (there are originally 3 of them, and we want to leave 1)

This is the result.
david
kris
tony
hayley
kristy
john
david
test
hello

View 9 Replies View Related

Unique List Would Grab All Unique Entries

Jul 30, 2009

I have a data table that repeats as follows:

CITI
SCB
SCB
SCB
SCB
SCB
SCB
SCB
RBC
RBC
RBC
RBC

From the data above I need to make a new unqie list that would grab all unique entries.
CITI
SCB
RBC

I am trying to use the following guide:

http://blogs.techrepublic.com.com/howdoi/?p=111

Get stuck on "Listing A:

View 9 Replies View Related

Copy A1 And Paste It To All Entries In Column B

Apr 2, 2008

Range("A1").Select
Selection.Copy
Range("B2:B58").Select
ActiveSheet.Paste
Selection.Font.Bold = False
End Sub

in the section of this Macro, how do I simply copy A1 and paste it to all entries in column B. My range will vary (it won't always be B2:B58).

So,
Range("B2:B58").Select

View 9 Replies View Related

Copy Rows Into Sheet According To Entries In Column

Feb 17, 2009

I copy rows of data according the Workgroup entries in Column C and paste them in to the relevant team sheet so that it is separated and printed off. Currently I am doing this manually, as the report length is variable and can be a few hundred rows or sometimes a few thousand which takes up some time. I know I can use the auto filter option, but as I currently use a macro to format this report I was hoping to include it whilst it is being formatted. Also would like to apply all borders to report so its easier to read when printed and a comments column at the end, but this can be done later.

There are teams and 27 workgroups to separate into each team, I have to do this everyday and was hoping to save some time here. I've attached a sample work book as an example.

View 14 Replies View Related

Duplicates Finding Entries In Column A Which Match Any Of Column C Entries

May 7, 2014

What I need to do is sort certain entries in longer list (column A, it is in .csv format and needs to be in it so coordinates and names and ID, all sorted with commas) and I have another list (column C) which is shorter list of certain IDs. I googled and tried and got some results for the basic structure but the fuction seems to fail. It doesn't matter how I get that third list done, but there is only one criteria: since the list in column A is really long and those entries need to keep the .csv formatting, the function should copy that info what is in the matching cells.

Let me try to put it simple: .csv cells from column A that have matching ID from column C should be copied to column B (or N).

the function I'm working with right now is

=IF(ISERROR(FIND($C:$C; A1))=TRUE;"0";A1)

View 13 Replies View Related

Sum Unique Entries

Apr 23, 2007

I have attached a sample workbook to try and explain what I'm after.

Basically I want to sum the amount of occasions a person has had checks and each occasion could have 1,2 or 3 individual checks.

View 9 Replies View Related

Counting Unique Entries ...

Nov 2, 2009

Couting Unique Entries

I've included a sample worksheet ...

View 10 Replies View Related

Extract Unique Entries

Oct 4, 2006

I have a list with many names, several of them appearing more than once. I would like to extract the unique entries an then make the list of them.

I can do that using the filter. But can I do it with formulas ? (In order to, whaterever change is made to the first list, get the extracted one immediately updated).

View 9 Replies View Related

Delete Unique Entries

Jun 12, 2008

I was wondering if there might be a better way to write this macro. What it does is clears unique items from a Range( leaves duplicates ) I've looked all over the net I can find all kinds of function and subs to remove duplicates but haven't been able to find anything that just removes single entries. I"ll bet there's a more elegant way to write this maybe using a Collection or a Dictionary.

Sub Dummy()
Dim MP1_Rnge As Range
Set MP1_Rnge = Range("A1:A100")
For Each Cell In MP1_Rnge
If Not IsEmpty(Cell) Then
If Cell.Row = 1 Then..........

View 9 Replies View Related

Unique Entries & List

Dec 23, 2008

I have the below table of data, in Column A there is a list of entries and there may be duplicates in them, what I want to do in column B is be able to list all the unique entries in there and basically remove any duplicates.

AB1DETAILED LISTUNIQUE LIST2Holden 3Ford 4BMW 5Mercedes 6Ford 7Ford 8Audi 9BMW 10Holden 11Ferarri 12Holden 13BMW 14Toyota 15Toyota

View 9 Replies View Related

Identifying Unique Entries

Mar 24, 2009

I have a worksheet, where in C3:C100 (or even higher) i will have text strings. A lot of these will be repeated, and i want to pick out just one instance of each text string and display it in E3:E10 (or higher).

So, for example, if i had the following values in column C:One
Two
Two
One
One
Three
Seven
Two
Four
Seven
One
Three

I would want the following values in column E:One
Two
Three
Seven
Four

View 9 Replies View Related

Find Sum Of Unique Entries

Dec 29, 2009

I am using excel 2007.

I am trying to find the sum of unique entries in a table such as below for each respective date.

DateClient1/01/2010ABN1/01/2010ABN2/01/2010BNP2/01/2010HSBC3/01/2010ABN4/01/2010BNP4/01/2010HSBC4/01/2010ABN5/01/2010BHP

The results should appear as

Count Unique1/01/201012/01/201023/01/201014/01/201035/01/20101

What formula would I use to calculate this unique count?

View 9 Replies View Related

Filtering Unique Entries

Jul 20, 2006

I have this 2 columns, A(region) and B(location), and I need a macro to filter the unique entries in Columns A and return both the unique values in A and their corresponding values in B. I've attached a file on it with sheet 1 having the data to be worked on and sheet 2 being the output that I require.

View 7 Replies View Related

Choosing Unique Entries

Oct 7, 2006

I'm trying to write an Excel program to calculate golf handicaps. In column A, I have 20 unique dates. In column B, I have corresponding 20 scores. In column C, I'm trying to create a corresponding notational mark, "*", indicating the 10 lowest scores that are also the oldest. However, I'm running into problems as I may have duplicate scores with different dates, i.e. 3/22/06 will have a score of 85 and will be the 10th lowest score, but 4/1/06 also has a score of 85.

View 9 Replies View Related

Count By Unique Entries

Feb 24, 2007

I am hoping this can be done with formulae. Starting at C7 and continuing down the C column there is a list of names which could potentially run from C7 to C5000. This list of names will contain duplicates. For each name there is a corresponding 'reason' in the F column which will contain the word 'Truancy' or 'Late'.

I need a formula that can count the number of UNIQUE names in the C column which correspond to the word 'Truancy' or 'Late' in the E column.

An example,

[Name].....................[Reason]
C7 ...........................E7
John Potts.................Truancy 2
Matt Jones................Truancy 10
John Potts.................Truancy 4
Matt Jones ...............Late AM
Pete Burns................Late PM
Pete Burns ...............Late Both
Steve Lopez..............Truancy 6

Count of unique names with the word Truancy in the corresponding E column = 3 [John Potts has 2 instances of the word truancy in column E but this is only counted once]

Count of unique name with the Word Late in the corresponding E column = 2 [Pete Burns has 2 instances of the word late in the E column but this is only counted once].

I have also included a sample workbook.

View 9 Replies View Related

Unique Entries Formula From 2 Lists?

Aug 12, 2014

I have two lists and I would like a formula which only returns unique values - similar to an advanced formula. Is this possible?

In the attached example my data is in columns C and D and I would like a formula in column E if possible. I need it to ignore the capitals. E.g. BLACKBURN and Blackburn appears in each list but I would only want one instance pulled through in column E.

Currently in column E I have the desired result.

View 5 Replies View Related

Counting Unique Entries From 3 Workbooks

Sep 23, 2009

I need to count the number of unique names (column A) on 3 separate worksheets. Each worksheet represents a facility that people visit. It is possible that the same person will visit all three facilities. If this is the case I want to only count them once, even though they may have numerous entries on each.

I need to get the same result as if I was to copy and paste all of the names from three spreadsheets on to one (which isnt an option) and then count unique names. To do this on one sheet I have been using =sumproduct((A1:A100<>"")/countif(A1:a100,A1:A100))

View 2 Replies View Related

Count Unique Entries With Criteria?

Dec 3, 2012

Count unique entries in a column according to two specified criteria.Specifically, I am trying to count the number of days in a month a supplier has a visited.Below is an example taken from the excel:

COLUMN A COLUMN B
Date Supplier
01-ago-12 Mr X
01-ago-12 Mr X
01-ago-12 Mr X

I want a formula that allows me to see how different dates Mr X has visited in each month. So in August he has visited 8 times BUT only on 5 different dates.

In the case of Mr Y I want the formula to give the answer 5 (even though he has visited 6 times in total, he has visited on only 5 different dates).

In the case of Mr X in September, the answer to the formula would be 2, since has visited on 2 different dates in September.

View 9 Replies View Related

Copying Unique Entries To New Spreadsheet

Dec 8, 2008

I'm trying to write a macro to use as an auto-update feature for a spreadsheet.

I currently use Data validation on an input cell to allow the user to select from a list of product types.

I'd like the update to affect this list, so new product types are always available to the user.

However, the list of product types is in another spreadsheet and contains numerous repetitions.

I've managed to get the following code together based on what I've used before and what I've found searching so far, but it seems to have a bug in it as it wont always work. I also need the original copying of the list to be done to either the new spreadsheet of a different page in the original spreadsheet, but every time I try this it causes an object error.

PHP
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 05/12/2008 by Information Technology
'
    Workbooks.Open Filename:= _
        "T:SSTCCDEngineeringBackthin_dataPhotolithMASK_DETAILS.xls"
   Sheets("Mask List").Range("f4:f2000").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Range("a1:a3"), CopyToRange:=Range("E1:E2000"), Unique:= _
        True
    Selection.Sort Key1:=Range("E1:e2000"), Order1:=xlAscending, Header:=xlNo, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
        Columns("E:E").Select
        Selection.Copy
      Windows("MASK_DETAILS.xls").Activate
    ActiveWindow.Close
    Windows("Dry_etcher_log_B.xls").Activate
    Sheets("Calc Sheet").Select
    Columns("M:M").Select
    ActiveSheet.Paste
 End Sub 

View 10 Replies View Related

Formula To Return Unique Entries Only

Nov 6, 2008

I am seeking to pull names from a list on one worksheet in to particular cells on another worksheet using each name only once. I need a function or series of them that can accomplish this. I have been trying to figure this out for a couple of months with no luck as I always get into some form of circular reference....

View 14 Replies View Related

Count Unique Entries In A Range

Sep 5, 2007

count unique entries in the Range A1:A10

i have data which repeats but i ant to count only unique entries?

View 9 Replies View Related

Remove ALL Non-Unique Entries From List

Mar 6, 2008

I have a list in Row A that has duplicates. I want to be able to delete both entries (itself and the duplicate). When done I want the list to display only be entries that are unique or better said any entries that never had a duplicate.

View 8 Replies View Related

Count/Sum Unique Values/Entries

May 9, 2008

Can DCOUNTA be used to only count unique values?

If the above is not possible how would I do the following:

Criteria

Column H = text1 AND Column B date is between date1 & date2

Count unique values in column C

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved