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!

 

[jtakw]

Hi,

If you want those that are Not "A" in column B ignored, then just use "" for FALSE.

Book1
	A	B	C	D
1	person1	A	66	65
2	person2	A	68	65
3	person3	A	70	65
4	person4	B	88
5	person5	B	89
6	person6	A	65	65
7	person7	C	90
8	person8	C	91
Sheet77

Cell Formulas
Range	Formula
D1	=IF(B$1:B$8="A",SMALL(C$1:C$8,1),"")

Your Caps Lock might be stuck on your keyboard...

 

[golfguy123]

[TABLE="width: 1166"]
<colgroup><col><col span="19"><col><col><col></colgroup><tbody>[TR]
[TD]NAME[/TD]
[TD][/TD]
[TD]HOLE #1[/TD]
[TD]HOLE #2[/TD]
[TD]HOLE #3[/TD]
[TD]HOLE #4[/TD]
[TD]HOLE #5[/TD]
[TD]HOLE #6[/TD]
[TD]HOLE #7[/TD]
[TD]HOLE #8[/TD]
[TD]HOLE #9[/TD]
[TD]HOLE #10[/TD]
[TD]HOLE #11[/TD]
[TD]HOLE #12[/TD]
[TD]HOLE #13[/TD]
[TD]HOLE #14[/TD]
[TD]HOLE #15[/TD]
[TD]HOLE #16[/TD]
[TD]HOLE #17[/TD]
[TD]HOLE #18[/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HOLE WINNER[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]DONUT[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]FRONT 9 TOTALS[/TD]
[TD]BACK 9 TOTALS[/TD]
[TD]TOTAL SCORES[/TD]
[/TR]
[TR]
[TD]PAR[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]54[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD]46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]DONUT[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GROUP A/B/C[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]A[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]63[/TD]
[TD]63[/TD]
[TD]126[/TD]
[/TR]
[TR]
[TD]BACON[/TD]
[TD]A[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]63[/TD]
[TD]63[/TD]
[TD]126[/TD]
[/TR]
[TR]
[TD]CUCUMBER[/TD]
[TD]A[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]63[/TD]
[TD]63[/TD]
[TD]126[/TD]
[/TR]
[TR]
[TD]DONUT[/TD]
[TD]A[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]55[/TD]
[TD]63[/TD]
[TD]118[/TD]
[/TR]
[TR]
[TD]EGGPLANT[/TD]
[TD]B[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]63[/TD]
[TD]63[/TD]
[TD]126[/TD]
[/TR]
[TR]
[TD]FROSTY[/TD]
[TD]B[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]63[/TD]
[TD]63[/TD]
[TD]126
[/TD]
[/TR]
</tbody>[/TABLE]


i WANT ONLY THE LOWEST PLAYER IN GROUP 'A' ...i TRIED THAT AND IT GAVE ME ###### (VALUE)

 

[golfguy123]

sorry about the caps lock

 

[jtakw]

Are you saying you want the NAME of the person in Group A with the Lowest Total?

What if there's a tie for lowest? In your sample above, if DONUT had a Total of 126, you'd have a 4 way tie?

 

[AhoyNC]

Is this what you are trying to do?
This is an array formula and must be entered with CTRL-SHIFT-ENTER. Copy across as needed.

Excel Workbook
	A	B	C	D	E	F	G	H
1	NAME		HOLE #1	HOLE #2	HOLE #3	HOLE #4	HOLE #5	HOLE #6
2	HOLE WINNER	X	x	DONUT	BACON	x	CUCUMBER	x
3	PAR	4	3	4	5	4	3	4
4		54	1	1	46	46	46	46
5		X	X	DONUT	X	X	X	X
6	GROUP A/B/C	7	4	2	7	7	7	7
7	APPLE	A	7	7	7	7	7	7
8	BACON	A	7	7	6	7	7	7
9	CUCUMBER	A	7	7	7	7	3	7
10	DONUT	A	7	4	7	7	7	7
11	EGGPLANT	B	7	7	7	7	7	7
12	FROSTY	B	7	7	7	7	7	7
Sheet

 

[golfguy123]

Yes, there are three different groups one can compete in, Group A, B, or C. Once we have your score there will be a 1st, 2nd, and 3rd place for each group.
and yes, if there is a tie, I would want a response of "X" or"there is a tie"

when writing the formulas...

A...Names
B...Group
C...totals

 

[golfguy123]

Yes, there are three different groups one can compete in, Group A, B, or C. Once we have your score there will be a 1st, 2nd, and 3rd place for each group.
and yes, if there is a tie, I would want a response of "X" or"there is a tie"

when writing the formulas...

A...Names
B...Group
C...totals

 

[golfguy123]

Yes, there are three different groups one can compete in, Group A, B, or C. Once we have your score there will be a 1st, 2nd, and 3rd place for each group.
and yes, if there is a tie, I would want a response of "X" or"there is a tie"

when writing the formulas...

A...Names
B...Group
C...totals

for some reason, when i apply this, it only gives me a lowest value of all the numbers

 

[golfguy123]

[TABLE="width: 1018"]
<colgroup><col><col span="22"><col></colgroup><tbody>[TR]
[TD]Leroy McDuffie Jr[/TD]
[TD]A[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kevin Pack[/TD]
[TD]A[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Greg Taylor[/TD]
[TD]A[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mike Taylor[/TD]
[TD]A[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]33[/TD]
[TD]36[/TD]
[TD]69[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LUVON DUNGEE[/TD]
[TD]B[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CARTER THORPE [/TD]
[TD]B[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]35[/TD]
[TD]36[/TD]
[TD]71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KARLTON DUNN[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GREG PROLEAU[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AL JOYNER[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sang Choi[/TD]
[TD]B[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]36[/TD]
[TD]36[/TD]
[TD]72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TEDDY[/TD]
[TD]B[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]
I do get true/false values from my If/then function, but the formula only gives me the smallest value of all the scores not just 'A' or 'b' or 'c' groups(selection dependant)
it is not giving me the lowest of A....weird!