# unique list

1. ### Convert Unique Formula to Row number

I have this unique formula that is very simple to use and it is widely seen on some forums and excel websites. It is =INDEX(\$C\$2:\$C\$6,MATCH(0,COUNTIFS(\$E\$1:\$E1,\$C\$2:\$C\$6),0)) The index and match work together to look at the prior row to see if is already listed to generate the unique list. I...
2. ### Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
3. ### Unique description List

Hi there, I'm trying to create a unique list of all items which remain unresolved/does not have a resolved date allocated to it. {=IFERROR(INDEX(\$B\$15:\$B\$19,SMALL(IF(\$D\$15:\$D\$19<>"",ROW(\$B\$15:\$B\$19)), ROW(1:1))-1,1),””)} In column B I have the description (B15:B19) In column D there is a...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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 =...
16. ### 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...
17. ### 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...
18. ### 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...
19. ### 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...
20. ### 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...

### 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 MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

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 "mrexcel.com".
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