+ Reply to Thread
Results 1 to 3 of 3

Excel Formula Needed Please

  1. #1
    Registered User
    Join Date
    01-03-2008
    Posts
    5

    Excel Formula Needed Please

    I made an example sheet:
    \1

    I have a list of over 1000 "Cusip" Numbers that have a price and a price source for about 60 days. The prices for the Cusips may change every day, and the source of the price may change as well. I'm looking for a formula that will spit out how often each Cusip changes sources.

    In the example above:
    Cusip 1 uses the same source for all four days -> 0 switches
    Cusip 2 changes from source A to B on the 1/2/99 and stays with source B from then on -> 1 switch
    Cusip 3 changes from A to B and then from B to A -> 2 switches
    Cusip 4 changes from A to C, from C to B, and from B to A -> 3 switches

    Thanks!
    Last edited by Methix; 08-07-2008 at 02:52 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try this formula in K3 copied down

    =(C3<>E3)+(E3<>G3)+(G3<>I3)

  3. #3
    Registered User
    Join Date
    01-03-2008
    Posts
    5
    sorry about that
    http://www.mrexcel.com/forum/showthread.php?t=335005

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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