Create List Of Duplicates Based On Occurrences In Another List

May 27, 2014

Eng list.xlsx

The attached file (a copy of my main one) has a list of our engineers, and what stock they carry. The stock parts are the 64, 65, 66... numbers.

I need to create a list from this (as underneath the main table), for all instances where there is a 'Y' in the columns next to each engineer. So if an engineer has 3x pieces of stock, they need to appear in the list 3x times. If they have 1x piece of stock, they appear in the list once.

View 8 Replies


ADVERTISEMENT

Create Unique List From List With Duplicates

Nov 28, 2007

I have a list of data which looks like this

Column B

Name
---------
Jones, Bob
Jones, Bob
Jones, Bob
Smith, Mike
Smith, Mike
Smith, Mike
Calai, Dave
Calai, Dave
Calai, Dave
Etc...

What I want to do is take the entire list and create a distinct list that I can use in a named range then use a validation list to have a drop down within a different tab.

View 9 Replies View Related

Create New List Based On Data From Another Dynamic List

Jan 4, 2013

I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.

list-test.xlsx‎

View 6 Replies View Related

Create A List From A Column And Eliminate Duplicates

Feb 22, 2010

I have a list of names "H3:H66". I want to create a list starting with "L3" from column H that eliminates any duplicate name from the first list.

View 7 Replies View Related

Create Unique List From Column With Duplicates

Feb 27, 2008

I want to end up with a list of unique items (nothing repeated) from a variable length list starting in cell B5. That unique list is then placed in cell D3.

I am using the code below (found on Ozgrid) which almost works. But it seems to be dependent on whats in column A (which I wish to ignore) for it to work.

How can I modify the code so that the results are based on column B only?

Dim Rng As Range
Dim fRng As Range
Dim lRow As Long
Dim Dest As Range

lRow = Range("B" & Rows.Count).End(xlUp).Row
Set Rng = Range("A5:B" & lRow)
Set Dest = [D3]

With Rng
. AutoFilter Field:=1, Criteria1:="1*"
Set fRng = .Offset(1, 1).Resize(.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible)
With fRng
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Dest, Unique:=True

End With
End With

View 7 Replies View Related

Excel 2013 :: How To Create A List In One Cell From Array While Removing Duplicates

Jul 23, 2014

------ A ------------------- B
John123@gmail.com--------Blue
Bill323@gmail.com ---------Red
Sue223@gmail.com -------Green
Sue223@gmail.com -------Yellow
Bill323@gmail.com ---------Red
Bill323@gmail.com --------Yellow
John123@gmail.com ------Yellow
Sue223@gmail.com --------Blue

- C --------------- D ---
John ------------Blue, Yellow
Bill --------------Red, Yellow
Sue------------Green, Yellow, Blue

I am using Excel 2013 on Windows 7. In the above example columns A & B is the given list to process, and Columns C & D contain the result I am trying to achieve. The major part of this that I am having trouble on combining, separating them with commas in another cell, and ignoring a duplicate value. You can see bill has two red values, but I only need it displayed once in column D.

View 4 Replies View Related

Make Unique List From List Without Duplicates But Hold Cell And Pull Corresponding Dates

Apr 18, 2013

I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.

For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).

I am also going to upload a data sheet, and an expected results sheet.

unique list.xlsx

View 1 Replies View Related

Duplicates - Delete Every Lead On List A Whose Email Address Is Also In List B?

Jan 9, 2014

I am working on an email marketing project and i have a small problem. I have two different email list. One (List A) is a large list of potential leads. The other (List B) is a list of leads we are not supposed to market to. I need to delete every lead on List A whose email address is also in List B, so that we do not send unwanted emails to our clients.

The best way i have to do this so far is to go through line by line, which is very impractical.

In case it matters here is out list format. Each list has 10,000 + leads. Each lead occupies a row. The row stretches across 13 columns and each column holds a different variable about the lead (names, state, email address).

View 2 Replies View Related

Removing Duplicates From List Based On Latest Date?

Jan 6, 2014

I am working on a large data file (leasing file), that has many duplicates. The names on the file are duplicated due to the various variable costs associated with leasing. I need to remove the duplicates names based on the latest contract end date.

View 4 Replies View Related

Create List Based On Tables

Sep 30, 2007

ive got 1 sheet,with 2 printable pages in it. 1 being the summery page and 1 being the inventory page.

what i would like to be able to do is.
on the summery bit ive got a code in A22 and a number in G22
to save me time i need to create a list in the inventory bit starting at A62

im hoping it will look somthing like this

A62 = what ever the code is ( JR269 ) in A22
A63 = same code and so on until i have 26 in a list, 26 being G22

View 9 Replies View Related

Create New List Based On Dates

