J
JackGreen
Hi,
I have the following issue:
I have a tab with 2 columns:
Company Date
Company 1 13/04/13
Company 1 13/04/13
Company 1 13/04/13
Company 1 14/04/13
Company 1 14/04/13
Company 1 15/04/13
Company 1 15/04/13
Company 2 13/04/13
Company 2 13/04/13
Company 2 14/04/13
Company 2 14/04/13
Company 2 15/04/13
Company 3 13/04/13
Company 3 14/04/13
Company 3 14/04/13
Company 3 15/04/13
....
and I would like to report the dates in another tab with a formula:
Expected result:
Company Date
Company 1 13/04/13
Company 1 14/04/13
Company 1 15/04/13
Company 2 13/04/13
Company 2 14/04/13
Company 2 15/04/13
Company 3 13/04/13
Company 3 14/04/13
Company 3 15/04/13
Can anyone help me with this?
Many thanks.
Jack Green
I have the following issue:
I have a tab with 2 columns:
Company Date
Company 1 13/04/13
Company 1 13/04/13
Company 1 13/04/13
Company 1 14/04/13
Company 1 14/04/13
Company 1 15/04/13
Company 1 15/04/13
Company 2 13/04/13
Company 2 13/04/13
Company 2 14/04/13
Company 2 14/04/13
Company 2 15/04/13
Company 3 13/04/13
Company 3 14/04/13
Company 3 14/04/13
Company 3 15/04/13
....
and I would like to report the dates in another tab with a formula:
Expected result:
Company Date
Company 1 13/04/13
Company 1 14/04/13
Company 1 15/04/13
Company 2 13/04/13
Company 2 14/04/13
Company 2 15/04/13
Company 3 13/04/13
Company 3 14/04/13
Company 3 15/04/13
Can anyone help me with this?
Many thanks.
Jack Green