Creating A List From A List
May 5, 2008
I am trying to create a list of names from a data sheet that can contain up to 1500 rows of call data each with the surgeons name. The number of rows may vary and will have a surgeons name more than once. New surgeons may appear but this is unknown until the call data is received.
e.g.
Smith
Johnson
Edwards
Smith
Smith
Brown
Johnson
etc.
I need to create a list that lists the surgeons name only once. I will then have another formula that will count the number of call-outs for each of the surgeons in the new list.
Saw a nice formula in a thread the other day but it didn't work if any one cell was blank, gave #N/A in all cells: ...
View 10 Replies
ADVERTISEMENT
Jun 11, 2013
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
View 7 Replies
View Related
May 8, 2014
I would like to be able to compare the "standards" in Column A with the Assessment status in Column B and the Assessment period in Column C in order to generate a compact list in another workbook (ideally) or tab (if not). A list might typically contain all the standards that have been M (mastered) during a given Assessment period. I realize that filters would achieve this to a large extent but I was hoping to automatically populate another worksheet or tab.
View 3 Replies
View Related
Mar 17, 2014
I am looking for a Macro that would randomly select 20 items from my inventory list for performing spot checks. Column F of Active Coil Log tab is where the data would need to pull from, however I would like all data in the row to go along with it. I've explored the RAND functions, but they don't seem to be the right fit .
View 2 Replies
View Related
Feb 6, 2009
I thought this would be a simple task, but i cant seem to figure out how to do this.
I have a list with names and its a fixed number of rows, say A1:A200. In the next column, B1:B200, there is either TRUE or FALSE. I want a make a new list with all names with "TRUE" on the same row, without any blanks. How can I do this?
View 5 Replies
View Related
Apr 10, 2014
how to draw the top 5 numbers for each type of element into a list, excluding duplicates, without using array formulae?
Example.xlsx
View 1 Replies
View Related
Jul 7, 2014
I am trying to create a list from an array. Said array contains formulas that return numbers from input contained in an other table. I would like the list to list the numbers in ascending numerical order.
View 5 Replies
View Related
Jun 1, 2009
I have got a worksheet wherein Column A contains the Customer Code, & Column B contains the Customer name. I want to create new worksheets based on the Customer Codes in Column A i.e for each Customer Code, new worksheet should be created wherein I would later on enter some formatting & data in the worksheets. When I select Delete worksheets, all the work sheets other than the 1st worksheet should be deleted.
View 2 Replies
View Related
Mar 28, 2013
Currently I have a spreadsheet with the following columns.
A - company name
B - Company expense date
C - company expense amount
There are many different companies, and each company has multiple rows for different expenses.
How would I create a drop down box, where I can select the company name and have excel create a list of all the expense amounts for that company?
View 3 Replies
View Related
May 1, 2008
I want it just to give me a list of every instance a certain word is used in a column, just like on the autofilter. But each value should in the cell beneath.
Basically I have a list of clients, now when using the autofilter I can select to see the cases from just that client.
But what I want is it to list all the clients relevant to certain months in a column.
View 9 Replies
View Related
Dec 4, 2013
I have been having alot of trouble and have read alot. I can't seem to figure out the problem. I am currently working on an excel sheet that will select a name from the first drop down list. Based on that name five other list will be generated just on the first selection.
View 3 Replies
View Related
Feb 19, 2014
Formula/function to put a set of values into a bucket, depending upon the value.
I've attached a spreadsheet with sample data for your review.
I'm looking to put the Ranking # into one of several Ranking Buckets based on the criteria below:
1-399
400-449
0, 450-499
500-549
550-599
600-649
650-699
700+
I've tried using a LOOKUP function, but I think I'm missing something with it.
=LOOKUP(C2,{1-399,449,499,549,599,649,650,700},{"1-399","400-449","450-499","500-549","550-599","600-649","650-699","700+"})
Excel Bucket.xlsx
View 4 Replies
View Related
Apr 11, 2014
I have a spreadsheet set up in the following way;
Excel Sheet Set Up.JPG
What I'm trying to replicate in column A is similar to the live bullet point numbering that can be found in Word documents where if a line is deleted the section numbering (think bullet points in Word) automatically fall into line and update i.e what was 1.4 automatically becomes 1.3 and so on.
So far I've tried the simple formula of = cell above +0.1 which works fine until i have to remove lines.
View 2 Replies
View Related
Sep 16, 2009
Is it possible to change the Pop Up box formatting after creating a List.?
View 7 Replies
View Related
Feb 19, 2010
I am trying to set the below table up as a validation list. I am having issues with putting it in as list as it creates a new line every time a “,” (comma) occurs. I know I can use the custom and pull the list from a table, but I can’t use this option (the reason I can’t use the table, if interested, is because the single sheet with the validation contains about ~35,000 line items that are being split up into ~200 different sheets. Each sheet is then sent as a separate email…the problem with using the table is that it would on a different spreadsheet to begin with. The email only sends one sheet. As such, it would no longer be able to reference the table).
A - Less than $25,000
B - Between $25,000 and $49,999
C - Between $50,000 and $99,999
D - Between $100,000 and $249,999
E - Between $250,000 and $499,999
F - Between $500,000 and $999,999
G - Over $1,000,000
View 5 Replies
View Related
Mar 11, 2013
Any formula to recognize and copy text from any sheet and create a list of the text items on separate sheet. Attached is a sample file I use. The text items in sheet 20 column a,b,c are items I want copied to a different sheet (list). i would like those items in the 3 columns to be copied and create a single list so I can have a count(Don't want duplicates). From there I would add another formula to give me a count.
Baby Inventory Room 2 - 2012.xlsx
View 1 Replies
View Related
Dec 3, 2013
I have a large list of in rows with multiple column headings: ie. Name, date, amount. I need to generate a separate list whereby the rows that correspond to a given criteria are extracted and listed sequentially.
I have attached a simple example to demonsrate what i mean.
in the attached spreadsheet, i have a column of colours, and a column of objects- RED book, BLUE hat, etc.
I'd like the criteria that i type in the green cell (a choice of colour), to generate a list of all the items that match that colour, and be displayed in the orange cells. So, if the green cell says BLUE, the list should pick out the BLUE dog, BLUE hat etc.
View 1 Replies
View Related
Apr 6, 2011
I have a drop down list in excel. What do I need to do so that it will automatically take me to the closest/best label on the list when I type just a few first letters?
View 14 Replies
View Related
Aug 21, 2009
I have a long list of zip codes (this is just a small portion of the list) that I need to make into ranges. Is there a formula I can use?
From this list:
90080
90081
90082
90083
90084
[Code] ......
To this:
To From
9008090084
9008690089
9009190091
9009390099
9010190103
9017490174
9018590185
9018990189
9020190202
9020990213
9022090220
View 3 Replies
View Related
Jan 18, 2012
I want to create a list of names where the name is multiplied by the number on the second column. See below example.
NamesTickets EarnedMark5Hazel2Art4
On the other sheet's Column A
MarkMarkMarkMarkMarkHazelHazelArtArtArtArt
What macro can I use?
View 2 Replies
View Related
Apr 24, 2012
I am trying to create a master list in a new sheet based on the data contained in 4 separate tabs. The data is Username, Display Name, Company. Unfortunately some users have accounts in 2 of the companies (with the same username) and I need these to default to Company A.
The output need to be username, Display Name, Company.
View 1 Replies
View Related
Jul 30, 2012
I am currently assigning dates to a list manually by giving 5 dates on Mondays to Fridays. I currenly need to do this for around 500 rows and as you can imagine this takes some time.
Is there a way to have a formula that would assign for instance 5 dates on each weekday, purley by dragging the formula down?
For example....
ID
Date
a
07/30/12
b
07/30/12
[Code] ......
View 7 Replies
View Related
Aug 9, 2012
HOW I CAN USE IN EXCEL VALIDATION DROP DOWN BELOW CONDITION
=IF(B1="Assets",[Mapping.xls]Assets!$A:$A,IF(B1="Liability",[Mapping.xls]Liability!$A:$A,""))
View 7 Replies
View Related
Jan 24, 2014
I am attempting to create a unique list on column B of tab "1" from columns B of tabs "2" through "5" for which i have the following array formula thus far,
=IFERROR(INDEX(??3Dreference??, MATCH(0,COUNTIF($B$3:$B3,??3Dreference??),0)),"")
I've attempted to list my tab names somewhere on the sheet and inserting this into the previous formula,
INDIRECT("'"&$P$4:$P$7&"'!B3:B300")
However this will only return the first value from column B on each tab and I'm assuming its because INDEX and COUNTIF do not accept 3d references.
View 5 Replies
View Related
Oct 5, 2006
I am trying to take data from one spreadsheet and do a couple of things. First, i need to create a tab for each column and name the tab after the name in row 1. (this code i already have, it is below)
Second, and here is where i need help, i want to put the tab name and corresponding data (all in the same column on the first sheet) onto each tab. Essentially i am just divying up each column on my master sheet into its own tab so that i can do further data analysis.
Sub GenWStabnames2()
'Kemper Ohlmeyer based on code from David McRitchie
Dim cell As Range
Dim newName As String, xx As String
Err.Description = ""
On Error Resume Next
'--cells with numbers, including dates, will be ignored,
For Each cell In Worksheets("Manager list").Range("fund.names")................
View 9 Replies
View Related
Dec 24, 2006
What I'm trying to achieve is the following;
I have a big keyword list saved in Excel.
Something like the following,
These are all keyword phrases;
car rent
car hire
cars for rent uk
etc etc etc
All listed in Column A
All phrases in Column A, and in separate rows.(1 phrase per row.)about 2000 lines (Rows) in total.
What I want to know is there any way of selecting the whole list and exporting it (To save it as another list. A list of just unique keywords?
So, It would create a list like;
car
rent
uk
hire
for
etc etc etc.
So basically I want excell to look at all the words and export them to another list showing just unique keywords, 1 per line.
This is so I can see from a huge list what all the unique keywords are.
Is there a way of doing this within Excel Now?? or has someone made a plugin ( Macro) to achieve this?
I've looked at the sort & filter options, but it doesn't appear to have this function?
View 9 Replies
View Related
Jan 10, 2007
I have a list of numbers . Several numbers are pulled, based on criteria, and then I need to create a list with just the remaining numbers.
EXAMPLE:
A) Numbers 1 - 500, defined by name (So I can INDEX them later)
B) Pull out numbers 47, 3, 143, 224 (based on certain criteria)
C) By INDEXING the field, create a list of numbers 1 - 500, omitting the above numbers.
I have no problems with steps A & B. I can't do step C.
View 9 Replies
View Related
Feb 19, 2007
I have a wb containing several sheets that the field supervisors use to fill out for ordering material. Each sheet contains different types of material. The problem is that, if they only need one particular item from each type (sheet), they have to print 7 or 8 sheets just for those 7 or 8 items. I want to create a sheet that will list everything they are ordering in one compact, neat area, so they only have to print one sheet.
The set up of the sheets goes like this. There's a column containing the name of all the items. Next to each item is a place they can specify how many of that item they want. They leave it blank if they don't want any. That's it. Really quite simple.
So now, I need this new sheet to find all the cells that a quantity was entered on the other sheets, and list that and the description of the item wanted, along with what type of material it is. I have figured out one way of doing it, but it would take a crap load of hidden IF formulas, and I know there has to be a simpler way. I'm open to all suggestions - whether it's vb codes or formulas, it doesn't matter to me.
View 9 Replies
View Related
Aug 27, 2008
I have a list of approx 600 locations with codes that I want to populate into individual worksheets.
For example, the list (in excel) has the following
NEW YORK 12345 WW012
NEW JERSEY 23456 WW013
PENN 34567 WW014
(Each field is in it's own column)
The other worksheet is a template where the Site Name, codes would be placed is specific locations, one site per worksheet.
Is there a macro that can create one sheet per site with the proper information?
View 9 Replies
View Related
Jan 16, 2009
I'm trying to automate a task at work which is really annoying. I've gotten some of the way, but would like your help to get over this hill.
This is what I've got so far:
I get the data from AutoCAD, I've cleaned it up, and created a Vlookup to give me the length in inches. Due to minor variations in length, the data from AutoCAD is seperated into equal lengths. What I need to do is combine this information into a single row. For example, rows 13-16 are exactly the same, and need to be combined into a single row. They are all 15" in Pour #3, but I have to add these numbers up with a calcultor to get a final count. Since most buildings are not the same, the data can be different, but they will always have the same basic columns; "Count", "Pour", and "Length". Name can be thrown out because it's not really necessary, I just keep it in there to make sure all I'm counting is lines.
View 9 Replies
View Related
