This example is the most basic way I can describe it. I'm looking for a formula that counts how many times a person picked the same fruit and returns the date based on a specified occurrence value in another cell. In this example I'm looking for the date Billy and Joey picked a type of fruit for the 3rd time. Ideally, I'm trying to avoid helper columns and date proof it so the formula would still pick the right date even if the dates are out of order. The last part isn't crucial though. Any help is greatly appreciated!
| Sample.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C | D | E | F | G | H | I | J | K | L | M | N | |||
| 3 | Count | |||||||||||||
| 4 | Student | Fruit Choice | Date | 3 | *When did they have their third piece of the same fruit? | |||||||||
| 5 | Joey | Apple | 2/1/2024 | |||||||||||
| 6 | Billy | Orange | 2/6/2024 | Student | Apple | Banana | Grape | Orange | Plum | |||||
| 7 | Billy | Banana | 2/7/2024 | Joey | 3/1/2024 | 3/19/2024 | 3/9/2024 | *expected results | ||||||
| 8 | Joey | Apple | 2/8/2024 | Billy | 3/21/2024 | |||||||||
| 9 | Joey | Apple | 3/1/2024 | |||||||||||
| 10 | Billy | Orange | 3/7/2024 | |||||||||||
| 11 | Joey | Grape | 3/8/2024 | |||||||||||
| 12 | Billy | Plum | 3/9/2024 | |||||||||||
| 13 | Billy | Orange | 3/9/2024 | |||||||||||
| 14 | Billy | Grape | 3/10/2024 | |||||||||||
| 15 | Billy | Orange | 3/11/2024 | |||||||||||
| 16 | Joey | Banana | 3/12/2024 | |||||||||||
| 17 | Joey | Apple | 3/13/2024 | |||||||||||
| 18 | Joey | Grape | 3/14/2024 | |||||||||||
| 19 | Joey | Apple | 3/18/2024 | |||||||||||
| 20 | Billy | Apple | 3/19/2024 | |||||||||||
| 21 | Joey | Grape | 3/19/2024 | |||||||||||
| 22 | Billy | Apple | 3/20/2024 | |||||||||||
| 23 | Billy | Apple | 3/21/2024 | |||||||||||
| 24 | Billy | Apple | 3/22/2024 | |||||||||||
Sheet1 | ||||||||||||||
