Forum Discussion
hosea_chumba
Helper I
Helper IIdentify the common items-Row wise.
Take the example below,
Please assist to come up with a formula that identifies the month in the year and the common items appearing in all the months.
| Date (DD/MM/YYYY) | Item |
| 01/08/2022 | X |
| 03/08/2022 | Y |
| 01/09/2022 | Z |
| 02/09/2022 | X |
| 03/09/2022 | Y |
| 01/09/2022 | W |
| 01/10/2022 | X |
| 22/10/2022 | Y |
| 01/11/2022 | X |
| 11/11/2022 | R |
| 23/11/2022 | Y |
| 01/12/2022 | X |
| 12/12/2022 | Y |
1 Reply
DimaMDSolution Sage
Hi hosea_chumba I'm not sure if I understand your problem correctly, but take a look at the file and tell me if this is the result you expect