Mar 17, 2008

I am trying to create a list which will summarise information from a dataset depending on two input cells in which dates are inputted by the user. I would really appreciate it if you could have a look at the file I have attached and give me some idea as to what formulae I should be using!

It is important that the position of the output list remains where it is (as ideally I want to draw graphs using the information summarised in the output list.

If your confused now when you look at the file it should make a bit more sense.

View 7 Replies View Related

Create List Of All Files In Folder And Make List Hyperlinks To File?

May 17, 2013

i have many excel workbooks in a folder i want a macro that will get the names of all the files and make the file names so extracted as a hyperlink to open the files.

View 1 Replies View Related

Relating List Of Random Numbers To A List Of Names To Create Rota

Nov 21, 2013

I'm trying to create a staff rota which will populate a rota randomly when prompted - I have been trying to find some way of connecting the random lists and the staff names, though this has proved difficult (to say the least!). How best to proceed? I'm also fully aware of the possibility that my present design will also double book people (place then on reception and telephone duty simultaneously).

View 3 Replies View Related

Excel 2007 :: Create List Of Barcodes From List Of Numbers On Worksheet?

Feb 25, 2014

Is it posible and how to create a list of barcodes from a list of numbers on the worksheet?

Strokescribe seems to have some ind of solution but the data can't come from the worksheet.

View 8 Replies View Related

Create Unique List From Matrix & List Frequency Of Each Occurrence

May 23, 2009

I've searched the forum and believe this thread to be the closest to what im looking for, but its doesnt completely apply: matrix to list conversion. I have an attachment to support my questions (see attached). I have a matrix of words (strings) that contain repeating and non-repeating contents. The matrix also has spaces which are of no value. Essentially, the VBA needs to ' analyze' this matrix and create a consolidated frequency list (as shown in the file).

The matrices are HUGE and therefore some of the clumsy VBA i am using is turning out to be a bit inefficient. The file also contains formulas and such that I cannot use AutoFilter nor can I use Insert or Delete rows...so the VBA shouldnt use those either.

View 6 Replies View Related

Create A List Of Results Based On Criteria

Sep 21, 2012

Col A has list of order numbers, col D has list of corrisponding order status (open , closed etc etc)

I simply want a formula to display a list of all the 'Open' order numbers in a separate sheet.

Obviously to size of the list will vary depending on how many open orders there are.

View 1 Replies View Related

Create List Based On Multiple Criteria?

Apr 13, 2014

I am trying to formulate a commission form which looks up the name of the sales person and then displays a list of the deal names withing Q1.

View 1 Replies View Related

Create A Drop Down List Based On The Value In A Cell

Oct 14, 2008

I have ranges that are named Math, Reading, Science. I would like to create a drop down list in validation that chooses the range based on a value in a particular cell.

View 4 Replies View Related

How To Create New Workbooks Based On Validation List

Feb 22, 2012

Every two weeks: During Payroll, we have a list of managers and specific employees under that manager.

The managers name is in Column A and they repeat.

Normally we filter that manager, copy and paste the data into a new Workbook, save it, and send the info out to that manager. We do not want other managers to see the information provided to the specific manager.

This is a long tedious process as there are close to 30 managers.

1. Is there a way to run a macro (presumably based on a validation list) to filter, copy the worksheet into a new workbook for each of the 30+ managers?

2. Is there a way to save each with a specific name like "Payroll Feb11 - Manager Name.xlsx"

View 9 Replies View Related

Create Drop Down Boxes Based On List

Jan 29, 2008

My problem is i need to create a drop down box in excell, now i have a list of names,

Name 1
Name 2
Name 3
Name 4..........

I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!

Name 1
Name 2
Name 3
Name 4
Name 5..................

View 2 Replies View Related

Create List Based On Word Chosen

Feb 6, 2008

If a specific word is entered in a cell I want a list to show in another cell. This is better explained in an example. In cell A2 I have a validation list of names, eg. Mary, Mary Birth, John, John Birth,. . .) In cell N2 I have another validation list of places , eg. Ireland, England, Wales, USA, Scotland, . . )
In A2 if a name with Birth is chosen then I only want them to be able to choose from Ireland or England.

View 2 Replies View Related

Create New List Based On Multiple Conditions

Mar 6, 2008

I am trying to filter a range of text and copy only those entries from it that meet selected criteria into a new part of my page. The entries will all look like the following but will have varying numbers before the final Equity/Index part:

IBM US 3 C60 Equity
IBM US 3 P60 Equity
UKX 3 P5000 Index
UKX 3 C5000 Index

