1. T

    help building an expression

    Hi! I need help building an expression for a field in a query I'm designing. I have columns of dates and types of reviews. Example: SiteID SiteDate Purpose 03500000 05/09/13 Initial Full Scope 03500000 08/17/15 Periodic Full Scope 03500001 05/09/13 Initial Full...
  2. K

    Calculate Cumulative Return from Periodic Returns not in Percentage Format

    I have a column of numbers representing periodic returns (but expressed without the %): 1.31 0.21 -0.33 I want to calculate a cumulative return of the "% changes" above (the answer is 1.1877% in this simplified case), but with some restrictions that make this hard for me to figure out: I'd...
  3. D

    How to identify a period of defined monthly performance

    Hi Everyone, I'm using Excel 2007 on Windows 7 I'm not sure how to best describe this with the appropriate terminology. I appreciate the patience of you experts. I have a range of monthly performance for a benchmark and my portfolio. I am looking to identify periods where I can set the...
  4. Y

    Periodic Macro

    Hi there, I'm wanting to have a macro that will run on a certain day of the week, every week. How can i do this?
  5. A

    Intermittent Forecasting

    This is a unique problem I have never encountered and I wanted to see if I could get some thoughts. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on 5-year monthly projections in a clinical trial environment. Each trial will have different...
  6. N

    working out the frequency of a periodic function

    Hi i have some data that shows a sawtooth like periodic shape with time.Column a is the time, hh:mm:ss.00, column b is the data, with one point every second. The data increases for about a minute, then drops back to its original value I would like to work out the frequency of this sawtooth...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...