Formula to report dates in a new tab

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
 
C

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top