list all entries

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