thomasuponor
New Member
- Joined
- Sep 13, 2018
- Messages
- 44
- Office Version
- 2016
- Platform
- Windows
I want to improve the formula for extracting unique zip code for 2019.
I am currently using this formula but its very slowly:
=IFERROR(INDEX('Project Data'!E:E;MATCH(0;COUNTIF('Dashboard Sales'!G114:$G$114;'Project Data'!E:E)+IF('Project Data'!L:L>=$E$113;1;0)+IF('Project Data'!L:L<=$D$113;1;0);0));"")
I am currently using this formula but its very slowly:
=IFERROR(INDEX('Project Data'!E:E;MATCH(0;COUNTIF('Dashboard Sales'!G114:$G$114;'Project Data'!E:E)+IF('Project Data'!L:L>=$E$113;1;0)+IF('Project Data'!L:L<=$D$113;1;0);0));"")
Zip | Date | Unique Zip |
7000 | 01-02-2019 | 7000 |
3000 | 01-02-2020 | 9000 |
7000 | 01-03-2019 | 5000 |
9000 | 01-07-2019 | |
5000 | 29-03-2019 |
Last edited by a moderator: