Hi guys,
Hopefully there is a simple solution to this problem.
I would like to create a list of dates in a column based on the results of the data in another column. So,
In col A i have a range of dates that are random dates from throughout the year.
In col B I have either a 1 or a 0...the 1 represents that a certain random event occurred on that date, whilst the 0 represents the event not occurring on that date.
I in col C I would like to create a list of dates of when the event occurred...ie...C1 first time the event occurred, C2, the next...etc.
Any help and guidance would be greatly appreciated.
James
Hopefully there is a simple solution to this problem.
I would like to create a list of dates in a column based on the results of the data in another column. So,
In col A i have a range of dates that are random dates from throughout the year.
In col B I have either a 1 or a 0...the 1 represents that a certain random event occurred on that date, whilst the 0 represents the event not occurring on that date.
I in col C I would like to create a list of dates of when the event occurred...ie...C1 first time the event occurred, C2, the next...etc.
Any help and guidance would be greatly appreciated.
James