unique list

  1. N

    VBA code that returns a unique list of non consecutive items, for a lookup value from a table

    I need some vba code, that will return a list of unique non consecutive items from a table, when a certain value changes in one of the sheets. I have been trying with this formula, but I have had no luck. =INDEX('Price List'!$A$3:$C$57000, SMALL(IF('Price Sheet'!$B$4='Price List'!$A$3:$A$57000...
  2. L

    Unique list in Listbox VBA

    I have a data sheet that has multiple entries for Batch Number. Meaning a batch will have multiple expense entries but there will be only one batch number for those. Example: A receipt would be a batch and the items bought would be the entries. I want to create a userform with a listbox to...
  3. Q

    Dependable Dynamic Unique List

    Hello, I have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formulas to cut back on processing time or any if there is other way to get the...
  4. Q

    Help with dynamic unique list

    i have data from which i need to extract unique list. i have everything up and running but my data has lot more rows n columns and excel takes forever to calculate it. Please suggest way to simplify these formula to cut back on processing time or any other way to get the desired dynamic list...
  5. N

    Find Unique list updatable

    Hi, In Illustration i see duplicate and unique values. i want to make a Unique list with formula. other if possible to ignor duplicates Question Table Invioce No. Total 11760 $90.03 11105 $77.63 11173 $74.92 11871 $83.29 11334 $96.34 11908 $61.27 11961 $67.38 11105 $61.66 11334 $95.72...
  6. N

    Find Duplicate with formula and make idividual list

    Hi, In Illustration i see duplicates and i want to make a list with formula. other if possible to sum of list idividual with same column like Question Table Invioce No. Total 11760 $90.03 11105 $77.63 11173 $74.92 11871 $83.29 11334 $96.34 11908 $61.27 11961 $67.38 11105...
  7. M

    Dynamic List of Unique Items Based on Criteria

    Hello wise people, I need some help on a specific query. I'm trying out a simple BI to help manage the employees queue work rates. There are two types of queues; Production and non- Production. Production Codes will have volumes ranging from 0 to any number and the non production codes will...
  8. J

    how to do the opposite of merge or combine?

    Hi all, I have 3 queries, one returning a large list of "all" records and the other two are different subsets of this data... what I'm trying to do in Power Query is reference the "All Records" query and then remove or filter out any records that are found in the other two tables... resulting in...
  9. D

    adding unique items to multiple comboboxes

    I have managed to populate a combobox on userform from a column in a table with unique items (to remove duplicates.) I want to do the same with several other comboboxes with items from other columns in the same table. What do I need to do to the code to make this work. as duplicating some of the...
  10. K

    Unique Data Validation List with indirect function

    Dear Excel Experts, I have some details like this, Customer . . . Style Name Max . . . . . . FB06 Max . . . . . . 701XT OVS . . . . . . MARK Strd . . . . . . TRO002 I want data validation list of unique customer and in other column i want...
  11. M

    Looking for help creating a custom function in Excel.

    Hello all! This is my first post on here. From what I have seen, you guys are enormously helpful. I thought I would put forward my questoin I have hit a wall trying to create a custom function in VBA. I am trying to find unique values in a list of copied values in some column. This is...
  12. J

    Extract Unique List of Values based on Criteria - VBA

    Hello, I have a worksheet called "Staffing Plan" that shows the hours per month required for each resource and project. Column K = Resource Description (ex: Resource A, Resource B, Resource C, etc.) Column W = Project Number (ex: 1, 2, 3, 4, 5, etc.) Column X-FY = hours per month (i.e. row 14 =...
  13. J

    Switch from Absolute reference to Relative Reference - VBA

    Hello, I am working on a model and have VBA code: Copy/paste a range ("A21:L30") from a template worksheet to multiple workbooks that begin with "Labor BOE", multiple times based on a number in cell "L2" For example, if "Labor BOE 1" worksheet has a "3" in cell L2, then it will...
  14. P

    Unique list, combining 2 columns, with a date range criteria

    Hello All, Thanks in advance for any help you can give me. I need to extract a unique list of names from two columns of names, but only names that fall within a given date range. I would also like for the extracted list to be sorted alphabetically a-z. The datasheet is a list of "deals" for...
  15. I

    Dependent Data Validation with Large List

    Hi all, I have a bunch of information copied from the internet in a nice structured table. I am trying to create a separate table that a user can make selections using data validation drop downs. These drop downs will be dependent on what the user has selected previously. I have done...
  16. R

    Unique List excluding "-"

    Hi all, I am working on a database of suppliers which basically looks like this: <colgroup><col><col><col></colgroup><tbody> Client HMUA Gown 1 A W 2 A R 3 D S 4 C Q 5 B W 6 - - 7 D 8 9 C Q 10 - - 11 D S 12 W 13 A R 14 D R 15 B W </tbody> So basically, in...
  17. D

    Transpose Unique Values in column to row

    Column A on Sheet1 has many different remarks. I need to make a unique list on Sheet2 with values from Column A on Sheet1 but post it in one row. This is the idea: Sheet1: Column A 1 1 2 2 2 3 3 3 Sheet2: Column A------------Column B------------Column C...
  18. J

    Unique list with additional criteria

    Hello, Been searching high and low for an answer to my question with little luck (hoping i didn't blindly miss it). I have a set of data which changes each week and need to extract a unique list from it, i currently have a formula which works for me, but i now need to adapt it to include...
  19. R

    Efficient formula to extract unique values from large list (> 10k records)

    Does anyone have a formula for extracting unique values from a single column of a large (>10k records) list that doesn't bog down Excel? Formulas are desired, as replacing duplicates and using macros/custom functions are beyond most of my end users. The formula I usually use is similar to...
  20. GerryZ

    Extract a unique list of items with formula2

    Hi all!! you can se on the top table the data base on the bottom table i need to extract unique names based on the fruit criteria let me know tahnk you in advance!Excel...

Some videos you may like

This Week's Hot Topics

Top