1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel Vlookup and Counting Entries

Discussion in 'Business Applications' started by Logit, Jul 1, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Logit

    Logit Thread Starter

    Joined:
    Nov 20, 2005
    Messages:
    41
    I am using Excel 2007

    I have a .csv file that can be dropped into Excel (see attached - "January Example for Email"). Look at column "F - Study Date Time". I need to auto populate that column of information, separated by total number of entries for a particular hour, into a second spreadsheet (see attached - "CT Exam Hourly Matrix").

    Looking at "January Example for Email", column "F", the first entry is "1/1/2012 1:24". On that date, from the 1:00 - 2:00 hour (using 24 hr military time), there is one (1) entry to autopopulate into "CT Exam Hourly Matrix" B:3. The second entry in "January Example for Email", column "F" is "1/1/2012 10:43". So there is one (1) entry to autopopulate into "CT Exam Hourly Matrix" B:12.

    Column/Row F:19 & 20 in "January Example for Email" has two (2) entries for that hour to be autopopulated into "CT Exam Hourly Matrix" C:18.

    Therefore, the total number of entries for a specific hour will be tallied (sum) and transferred to the second spreadsheet in the appropriate column & row.

    Is there a means to automate this process using only Excel or VBA or ??? I apologize for being completely Excel "challenged" and would be most grateful for your assistance. I have no idea what I am doing or how to do it. This is strictly a job related / personal need project to make my daily life sane again.
     

    Attached Files:

  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Why the duplicate post?
     
  3. Logit

    Logit Thread Starter

    Joined:
    Nov 20, 2005
    Messages:
    41
    Should I have edited the first with the indication of "VLOOKUP" ?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1059336