+ Reply to Thread
Results 1 to 4 of 4

Need Help in Excel Timestrap Programming

  1. #1
    Registered User
    Join Date
    08-23-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    10

    Need Help in Excel Timestrap Programming

    Hello,

    Everyday i get excel sheet in which i have to filter out the two readings of one unique IP (One Time is = 6 am reading and another one is of 6 pm and fill all the value of that row in the another sheet according to its IP address). If no record is present of that time then i have to fill nearby time record for eg. last reading is 4 pm then i have to fill that 4 pm record. Can anybody help me in this ?

    I have attached a sample sheet. Sheet1 contains all records and in sheet2 i have to fill data. Please find it.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Need Help in Excel Timestrap Programming

    It would be best if, when you post an example sheet, you include the desired results. You should fill in sheet2 with the desired results, based on the data in sheet1, so we can get a better idea of what you are asking for.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Need Help in Excel Timestrap Programming

    This works IF the data you're sampling (Sheet1) contains only data from a single date.

    So in my example the IPs from the 21st are correct, but the 22nd are not. Separate your data sets and it should work.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-23-2015
    Location
    India
    MS-Off Ver
    MS Office 2007
    Posts
    10

    Re: Need Help in Excel Timestrap Programming

    Thanks for your help

+ 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. New to VBA Programming for Excel
    By gmr4evr1 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-24-2014, 08:04 PM
  2. Replies: 1
    Last Post: 08-20-2012, 01:13 PM
  3. New Excel Programming
    By kartik.kumar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2011, 01:19 PM
  4. TRY Excel Programming
    By Mt1013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2010, 01:37 AM
  5. ADO programming in Excel-VBA
    By CLamar in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 09:50 AM
  6. [SOLVED] I am new to excel programming, can you help please?
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2006, 08:55 AM
  7. Excel Vba Programming
    By kamakshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2005, 11:05 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