+ Reply to Thread
Results 1 to 6 of 6

Events that happen in certain time window

  1. #1
    Registered User
    Join Date
    01-10-2015
    Location
    Top of the world
    MS-Off Ver
    2013
    Posts
    4

    Events that happen in certain time window

    I have a data of about 4,000 corporate acquisitions, name of the acquirer and their announcement dates. I need to narrow this sample down to acquisitions that have been made by certain acquiring company during a 3 year time window. What is the easiest way to do this? To make matters more difficult, the dates are not in date format, but in a custom format, for example 20.04.93 etc.

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    12-23-2013
    Location
    Gurgaon
    MS-Off Ver
    Excel 2013
    Posts
    36

    Re: Events that happen in certain time window

    Hi Bernie Madoff,

    You can create a pivot of your data and filter as per requirement. Please give some sample data in excel file so that I can help you in a better way
    Maitray,

  3. #3
    Registered User
    Join Date
    01-10-2015
    Location
    Top of the world
    MS-Off Ver
    2013
    Posts
    4

    Re: Events that happen in certain time window

    I attached example with 2 companies. In this case I would need to be able to exclude the acquisitions made by Acal PLC, because the company hasn't made 5 or more acquisitions during a 3 year time window, but I would need to keep companies like 365 Corp PLC in the sample because they have.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-29-2014
    Location
    udaipur, rajasthan
    MS-Off Ver
    2007
    Posts
    352

    Re: Events that happen in certain time window

    Hi,

    Something like this? or can you please show your result manualy..if possible?
    Attached Files Attached Files
    If answer helped you say Thanks by Add Reputation

  5. #5
    Registered User
    Join Date
    01-10-2015
    Location
    Top of the world
    MS-Off Ver
    2013
    Posts
    4

    Re: Events that happen in certain time window

    Thats not quite it, as I have quite a big sample with over 450 acquiring companies. What I would like my end result to look like is a list with only those companies and acquisitions that fit the following criteria:
    1. Acquisitions are made by the same company
    2. There are at least 5 or more acquisitions...
    3. During a 3 year time window

    I.e in the sample I posted, I need to somehow remove companies like Acal PLC from the list, while keeping companies like 365 Corp PLC. Unfortunately I can't post the whole list because I don't own the rights publish it.

  6. #6
    Registered User
    Join Date
    01-10-2015
    Location
    Top of the world
    MS-Off Ver
    2013
    Posts
    4

    Re: Events that happen in certain time window

    Here is an example of what I mean, hope it illustrates the description a little better.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Time and Date Lookup & Summation when Different Events happen.
    By taco_0324 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2014, 07:35 PM
  2. [SOLVED] Amnesty for illegal immigrants will not happen this time.....................
    By Expert Humor in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-31-2006, 01:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1