Creating Unique list from Customer Order Amount, Customer Name and Order Identifier using the Unique function

[bearcub]

Is it possible to use to create a list of values based upon three different columns? I create a unique list of customer orders so I aggregate commissions paid against a customer order.

I calculated rep commissions and I get a data dump from our commission system.

Each commission paid llsts the customer name, the order amount , commissions paid etc for each order. If 50 people receiving payment on the same order then the customer order amount will appear 50 times in the list. The way the sheet is presently set up it is difficult to get a unique customer list.

Customers can have multiple orders during the year. We identify each order by "order Code".

I can create a unique list from the order using the Order Code Feld. But the order code is in the 4th column in the array.

If I include multiple items to create the list, how would I specify the column order? Or is this possible?

This is the data that I am trying to create a unique list from (the unique identified for the order is the Order Code field which I have highlighted in yellow)

The lines shown above are for 1 person's commission. Every person that is paid commissions will have the same structure but different payment orders. I would like to create a unique list from the above table for every month

 

[bearcub]

unique will do that
if you ignor the earning group , as they are all unique

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Credit Amount	Customer Name	Order Item Code	Order Code	Incentive Date	Earning Group				Credit Amount	Customer Name	Order Item Code	Order Code	Incentive Date
2	224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	NARR				224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
3	1.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	New Logo				1.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
4	224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	New Logo NARR				105,550.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
5	105,550.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	Professional Services
Sheet1

Cell Formulas
Range	Formula
J1:N4	J1	=UNIQUE(A1:E5)
Dynamic array formulas.

unique will do that
if you ignor the earning group , as they are all unique

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Credit Amount	Customer Name	Order Item Code	Order Code	Incentive Date	Earning Group				Credit Amount	Customer Name	Order Item Code	Order Code	Incentive Date
2	224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	NARR				224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
3	1.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	New Logo				1.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
4	224,371.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	New Logo NARR				105,550.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24
5	105,550.00	Ingram Micro Inc.	NARR_2024-02-29_From_Connect	0064X00002M7t6pQAB	2/29/24	Professional Services
Sheet1

Cell Formulas
Range	Formula
J1:N4	J1	=UNIQUE(A1:E5)
Dynamic array formulas.

Thank you, yes this is what I needed to know. The unique function behaves like "Remove Duplicates" on the Data menu. I have noticed that if I have more than 1 column of data I get a message asking if I want to use both columns in creating the unique list.

 

[etaf]

ok