• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unique Identifier based on values in sheet

C

charl

New Member
Hi there everyone.


I import data on a weekly basis, and create reports on the data every week. But I would like to collate all of my weekly data into a bigger pool of data so that I can pull them into reports later down the line.


My first step would be to create a unique identifier for each row of data in a uniform fashion.


We work on a weekly system starting with Monday. So the week we are currently in at the time of writing is week 37. A nice way to pool the data I think would be convert the date of each row entry into the week number and add a few other identifiers on it.


Am I making sense or am I making this extremely complicated for myself?


Thanks in advance!
 
Sounds like a good idea. You could use the WEEKNUM function, and have the 2nd argument be 2 (indicating week starts on a Monday). So, if date is in A2, Name is in B2, and Company is in C2, you could do:

=WEEKNUM(A2,2)&B2&C2


or something like that.
 
Worked perfectly, thanks.


This is the first step in me pooling all the data so that my weekly data can be combined to create a working, dynamic dashboard that can call custom date ranges and compare a variety of metrics.
 
Sounds like a fun project. Let us know if there's anything else we can help out on. =)
 
You must log in or register to reply here.
Back
Top