Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    HOW TO Develop a VBA code and thus identify the missing periods of data.
    • Section Leader
    Offline

    21
    ReputationRep:
    Section Leader
    (Original post by Elixirman)
    HOW TO Develop a VBA code and thus identify the missing periods of data.
    Moved to the CompSci study help forum

    You will need to give a bit more information about your problem. What have you tried so far?

    Posted from TSR Mobile
    Offline

    5
    ReputationRep:
    1) Enable Developer Mode
    2) Add a button and a macro
    3) Write the code for the macro, where you go through the integrity of your data range in a loop.
    4) For looking for missing periods, first find the pattern, then code this pattern into the loop, then check if each cell conforms to this pattern.

    https://www.excelforum.com/excel-pro...ng-vba-macros/
    and google are your friends (prefix "excel vba" with your search term)
    • Thread Starter
    Offline

    2
    ReputationRep:
    File sample attached below. the function should be applied to the tetra sec count in 4s on the tetra sec value.
    Attached Images
     
    • Thread Starter
    Offline

    2
    ReputationRep:
    Rows are about 668813....
    • Section Leader
    Offline

    21
    ReputationRep:
    Section Leader
    (Original post by Elixirman)
    Rows are about 668813....
    So maybe post up your code so far.

    Posted from TSR Mobile
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: February 18, 2018

University open days

  1. University of Bradford
    University-wide Postgraduate
    Wed, 25 Jul '18
  2. University of Buckingham
    Psychology Taster Tutorial Undergraduate
    Wed, 25 Jul '18
  3. Bournemouth University
    Clearing Campus Visit Undergraduate
    Wed, 1 Aug '18
Poll
How are you feeling in the run-up to Results Day 2018?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.