I have constructed something using a modification of the find nth word function from this site that allows me to filter based on whether the fourth part (or for the third and fourth choices, third part) shows C or P at the beginning and then based on the value that is written after the letter. However, I have to break down the code a bit further to firstly check whether the final word of the string is Index or Equity to decide which word to check for C/P. I was wondering if anyone knew whether there is possibly a more simple way of running a find within one cell than using the nth word function. Would it possibly be a case of making two subs within a different module and then calling them to look for the specific word number based on what I have in F6 (my original equity/index ticker symbol: for example IBM US Equity or UKX Index)? Attaching code below. I'm sure it doesn't make a lot of difference but in case it helps I am currently running Excel 2007 on a Vista machine but I also use it at work on a Win XP PC with 2003.

----CODE----........................

View 8 Replies View Related

How To Create A List Of Items For Use In A Dropdown List With Data From A Different

Mar 17, 2007

I Attached a sheet for what i'm asking about ,, i sent it before but the sheet showing it more clearly

View 10 Replies View Related

Create Sub-list From Larger List And Find MIN Value In Another Column?

Feb 6, 2014

I am looking for a formula to search two columns.

1) The first column needs to be search to match a text string.

2) If the text string matchs, I need excel to evaluate the number in the second column and find the MIN value of all numbers associated with the text string.

So:

Joe 50
Jim 12
Joe 10
Rob 25
Jim 8
Rob 99

When searching for "Joe", the function would return 10. When searching for "Jim" the function would return 8. For "Rob", it would return "25".

View 4 Replies View Related

Create List Of Unique Entries Based On Several Columns

Jul 27, 2013

[URL] ......

In that file, you can see there is a list of somewhat similar data across 5 columns. Some of the entries are duplicates, some are different by only one character. What I want to be able to do is generate a list of all the unique rows of data, taking into account the data from ALL 5 columns. The list can be on another sheet or simply just further down on the same sheet, that doesn't matter too much.

I could do it if it were just one column of data, but struggling trying to do it with several columns.

View 7 Replies View Related

Automatically Create New Worksheets Based Upon List Of Names

Aug 10, 2014

I have a list of names in column A, and want to automatically create worksheets within this same workbook based on the list.

List of values:
Dairy NI
Dairy SI
Sheep and Beef
Equine
Sports Turf
Water Industry
Horticulture Services
Production Horticulture
Other Agriculture

Therefore, a macro or coding to automatically create 9 spreadsheets named as per this list.... My list is approximately 50+ hence inquiring if there is an easier way!

View 1 Replies View Related

Trying To Create A List From A Database Based On A Letter Placed In 1 Cell

Jul 15, 2009

Its really hard to explain. See the attached.. Basically I have kind of a database of Letters and each letter has several codes associated with it, although each letter is different (a few are the same but that's irrelevant), e.g. letter E means you need to use codes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.9, and 3.10. That information is stored elsewhere. I simply want a user to be able to put that letter into this box and next to it these codes will populate.

View 4 Replies View Related

Create Multiple Workbooks With Names Based On List

Sep 2, 2007

I have some very tedious work to do in Excel:

table looks like following:
DepID name function
S1 a YY
S1 b XX
S1 c ww
S2 d oo
S3 e ii
S3 f ll
S4 t mm
. . . . . .. . . .
. . . . . .. . . .
. . . . . .. . . .

S7999 u ee
S7999 w aa

My task is to create new folders for each department according to DepID, which means if there are 7999 departments, I have to create 7999 folders, any VBA code can do this?

View 9 Replies View Related

Create Dynamic Top-x List Based On Cumulative Values

Jan 18, 2008

My objective is to automate the creation of a dynamic top-5 list by summing a number related to multiple entries of an item (text string). Data are added monthly and while the textual strings (imported) are constant (text1 always reads as text1) the text strings themselves may vary from "text1" to "text2", etc. What I'm trying to achieve is finding the top-5 five items and copy/paste them to a range on the same worksheet. The range into which they are pasted are source cells for DSUM criteria. The frequency with which a text string appears is not critical, but the associated count is.

View 2 Replies View Related

List/Consolidate All Occurrences By Condition

May 24, 2008

Because file size is large therefore I have uploaded the file to megaupload. Click the weblink below:

[url]
Is there formula or UDF which I can use in Column W in Pivot by Week worksheet tab so that I can consolidate all jobs for machine based on shift by day?

Have look in Column W in Pivot by Week worksheet tab for a sample for desired solution.

For Instance, in cell W7 I have used manual formula to consolidate all jobs for G16 Day.

=C9&", "&C10&", "&C18&", "&C19&", "&C20&", "&C21&", "&C23&", "&C24&", "&C25&", "&C32&", "&C36&", "&C37

All job that have a count is greater than 0 is included in my formula.

I need to consolidate the same for other machines as follow: ....

View 3 Replies View Related







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