Hi,
I would need in column F (Initial) only to see yes for the contracts that appear first time in current year in this case it is 2022. Contracts can originate in prior year or even year before, and they can be still active in current period
So basically I only search for unique contract number that have originated in current year, because of that it is possible that I get mark YES for contracts that were unique in last year, and that is something I would like to avoid.
I would need in column F (Initial) only to see yes for the contracts that appear first time in current year in this case it is 2022. Contracts can originate in prior year or even year before, and they can be still active in current period
So basically I only search for unique contract number that have originated in current year, because of that it is possible that I get mark YES for contracts that were unique in last year, and that is something I would like to avoid.
Book1.xlsx | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
1 | 2022 | ||||||
2 | |||||||
3 | |||||||
4 | Contract | Year | Amount | Initial | CHECK | ||
5 | 8582/09 | 2022 | 200 | NO | NO | ||
6 | 8582/10 | 2022 | 201 | NO | NO | ||
7 | 8582/11 | 2022 | 202 | NO | NO | ||
8 | 8582/12 | 2022 | 203 | NO | NO | ||
9 | 8582/13 | 2022 | 204 | NO | NO | ||
10 | 8582/14 | 2022 | 205 | NO | NO | ||
11 | 8582/15 | 2022 | 206 | NO | NO | ||
12 | 8582/16 | 2022 | 207 | NO | NO | ||
13 | 8582/17 | 2022 | 208 | NO | NO | ||
14 | 8582/18 | 2022 | 209 | NO | NO | ||
15 | 8582/19 | 2022 | 210 | NO | NO | ||
16 | 8582/20 | 2022 | 211 | NO | NO | ||
17 | 8582/21 | 2022 | 212 | NO | NO | ||
18 | 8582/22 | 2022 | 213 | NO | NO | ||
19 | 8582/23 | 2022 | 214 | NO | NO | ||
20 | 8582/24 | 2022 | 215 | NO | NO | ||
21 | 8582/25 | 2022 | 216 | NO | NO | ||
22 | 8582/26 | 2022 | 217 | YES | YES | ||
23 | 8582/27 | 2022 | 218 | YES | YES | ||
24 | 8582/28 | 2022 | 219 | YES | YES | ||
25 | 8582/29 | 2022 | 220 | YES | YES | ||
26 | 8582/30 | 2022 | 221 | YES | YES | ||
27 | 8582/31 | 2022 | 222 | YES | YES | ||
28 | 8582/32 | 2022 | 223 | YES | YES | ||
29 | 8582/33 | 2022 | 224 | YES | YES | ||
30 | 8582/34 | 2022 | 225 | YES | YES | ||
31 | 8582/35 | 2022 | 226 | YES | YES | ||
32 | 8582/09 | 2021 | 100 | NO | NO | ||
33 | 8582/10 | 2021 | 101 | NO | NO | ||
34 | 8582/11 | 2021 | 102 | NO | NO | ||
35 | 8582/12 | 2021 | 103 | NO | NO | ||
36 | 8582/13 | 2021 | 104 | NO | NO | ||
37 | 8582/14 | 2021 | 105 | NO | NO | ||
38 | 8582/15 | 2021 | 106 | NO | NO | ||
39 | 8582/16 | 2021 | 107 | NO | NO | ||
40 | 8582/17 | 2021 | 108 | NO | NO | ||
41 | 8582/18 | 2021 | 109 | NO | NO | ||
42 | 8582/19 | 2021 | 110 | NO | NO | ||
43 | 8582/20 | 2021 | 111 | NO | NO | ||
44 | 8582/21 | 2021 | 112 | NO | NO | ||
45 | 8582/22 | 2021 | 113 | NO | NO | ||
46 | 8582/23 | 2021 | 114 | NO | NO | ||
47 | 8582/24 | 2021 | 115 | NO | NO | ||
48 | 8582/25 | 2021 | 116 | NO | NO | ||
49 | 8582/08 | 2021 | 117 | YES | NO | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F5:F49 | F5 | =+IF(COUNTIF($C$5:$C$49,$C5:C5)=1,"YES",IF(D5>$D$1,"YES","NO")) |