Find Unique

[How_Do_I]

Hello all,

How would I look down Column O and find any data that doesn't appear in Column M please?

I'd like my returns to list in Column Q like in my example...

Excel Workbook
	M	N	O	P	Q
4	AB 1		AB 1		AB 12
5	AB 2		AB 2		AB 13
6	AB 3		AB 3
7	AB 4		AB 4
8	AB 5		AB 5
9	AB 6		AB 6
10	AB 7		AB 7
11	AB 8		AB 8
12	AB 9		AB 9
13	AB 10		AB 10
14	AB 11		AB 11
15			AB 12
16			AB 13
Sheet1

 

[villy]

Try this..
[Q1]=IF(ISNA(INDEX(M1:O11,MATCH(O1,M1:M11,0),1))=TRUE,O1," ")

 

[MrVillareal]

Hi Friend

Try this one.

Excel Workbook
	M	N	O	P	Q
4	AB1		AB1		AB12
5	AB2		AB2		AB13
6	AB3		AB3
7	AB4		AB4
8	AB5		AB5
9	AB6		AB6
10	AB7		AB7
11	AB8		AB8
12	AB9		AB9
13	AB10		AB10
14	AB11		AB11
15			AB12
16			AB13
Sheet12

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Copy formula and send it down.

 

[How_Do_I]

Hi villy,

I couldn't get your solution to work... I used the followed which looks like it works.

Thanks for your help though.

Excel Workbook
	M	N	O	P	Q	R	S
2					Count
3					2
4	AB 1		AB 12		1		AB 12
5	AB 2		AB 13		1		AB 13
6	AB 3		AB 1
7	AB 4		AB 2
8	AB 5		AB 3
9	AB 6		AB 4
10	AB 7		AB 5
11	AB 8		AB 6
12	AB 9		AB 7
13	AB 10		AB 10
14	AB 11		AB 11
15			AB 8
16			AB 9
Sheet1

 

[Yahya]

see this link
http://www.mrexcel.com/forum/showthread.php?t=492867

 

[How_Do_I]

Hi Friend

Try this one.

Excel Workbook
	M	N	O	P	Q
4	AB1		AB1		AB12
5	AB2		AB2		AB13
6	AB3		AB3
7	AB4		AB4
8	AB5		AB5
9	AB6		AB6
10	AB7		AB7
11	AB8		AB8
12	AB9		AB9
13	AB10		AB10
14	AB11		AB11
15			AB12
16			AB13
Sheet12

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself


Copy formula and send it down.

Hi there,

I can't use IFERROR with 2003... Thanks for your help though.

 

[How_Do_I]

see this link
http://www.mrexcel.com/forum/showthread.php?t=492867

Thanks for that

 

[MrVillareal]

How about this

Excel Workbook
	M	N	O	P	Q
4	AB1		AB1		AB12
5	AB2		AB2		AB13
6	AB3		AB3
7	AB4		AB4
8	AB5		AB5
9	AB6		AB6
10	AB7		AB7
11	AB8		AB8
12	AB9		AB9
13	AB10		AB10
14	AB11		AB11
15			AB12
16			AB13
Sheet12

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[How_Do_I]

Hi MrVillareal...

That is very good thank you...

 

[MrVillareal]

Welcome