matratus34
Board Regular
- Joined
- Nov 21, 2013
- Messages
- 74
Hi,
I've got 2 sets of data containing Year & Week.
In the 1st set the Year and Week columns are separate (year in column A, Week in column B) - e.g 2020 1, 2020 2, 2020 12, 2020 34
In the 2nd set Year and Week are combined - e.g 202001, 202002, 202012, 202034 etc etc
To align my data I am trying to concatenate set 1 and add in the missing 0 when the week number is below 10.
e.g =IF(Week>9,Year&Week,Year&0&Week)
This obviously returns TEXT so I can't do look ups or find the MIN or MAX week.
If there a way of getting the result to format as a number or a better way of doing this?
Thanks in advance
I've got 2 sets of data containing Year & Week.
In the 1st set the Year and Week columns are separate (year in column A, Week in column B) - e.g 2020 1, 2020 2, 2020 12, 2020 34
In the 2nd set Year and Week are combined - e.g 202001, 202002, 202012, 202034 etc etc
To align my data I am trying to concatenate set 1 and add in the missing 0 when the week number is below 10.
e.g =IF(Week>9,Year&Week,Year&0&Week)
This obviously returns TEXT so I can't do look ups or find the MIN or MAX week.
If there a way of getting the result to format as a number or a better way of doing this?
Thanks in advance