Results 1 to 4 of 4

Yearly cell count of a certain value

Threaded View

Hidai Yearly cell count of a... 01-10-2011, 03:17 PM
NBVC Re: Yearly cell count of a... 01-10-2011, 04:15 PM
Hidai Re: Yearly cell count of a... 01-10-2011, 04:48 PM
NBVC Re: Yearly cell count of a... 01-10-2011, 04:54 PM
  1. #1
    Registered User
    Join Date
    12-28-2010
    Location
    Tel-Aviv, Israel
    MS-Off Ver
    Excel 2007
    Posts
    29

    Yearly cell count of a certain value

    Hi,

    I've got a file in which i have several years of 30 minutes daily data on which I calculated the percentage change of every 30 minutes( column H) relatively to the previous day's close price (column G). If I want to count how many times a certain percentage( e.g +1% or above) change occurred in a certain year but in different days of course how would I do that?
    Attached you'll find the file.

    Thx in advance,

    Hidai
    Attached Files Attached Files

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