Creating templates

New Contributor

I get a data dump every month .I created tab (by city ) and  I try to allocate the details by unique identifier for each tab. I have unique identification in main tab. What formula should I use to allocate the data by unique identification? 

2 Replies


UNIQUE function

don't know which version of Excel you have or what operating system or storage medium you have, but maybe this link above will help you.

If not, the above information and a file (without sensitive data) or photos with a description of the project based on this would be from corteil...especially for you :).


Hope I was able to help you with this information.



I know I don't know anything (Socrates)

@NikolinoDE Thank you for your help. I tried below formula in simple set of data and it worked. I  will let you know if I have any further questions.