list all entries

  1. 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...
  2. 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
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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,
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...

Some videos you may like

This Week's Hot Topics