How To Undo List Hiding Entries
Dec 13, 2012
I keep a client list and excel at random will essentially hide entire rows of entries. For example if I go to search a name from the name column that I know I entered nothing will return but if I specifically enter the cell number that is hidden the information will be show, does excel 2011 have an auto-grouping or hiding feature that I'm not aware of? If so, how do I get rid of it? I'm not sure if this makes a difference but all the numbers to the left most of the sheet are blue where in every other sheet they are gray.
View 2 Replies
ADVERTISEMENT
Jan 20, 2014
I need to consolidate these two lists of data into one list.
First set is just a basic list of individuals with their data.
Second set is multiple entries for those same individuals. Each entry shows a subscription to a programme. The final single sheet should have one row per individual which shows all of the programmes they are subscribed to.
See attached, example sheet.
The real list is 3000 IDs, so need some kind of formula to do this.
View 4 Replies
View Related
Apr 26, 2014
I have two lists of product data, one for buyers and one for sellers (these are listed as A, B, C). The product names are not exactly the same (Eg Playstation and playstation three should be matched), I would have thought using the FuzzyLogic add in to match these would be the way forward! I need to rank the sellers by how many of their items appear on the buyers list
View 8 Replies
View Related
Nov 10, 2008
I have a list of email aliases for my company, approx 10,000 entries, mapping the alias to an email address. Two columns, one the alias firstname.surname, second column being the full email address. I have a second list, a subset of these aliases, approx 1200 of them, that are users of a particular web app. All i have in this list though, is the firstname.surname bit.
What I need to do is compare the lists, and where the aliases match I need to pull out the corresponding full email address from the long list, so I have 1200 aliases in the shorter list, with the full email address mapped to it. Is this possible in excel? i've tried all sorts of LOOKUP functions, and MATCH functions, but none seem to work. MATCH will give me the corresponding row number in the long list, but then it seems to offset itself every row it goes down, so the values are 1 out for every row. First row is good, second row -1, third row -3, fourth row -4 etc.
I don't want to have to manually go through 1200 entries and match them against a 10,000-entry list. Hopefully there's a quick way in excel to filter the long list down to the entries specified in the short list?
View 3 Replies
View Related
Jun 16, 2009
I have a dynamic list of names from B2:B500. I want to write a macro that finds all the unique entries from that list and pastes it to AD3:AD501 everytime the macro is run. What would be the code for this procedure.
View 9 Replies
View Related
Jan 8, 2013
Cells B2:B100 contain a list of sheet names, cells C2:C100 have entries TRUE or FALSE.
Is there away to setup a macro that goes through the list and if false, make the sheet very hidden, if true it should be visible?
View 1 Replies
View Related
Oct 28, 2012
Ok, so lets say i have one list of names (cell:value)
A1:Value 1
A2:Value 2
....
An:Value n
and create a new list
F1:Value 1
F2:Value 2
....
Fn:Value n
I want to have a list nearby and i'd like somehow for a function that will remove entries that already exist on the first list.
View 4 Replies
View Related
May 27, 2014
I have seen a few threads here about this, but not for how I need it to work.
I will have a drop down list with 8 options, (Days of the week Wed to Wed, hence the 8 days lol) There will now be 8 columns, one for each day.
I want to be able to select the day from the list, and then have it hide all the columns except for the day selected. When a different day is picked, un hide that one and hide the rest.
I will attach a book in the reply...
View 14 Replies
View Related
Oct 14, 2008
If you choose entry number 1, Lines 10 to 14 are hidden. If you choose entry number 2, Lines 15 to 29 are hidden and lines 10 to 14 are unhidden. If you choose entry number 3, Lines 20 to 25 are hidden and lines 10 to 29 are unhidden
Until now i have the following:
[Private Sub Worksheet_Change(ByVal Target As Range)
Rows("10:25").Select
Selection.EntireRow.Hidden = False
If Range("A1") = "1" Then
Rows("10:14").Select
Selection.EntireRow.Hidden = True
ElseIf Range("A1") = "2" Then
Rows("15:19").Select
Selection.EntireRow.Hidden = True
ElseIf Range("A1") = "3" Then
Rows("20:24").Select
Selection.EntireRow.Hidden = True
End If
End Sub]
View 2 Replies
View Related
Feb 12, 2009
I am in a fix on how to create a formula where the user can drive the outputs by selecting specific timeframe (placeholder Cell add: C3 on worksheet named Staff Number Calculation).
Based on this selection, the output should be calculated in address C9:H25, now where I am getting stuck is referencing as this output is based on values present in worksheet named "Volumes" and "Time Spent Per Unit".
However, as volumes vary by each month, the number od workers required should also be reflective of changing in volumes worked upon.
For example: ...
View 14 Replies
View Related
May 24, 2013
I used this method to hide previously selected values in a drop down menu. I thought by including that value multiple times in my "employee" list, I could use it multiple times before hiding it. Is there any way to skirt this? I need to use each value three times before it disappears.
View 2 Replies
View Related
Oct 1, 2006
I have a user form with 4 list boxes that I'd each like to populate with their own lists of cities according to time zone - one list box for each time zone (ET, CT, MT and PT).
I attached a worksheet that has some code from another project I got from another thread on this forum, but it needs to be modified (or whole new code written) for this application, including initializing the control buttons.
The code I'm borrowing has a slight glitch in it, where if you select the last item in the list box to hide, that item will be missing from the list the next time the user form is opened, and you'll then have to manually unhide that column.
View 9 Replies
View Related
Jul 25, 2014
I wanted to hide/remove the already selected options in a dependent drop down list so that the next time i am left with only the remaining options.
View 7 Replies
View Related
May 4, 2007
I currently have a list on a worksheet named "Options". It is a named range entitled "Type" with rows A2:A500. Another worksheet uses "Type" as a drop-down list. Currently there are only five entries in the list - cells A2:A6. Other items will periodically be added to the list. That is the reason for the long range - up to A500.
In the drop-down list, all of the unused cells in the named range show up as blanks. Is there any way to not have the blanks show up in the drop-down list?
Or...
Is there a way to define the named range as a variable range to enable users to add items without redefining the range and have the added items automatically show up in the drop-down list?
View 9 Replies
View Related
Nov 3, 2009
I have a list of U.S. cities and their crime numbers. The list contains roughly 8700 records. What I need to do is pull the records for 10 specific cities from that list. Exactly which cities are singled out may change from year to year.
And this is something I'll need to do every year when the crime stats are released by the FBI.
View 6 Replies
View Related
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
Aug 12, 2014
What I am having trouble with is after making a data validation list in a column, I need to count each separate list entry and display it in a "totals" column. The drop down list has 4 entries yes, no, blank, and pending. The formula must count which value has been selected from the list and return it to a cell same as the COUNTA. I.E. 100 rows in the SS 50 are yes, 25 are no, 20 are pending, and 5 are blank.
View 5 Replies
View Related
Sep 28, 2009
I have a list of names in column A with monthly budget figs next to them in columns B,C,D etc. At the bottom of the list there is a total spend summary on line 7. This spreadsheet is then pasted with links to a separate worksheet (see example)
If an additional name is added to the list in Row 7 in the original list, the total is now in row 8 - how do I ensure that the linked sheetl picks up this addition?
(I have a project where I am drawing data from numerous worksheets. I have paste linked them as tabs to a summary worksheet so that funtions such as SUMIF can update when the file is closed or open)
View 4 Replies
View Related
Oct 18, 2007
I am trying to create a drop down list from a named range that has duplicate names listed. I cannot delete any of the duplicate rows. Is there an easy way to create the list with each name represented only once?
View 14 Replies
View Related
Oct 3, 2013
I have a list of entries of which some are distinct and others are similar. For example, I have 1) JohnSmith 2) JhonSmith 3)SomeoneElse. The first and second entry are similar but not equal due to a spelling mistake, the third entry is not related to the first. My question is: How can I obtain which entries belong together? The output would have to show that 1&2 are similar and that 3 is different.
View 4 Replies
View Related
Mar 17, 2008
I am using excel 2003 to count my inventory in the following manor:
I have a "database sheet" that is comprised of possible inventory SKU numbers.
I have a "scanned sheet" that lists all the SKU's that I have scanned in the warehouse
I have a "count sheet" that counts the number of times each SKU in the database appears in the "scanned sheet"
Am I going about this in the most efficient manor?
Question 2: Frequently, new Items appear in the warehouse that are not yet in my database. Is it possible to create a list of SKU numbers that do not have a match in the database? As it stands, any SKU numbers that are scanned but not already listed in my database - simply do not get counted.
View 9 Replies
View Related
Sep 2, 2006
I'm trying to make a sheet that will allow users to either pick from a drop down box, or if the choice they want isn't there, to input data in the same cell. That part I have got. What I can't do is figure out how to have excel add that user input to the list of options, so that they next time the drop down box is used, that "user input" will appear as an option in the drop down. I used data validation to do all these drop downs.
View 2 Replies
View Related
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
Apr 24, 2014
I have a large database of service invoices. Since our invoice can carry multiple lines, the table in question might have multiple entries for the same invoice number. I'm trying to generate a performance metric dashboard for the service group by employee. Again, the employee can show up multiple times per invoice if he performs different work for each invoice.
I'd also like to condense the list down so there aren't any blank rows between the rows with data.
Ultimately, I need to find each individual invoice that each employee worked on and generate a list from which I can then generate an SPC chart. I'm willing to do this in a couple of stages if necessary. Primarily, I want to avoid using VB script if possible.
So, cherry pick service invoice numbers from a list when matched to an employee's name (VLOOKUP), consolidate multiple entries when that employee's name matches multiple entries of the same service invoice number, and condense the list (preferably as it's built) so there are no blank rows.
View 3 Replies
View Related
May 1, 2013
I am doing a list which has the same products returning several times, but with different values. Want to filter/make a new list, with only one of each product and the summed amount of that specific product. Summing the specific amount is not that big of an issue, but the creation of the list is, least in a smart way i have tried this:
[Code]......
This being the last possible entry for the summed list.
My problem is that the formulas is getting too big for my computer :S, since this formula is copied more or less 10 times.
Here is an example of what i want: Product list.xlsx
View 5 Replies
View Related
Oct 22, 2009
Is there anyway to prevent an empty entry from showing up in a list box?
And pending that the above is possible is there a way to exclude the first value a column?
I want all values in column A except A! to display that aren't blank.
View 14 Replies
View Related
Dec 12, 2012
My key is in row A (up to 50,000 keys) my entries are in column B. There could be between 1 to 20 entries per key (variable). i need to move the entries across so my key remains in column A and the entries appear in columns B, C, D, etc. Need to end with one row per key.
from this:
823
car
pool
window
345
pen
123
pen
[code].....
View 2 Replies
View Related
May 23, 2007
I have a spreadsheet that needs to have a validation drop down list in three cells in every row (D, E, F). There are three items in the list, say, "One", "Two" and "Three".
My only problem is that there can only be one entry of "One" in each row.
View 9 Replies
View Related
Apr 4, 2008
I need a formula (I'm not sure if its possible without using VB which I have found on another thread) that I can 'drag' down to the cell Bx (where x is variable) to extract unique entries in a list of values and then display them in a shorter, more concise list - like the 'Pick From List' function does but actually display these values in seperately in a column of cells.
Hope this is making sense.
So (hopefully) to elaborate:
A1:Ax = The list of values containing duplicates
B1:Bx = The list of only unique values from column A
View 9 Replies
View Related
Dec 11, 2009
product1
product1
product3
product7
product1
product7
product3
I want to do a lookup and return to a new list just the unique entries, such as this:
product1
product3
product7
I have it working now using a pivot table to get me the unique items, but there must a be a more efficient function to do this.
View 9 Replies
View Related
