Formula to report dates in a new tab

[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

 

[Claus Busch]

Hi Jack,

Am Sun, 12 May 2013 13:03:00 -0700 (PDT) schrieb JackGreen:

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

Select the new sheet => Data => Advanced Filter => Copy to another
location => List range = Tab1 your range => copy to New sheet A1 => [x]
unique records only


Regards
Claus Busch

 

[JackGreen]

Hi Claus,

In my case I need to do it with a formula.
Is that possible?

Many thanks,

Jack
Green

Hi Jack,



Am Sun, 12 May 2013 13:03:00 -0700 (PDT) schrieb JackGreen:

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

Select the new sheet => Data => Advanced Filter => Copy to another

location => List range = Tab1 your range => copy to New sheet A1 => [x]

unique records only





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2