Excel 2016 UNIQUE function

[jerbear1949]

I have Office 2016 on my computer. I found out that the UNIQUE function and other new functions are not available for my version.
I need to identify a unique number is a 2 column 6 row array.
Current Data
Name Number
Joe 4
Pete 3
Mike 4
Sam 4
Fred 2
Russ 3

Desires Result
Name Number
Fred 2


Any suggestions?

Thanks

 

[Eric W]

Try:

Book1
	A	B	C	D	E
1	Name	Number		Name	Unique Number
2	Joe	4		Fred	2
3	Pete	3
4	Mike	4
5	Sam	4
6	Fred	2
7	Russ	3
8
Sheet12

Cell Formulas
Range	Formula
D2:D5	D2	=IF(E2="","",INDEX(A$2:A$7,MATCH(E2,B$2:B$7,0)))
E2:E5	E2	=IFERROR(AGGREGATE(15,6,B$2:B$7/(COUNTIF(B$2:B$7,B$2:B$7)=1),ROWS(E$2:E2)),"")

 

[jerbear1949]

Try:

Book1
	A	B	C	D	E
1	Name	Number		Name	Unique Number
2	Joe	4		Fred	2
3	Pete	3
4	Mike	4
5	Sam	4
6	Fred	2
7	Russ	3
8
Sheet12

Cell Formulas
Range	Formula
D2:D5	D2	=IF(E2="","",INDEX(A$2:A$7,MATCH(E2,B$2:B$7,0)))
E2:E5	E2	=IFERROR(AGGREGATE(15,6,B$2:B$7/(COUNTIF(B$2:B$7,B$2:B$7)=1),ROWS(E$2:E2)),"")

Thank You

 

[jerbear1949]

Try:

Book1
	A	B	C	D	E
1	Name	Number		Name	Unique Number
2	Joe	4		Fred	2
3	Pete	3
4	Mike	4
5	Sam	4
6	Fred	2
7	Russ	3
8
Sheet12

Cell Formulas
Range	Formula
D2:D5	D2	=IF(E2="","",INDEX(A$2:A$7,MATCH(E2,B$2:B$7,0)))
E2:E5	E2	=IFERROR(AGGREGATE(15,6,B$2:B$7/(COUNTIF(B$2:B$7,B$2:B$7)=1),ROWS(E$2:E2)),"")

Eric:

Thanks for the help!! I could not respond earlier because I was at the VA clinic. Anyhow, Can I ask for another modification? Besides detecting the unique number(s), I need it to
detect the unique lowest number!

Thanks

 

[Eric W]

It already does that. The lowest unique number will be the top row. If you drag the formula down the sheet, the other unique numbers will be presented in ascending order.

 

[jerbear1949]

It already does that. The lowest unique number will be the top row. If you drag the formula down the sheet, the other unique numbers will be presented in ascending order.

Is ther eany way if two or people have the lowest number that the out put would wither be a blank or NA or something like that?

Thanks

 

[Eric W]

If two or more people have the lowest number, it wouldn't be unique. Could you show an example of what you're looking for?

 

[jerbear1949]

If two or more people have the lowest number, it wouldn't be unique. Could you show an example of what you're looking for?

Hi:

I'm going to be away for a few days. I'll send you something early next week.

Thank you again for your help!

 

[jerbear1949]

Hi:

I'm going to be away for a few days. I'll send you something early next week.

Thank you again for your help!

II hope this is the last request from you!!! If the number obtained from the list is greater than 4, than the number cell should be blank as well as the name cell.