Please provide solution for the above table.
Count of Unique city names should populate in the blue sections based on the following criteria
1)As on Date (which is dependent on the Operational from column)
2)company name
3)zone
4)Type
Please provide solution for the above table.
Count of Unique city names should populate in the blue sections based on the following criteria
1)As on Date (which is dependent on the Operational from column)
2)company name
3)zone
4)Type
Re: Unique cities based on several criterias
try the COUNTIFS formula...see this
=COUNTIFS($D$1:$D$7,$B$8,$E$1:$E$7,$A10,$B$1:$B$7,B$9)
Don’t have an account yet? Register yourself now and be a part of our community!