Index find next no match

[Bonkers Bill]

Hi every one, i am trying to index a list 'Got Upload'!A$1:A$1325, find the 1st one that is not in another list Remix!K$2:K$795, drag this down so it finds the 2nd, 3rd and so on
=index('Got Upload'!A$1:A$1325(nomatch(Remix!K$2:K$795,'Got Upload'!A$1:A$1325),0)
I know this formula is total rubbish but i dont know where to start, these are the ranges, any help would be great.

Today i will mostly be sailing down our street

 

[Aladin Akyurek]

Try to post a tiny sample along with the expected results...

 

[Bonkers Bill]

=index('Got Upload'!A$1:A$1325(nomatch(Remix!K$2:K$795,'Got Upload'!A$1:A$1325),0)
Heres another way of saying the formula that might help,
if(index(Remix!K$2:K$795,match('Got Upload'!A$1,Remix!K$2:K$795) is true, then match'Got Upload'!A$2 and so on, if false, enter result 'Got Upload'!A$1 or which ever is false, hope this makes more sense.

 

[Bonkers Bill]

Got
D001
D002
D003
D004
D005
D006

Remix
D001
D002
D004
D006
D007
D008
I am looking for the numbers in Got that is not in remix, i am looking for a formula that i can enter in box A1 and drag it down the column, A1 result is D003, A2 result is D005 and so on, the numbers in remix are not in order and i'm not 100% sure that Got are

 

[facethegod]

If your GOT range is in A1:A6 and your REMIX range is in B1:B6 Then try this in C1 and drag down:

=INDEX(A:A,SMALL(IF(ISNA(MATCH($A$1:$A$6,$B$1:$B$6,0)),ROW($A$1:$A$6),""),ROWS($1:1)),1)

HTH

 

[Bonkers Bill]

This is the formula i used
=INDEX('Got Upload'!A:A,SMALL(IF(ISNA(MATCH('Got Upload'!A$1:A$5000,Remix!K$2:K$5001,0)),ROW('Got Upload'!A$1:A$5000),""),ROWS($1:1)),1)
it works on the 1st number then returns#NUM for the rest

 

[Bonkers Bill]

This is the formula i used
=INDEX('Got Upload'!A:A,SMALL(IF(ISNA(MATCH('Got Upload'!A$1:A$5000,Remix!K$2:K$5001,0)),ROW('Got Upload'!A$1:A$5000),""),ROWS($1:1)),1)
it works on the 1st number then returns#NUM for the rest

 

[Bonkers Bill]

This is the formula i used
=INDEX('Got Upload'!A:A,SMALL(IF(ISNA(MATCH('Got Upload'!A$1:A$5000,Remix!K$2:K$5001,0)),ROW('Got Upload'!A$1:A$5000),""),ROWS($1:1)),1)
it works on the 1st number then returns#NUM for the rest

 

[facethegod]

Did you confirm it w/ Ctr + Shift + Enter, not just Enter?

 

[Bonkers Bill]

Thanks facethegod that works great, there is another bit to this if you could help, the formula returns more than one result that is the same eg if there are 3 D0001 it returns 3, i would like the formula to only return 1 of each, no duplicates, do you know how to do this. Cheers

Today I will set sail to find land after the floods!