apatheticrory
New Member
- Joined
- Jul 27, 2017
- Messages
- 6
I am creating a sheet that counts the number of applications received from specific Nationalities excluding GBR (British).
I am currently using the below formula to return the nationality exc. GBR MODE for the year, however i'm really struggling to alter this to only count data where a specific month number is in Cell AY1:AY5000
Any help would be really appreciated, i've been trying for a while now
I am currently using the below formula to return the nationality exc. GBR MODE for the year, however i'm really struggling to alter this to only count data where a specific month number is in Cell AY1:AY5000
Code:
=IF(ISERROR(INDEX(Applications!$P$2:$P$5000,MODE(IF((Applications!$P$2:$P$5000<>"")*ISNA(MATCH(Applications!$P$2:$P$5000,Mode!$K$1:$K$1,0)),MATCH(Applications!$P$2:$P$5000,Applications!$P$2:$P$5000,0)))))," No Data", INDEX(Applications!$P$2:$P$5000,MODE(IF((Applications!$P$2:$P$5000<>"")*ISNA(MATCH(Applications!$P$2:$P$5000,Mode!$K$1:$K$1,0)),MATCH(Applications!$P$2:$P$5000,Applications!$P$2:$P$5000,0)))))
Any help would be really appreciated, i've been trying for a while now