Hiya, I tried to search but couldnt find the exact answer.
I have a list of entries in DD/MM/YYYY format. I want to create a lookup that will tell me for example in a certain cell range, how many entries were in October for example. I can then customise this to whatever month I want to know the entries are.
Further to this, each entry also has another value in it and I want to know how many in october are red for example.
Line content is:
DATE. TYPE
01/10/2021. RED.
01/10/2021. RED.
03/10/2021. BLUE.
05/10/2021. GREEN.
Any help appreciated thanks
I have a list of entries in DD/MM/YYYY format. I want to create a lookup that will tell me for example in a certain cell range, how many entries were in October for example. I can then customise this to whatever month I want to know the entries are.
Further to this, each entry also has another value in it and I want to know how many in october are red for example.
Line content is:
DATE. TYPE
01/10/2021. RED.
01/10/2021. RED.
03/10/2021. BLUE.
05/10/2021. GREEN.
Any help appreciated thanks