unique list

make the unique list of table column b values, where table column A contains “1”

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...