list all entries

  1. F

    Creating a changing data validation list

    Hi. I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words? Example. TEST1 TEST2 TEST3 etc down to TEST10. I go into another cell...
  2. M

    Required a formula to return combined a list, common values in a both list, values not included in each other List.

    Hi, Required a formula help for do a different types of workouts as based on data (Work items list-1 & 2) contains in Column A to C, for there required details as follows. In a Column E, Cell number E4 to be return a Combined work items lists (merged list) of both lists into one list, Sort A...
  3. D

    Alphabetically order a list with respect to column B

    Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David
  4. T

    To protect and lock cells after entry of weight in col. A, time of data entry will be recorded, comapare value, and set counter?

    Private Sub Worksheet_Change(ByVal Target As Range) Dim tasksheet As Worksheet Dim i As Integer Dim T2 As Integer Dim Lr As Integer ActiveSheet.Unprotect Password:="123" Target.Locked = False Set tasksheet = ThisWorkbook.Sheets("Sheet1") Lr = tasksheet.Cells(Rows.Count, 1).End(xlUp).Row For...
  5. A

    Pivot Table

    Good day! I've dragged Date to the Filter field. When I open the list, I find the entire list not grouped into years>months>days. Is there something I can do to make it happen?
  6. S

    Make a list with criteria and no duplicates

    I receive a spreadsheet with the information listed below. The spreadsheet has a list of employees, spouse, children with DOB's and packages (Medical & Dental). I want to create a formula that extracts every employee with the relationship 1 without duplicates. My current formula extracts...
  7. S

    Generating a List based on enterie Totals

    After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table. So I need to generate a list that looks like this <tbody> North East South South South South South West West From a table that is...
  8. M

    Extract all data from Sheet1 Based on 1 Cell

    Hi I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column. I need it all in a different format which I need to grab with single validated list. Any possibilities?? Sheet...
  9. S

    Returning header labels based on cell values

    Hi , I need your help, i have a sheet that has several entries (columns and row, sample below) i would like to retrieve the header label based on a certain cell value (i.e. pending) and place the labels in the last cell (who is pending). in other words, if there is a date in the cell then its...
  10. P

    sum all items in list based on condition

    Hi, I have the following list of data:- <tbody> A B 7 750<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 10.0px Verdana}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 10.0px Verdana}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...
  11. B

    Filter list per Character From Smallest to Highest using code

    Hi Guys, Is there a way we can filter list based on the number of character in a cell from lowest to highest using code alone? Sample Below Sa1 Sample 23 Samepl Samples Output Sa1 Samepl Samples Sample 23 Thanks,
  12. D

    Find all cells in "A:A that contain "B$1$" and list all values starting in " B$2$"

    I have a list, in Column A, of 900 customer codes. Examples are AFP, AU3, NKD, YM2, JWW etc... They could be anything, but are always either 2 or 3 characters. In Column B and Column C I have those codes broken down into the "First two characters"(column B) and then the "Last two...
  13. D

    output matched string value - vlookup multiple instances

    I need the zip codes associated with a list of nine metro areas that I have. Examples of strings in my list are "Philadelphia", "Baltimore" etc. I also have a table with two columns - zip codes and associated metro area of each Zip code for the entire USA. What I'd like to do is have a table...
  14. P

    Search for date in Listbox

    Hi Guys , I have code that will look for any value in a Textbox and displays them in a listbox which works fine but I am having problems trying to find DATES using a the Datepicker "Drop down calender" when I Select a date and press the Find button I set up? I get no result what so ever, not...
  15. P

    Listing Data in a ListBox Challenge

    Hi Guys, I have a form with 4 TextBoxe's "TexBox1,2,3 etc" and a ListBox1 were the whole idea is that you enter a value in TexBox1 and the VBA code looks for any and all items on your data "respective worksheet" and lists any/all data that it finds "corresponding to the value in TextBox 1" in...
  16. L

    Prevent data entry in a Userform field after 20 entries

    This is my second post and the first in this particular Forum, so Hello everyone. :) You'll have to forgive me coz my english is not that great. Right, let's get down to business. I have a file that automatically shows at startup, a Dialog Box (UserForm) with a "Date" field, which filling is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back