If false do nothing... but a little more difficult

[golfguy123]

person1 A 66
person2 A 68
person3 A 70
person4 B 88
person5 B 89
person6 A 65
person7 C 90
person8 C 91

I WANT TO GET THE LOWEST SCORE FOR ALL PERSONS WITH AN 'A' NEXT TO THEIR SCORE?

THIS IS THE IF/THEN I WROTE, BUT I DONT KNOW HOW TO IGNORE IF FALSE

=IF(B7:B20="a",SMALL(W7:W20,1),???????)

SIGNED ..... STRUGGLING!

 

[AhoyNC]

Based on your example above, what result do you want to see. In group A I assume Mike Taylor would be 1st place in group A. Since the rest of group A has a score of 72 would you show an "x" or would they all be 2nd place.
What about group C where everyone has a score of 72?

 

[golfguy123]

I was able to figure it out, but now I am stuck with ties. when more that one have the lowest or 2nd lowest score, I want them either mentioned or any 'x' to indicate a tie has happened

 

[AhoyNC]

Maybe something like this.
These are array formulas and must be entered with CTRL-SHIFT-ENTER.

In the example below drag formula in B17 down 3 rows. Drag formula in C17 down 3 rows and across columns as needed.
Drag formula in B24 down 3 rows. Drag formula in C24 down 3 rows and across columns.

Excel Workbook
	A	B	C	D	E	F	G	U	V	W
1	Name	Group	HOLE #1	HOLE #2	HOLE #3	HOLE #4	HOLE #5	Front	Back	Total
2	Leroy McDuffie Jr	A	4	3	4	5	4	36	36	72
3	Kevin Pack	A	4	3	4	5	4	36	36	72
4	Greg Taylor	A	4	3	4	5	4	36	36	72
5	Mike Taylor	A	4	3	4	2	4	33	36	69
6	LUVON DUNGEE	B	4	3	4	5	4	36	36	72
7	CARTER THORPE	B	3	3	4	5	4	35	36	71
8	KARLTON DUNN	C	4	3	4	5	4	36	36	72
9	GREG PROLEAU	C	4	3	4	5	4	36	36	72
10	AL JOYNER	C	4	3	4	5	4	36	36	72
11	Sang Choi	B	4	3	4	5	4	36	36	72
12	TEDDY	B	2	3	4	5	4	34	36	70
13
14
15	Group	A
16	Place	Score	Names
17	1	69	Mike Taylor
18	2	72	Leroy McDuffie Jr	Kevin Pack	Greg Taylor
19	3	X
20
21
22	Group	B
23	Place	Score	Names
24	1	70	TEDDY
25	2	71	CARTER THORPE
26	3	72	LUVON DUNGEE	Sang Choi
27
Sheet