Golf Group scores

[the4hornes]

We have a group of guys that play golf every morning. Some guys play every day and some play only 4 or 5 times a year. I want a excel spreadsheet to keep the scores that will keep the last 4 scores visible on a page and not have to scroll left or right to view the infrequent players and frequent players. In other words, some rows will have 30-40 columns of scores and some rows will have 4 or 5 columns of scores. I want to easily view the last 4 or 5 scores of every row (player) regardless of how many columns(scores) they have. How can I do this? Thanks in advance.

 

[awoohaw]

Try this, but you may need to enter the formula with the CSE keystroke combination (CNTL-SHFT-ENTR):

Mr excel questions 63.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		John	Paul	George	Ringo	Phil	Don	Buddy			John	Paul	George	Ringo	Phil	Don	Buddy
3	2023-09-17 Sun	79	70					89			79	70	99	96	101	69	89
4	2023-09-16 Sat	72	95					89			72	95	93	81	97	74	89
5	2023-09-10 Sun	101	92					100			101	92	71	101	88	69	100
6	2023-09-09 Sat		90					99			102	90	74	97	72	98	99
7	2023-09-03 Sun		71					74
8	2023-09-02 Sat		92	99	96	101	69	87
9	2023-08-27 Sun		101	93	81	97	74	100
10	2023-08-26 Sat			71	101	88	69	94
11	2023-08-20 Sun	102		74	97	72	98	71
12	2023-08-19 Sat	91		90	92	94	77	90
13	2023-08-13 Sun	91		82	69	76	73	85
14	2023-08-12 Sat	98		69	103
15	2023-08-06 Sun	87		77	96
16	2023-08-05 Sat	102	77	88	98
17	2023-07-30 Sun	94	71	83	76
18	2023-07-29 Sat	76	72	75	76
19	2023-07-23 Sun	69	71	102	80
20	2023-07-22 Sat	87			98	75	87	96
21	2023-07-16 Sun	91			88	89	98	78
22	2023-07-15 Sat	77			102	96	78	95
23	2023-07-09 Sun	98			68	78	87	75
24	2023-07-08 Sat	97	81	101	95	98	76	100
25	2023-07-02 Sun	102	72	82	94	71	103	94
26	2023-07-01 Sat	89	68	102	73	90	79	97
27	2023-06-25 Sun	92	85	87	90	89	87	94
28	2023-06-24 Sat	80	79	74	68	85	92	80
29	2023-06-18 Sun	94	100					103
30	2023-06-17 Sat	85	92					98
31	2023-06-11 Sun	99	68					71
32	2023-06-10 Sat	94	81
33	2023-06-04 Sun	81	87
34	2023-06-03 Sat	100	103
35	2023-05-28 Sun	103			69	71	69
36	2023-05-27 Sat	83			95	94	82
37	2023-05-21 Sun			73	74	90	97
38	2023-05-20 Sat			88	74	74	86	78
39	2023-05-14 Sun			94	70	91	83	79
40	2023-05-13 Sat			82	82	69	94	97
41	2023-05-07 Sun			70	73	83	75	98
42	2023-05-06 Sat			95	77	72	102	92
43	2023-04-30 Sun	100	100	84	100	81	91	94
44	2023-04-29 Sat	93			99	103	85	93
45	2023-04-23 Sun	95			100	84	94	71
46	2023-04-22 Sat	78	76	91				95
47	2023-04-16 Sun	89	101	75				84
48	2023-04-15 Sat	68	79	69				93
49	2023-04-09 Sun	68	94	70				92
50	2023-04-08 Sat	98	94	81				72
51	2023-04-02 Sun			94	72	100	72	75
52	2023-04-01 Sat			82	98	90	90	73
the4hornes

Cell Formulas
Range	Formula
K3:Q6	K3	=INDEX($B$3:$H$52,MATCH(LARGE(($A$3:$A$52)*(--(ISNUMBER(INDEX($B$3:$H$52,0,MATCH(K$2,$B$2:$H$2,0))))),ROW(K3)-2),$A$3:$A$52,0), MATCH(K$2,$B$2:$H$2,0))
Press CTRL+SHIFT+ENTER to enter array formulas.