Problem with ignoring duplicates in a list of numbers

[Gochix2018]

Good morning, im having a problem to ignore duplicates in a list down below where im looking for ORDER NUMBER for certain Customer.
The list is changing every day so i can't know in which cells that customer is going to be.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Formula what im using to get Customer order number is :

Please Login or Register  to view this content.

So just because i have 2 different order numbers for same customer then i can't find it with the same formula as above. So i tried many times to use index match formula which works but always not ignoring duplicates so showing always the first order number.
Just need to ignore first order number and give next unique order number.

[Gochix2018]

just to add to my previous info. i require this formula to look through the list of order numbers and show me each individual order number for each customer... this can be up to 3/4 order numbers per customer and as stated before vlookup always finds the first . of cours if i manually add a 1 to the end for example or change the name in some way then it will find it but this is not effecient and idealy i need it to be automatic

[AliGW]

Why don't you use a filter?

[Gochix2018]

Well Ali, that was first thing what i was thinking to do. But as my list is taken from another document i can't use filter on that one. Because the list is changing every day then if i will use filter then i will remove duplicated cells which i can't do.

[AliGW]

Why would filtering the data remove duplicates? I don't understand your comment, sorry.

[Gochix2018]

Then i was thinking about other thing. Sorry my bad. I was looking for solutions and saw a post where you can remove duplicates, so i was thinking you are suggesting that one
Can you describe how that filtering data feature works please.

[AliGW]

Just click on the data filter button on the Data ribbon (it looks like a funnel) and then use the filters that appear at the top of the page to filter on whichever column you choose. If you need to, you can copy and paste filtered data to another sheet.

[Gochix2018]

Thanks for suggestion but this not quite exactly what im looking for. Maybe there is a way how to deal with it automatically?
Some formula. I assume that would do something with index and match formulas..

[AliGW]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[Gochix2018]

Attached a file for a example Hope this helps to understand it more

[AliGW]

In B12:

=IFERROR(INDEX($E$2:$E$5, MATCH(0,COUNTIF($B$11:$B11,$E$2:$E$5)+IF($B$2:$B$5<>$A$12,1,0),0)),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Once confirmed, drag copy down.

[Gochix2018]

Thank you Ali. It works great. Just because the list of orders is changing every day then i can't know where the actuall cells of that customer is going to be. One day it might be $E$2:$E$5, other day it can be $E$25:$E$37
So is there a way to put some vlookup formula in there to find it first in the list and then array the order number?
I would be thankfull for that Ali.

[AliGW]

It doesn't matter where the customer is - the formula will find where their entries start.

Make the arrays in the formula as long as the full data table.

Excel 2016 (Windows) 32 bit

	B
12	=IFERROR(INDEX($E$2:$E$9, MATCH(0, COUNTIF($B$11:$B11,$E$2:$E$9)+IF($B$2:$B$9<>$A$12,1,0),0)),"")

Sheet: example

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K
1	ID	Customer	Resource	Description	Order number	Date
2	O00105	CUSTOMER2	3811800	EXTRA TASTY RIB	UK-19-031860	16/04/2019
3	O00105	CUSTOMER2	3784300	WB 1.6	UK-19-031875	16/04/2019
4	O00105	CUSTOMER1	6756000	BBQ BOURBON	UK-19-031871	16/04/2019
5	O00105	CUSTOMER1	6765400	FIRECRACKER	UK-19-031871	16/04/2019
6	O00105	CUSTOMER1	3811800	EXTRA TASTY RIB	UK-19-031869	16/04/2019
7	O00105	CUSTOMER1	3784300	WB 1.6	UK-19-031869	16/04/2019
8	O00105	CUSTOMER1	6756000	BBQ BOURBON	UK-19-031871	16/04/2019
9	O00105	CUSTOMER1	6765400	FIRECRACKER	UK-19-031871	16/04/2019
10	Here im having a formula which looks what is the order number for customer
11
12	CUSTOMER1	UK-19-031871
13	CUSTOMER1	UK-19-031869	<<---	Here I want it to ignore the duplicate order number and show the next unique order number of the customer

Sheet: example

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Gochix2018]

Thank you very much! Saved me a lot of time. Have a nice day

[AliGW]

Glad to have helped.