Hello,
I got years in the column "C" in the range C6:C45 I want a formula, which can give me in the range C2 minimum year and in the range C3 maximum year value
For example, the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti
I got years in the column "C" in the range C6:C45 I want a formula, which can give me in the range C2 minimum year and in the range C3 maximum year value
* | A | B | C | D |
1 | ||||
2 | Min | 04/05 | ||
3 | Max | 20/21 | ||
4 | ||||
5 | Year | |||
6 | 19/20 | |||
7 | 18/19 | |||
8 | 20/21 | |||
9 | 19/20 | |||
10 | 19/20 | |||
11 | 17/18 | |||
12 | 20/21 | |||
13 | 17/18 | |||
14 | 19/20 | |||
15 | 20/21 | |||
16 | 19/20 | |||
17 | 20/21 | |||
18 | 20/21 | |||
19 | 20/21 | |||
20 | 20/21 | |||
21 | 20/21 | |||
22 | 20/21 | |||
23 | 19/20 | |||
24 | 20/21 | |||
25 | 18/19 | |||
26 | 20/21 | |||
27 | 20/21 | |||
28 | 20/21 | |||
29 | 04/05 | |||
30 | 20/21 | |||
31 | 20/21 | |||
32 | 17/18 | |||
33 | 20/21 | |||
34 | 19/20 | |||
35 | 18/19 | |||
36 | 18/19 | |||
37 | 20/21 | |||
38 | 20/21 | |||
39 | 19/20 | |||
40 | 19/20 | |||
41 | 20/21 | |||
42 | 19/20 | |||
43 | 20/21 | |||
44 | 19/20 | |||
45 | 18/19 | |||
46 | ||||
47 | ||||
48 |
For example, the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti