Golf Logo Ball Score Picker

[MarvinP]

Hi,

I do golf sheet scoring and we have an event inside a normal golf tournament called Logo Ball. The idea is that a 4 man team passes this Logo Ball to the next player in the group and that is the only score that counts for this event.

I need a formula in the yellow cell that I can pull across and down that will pick out the correct scores.

See the attached for my example.

LogoBall Score Picker.xlsx

[shg]

=index(e2:e5, mod(columns($w$1:w$1) - 1, 4) + 1)

[MarvinP]

Hey shg,

I came up with
=INDIRECT(ADDRESS(ROW()+MOD(COLUMN()-ROW()-1,4),COLUMN()-18))

But I'm looking for one that is a bit easier?? Thanks

[MarvinP]

Hi shg,

I get a lot of green corners on my cells with your formula -> error checking. Got another without errors (although I do like it..)

Edit - I'll just turn off Error Checking for these cells - no problem.

[shg]

I'd be more inclined to do it like this:

	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO
1	Ball1	Ball2	Ball3	Ball4	Ball5	Ball6	Ball7	Ball8	Ball9	Ball10	Ball11	Ball12	Ball13	Ball14	Ball15	Ball16	Ball17	Ball18
2	4				4				2				3				3		W2: =IF(MOD(COLUMNS($W$1:W$1) - 1, 4) + 1 = $B2, E2, "")
3		5				5				4				5				5
4			4				8				6				7
5				6				8				6				4
6	5				5				3				3				2
7		5				5				5				4				6
8			4				7				6				4
9				6				8				8				7
10	4				4				4				3				3
11		5				5				5				5				5
12			4				6				4				5
13				8				6				8				8

[MarvinP]

Hey shg,

Thanks for the answers. The first one was better for me as I need all those red numbers on a single row where the Order number equals 1. The second formula is much cuter but not exactly what I need.

Sometimes I get too close to a problem and it is good to have help from the great state of Texas.

[shg]

You're welcome, Marvin.