+ Reply to Thread
Results 1 to 4 of 4

pull only current data from form

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    ithaca,ny
    MS-Off Ver
    google docs
    Posts
    18

    pull only current data from form

    Hello,

    I have a form that time and date codes all the responses from 13 users, I am then pulling those responses and placing them into another pages array.

    The question is, if the form responses page has the following:
    A B C
    1| Timestamp User Users Text
    2| 4/28/2014 15:09:50 1504 test-Test
    3| 4/28/2014 15:48:22 1524 test-text

    How do I only pull the most resent date for each user?

    thanks

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: pull only current data from form

    Hi,

    Can you please upload a sample template of your workbook here?

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    ithaca,ny
    MS-Off Ver
    google docs
    Posts
    18

    Post Re: pull only current data from form

    161 internal.xlsx

    So the idea is to take the most current data for each STORE from the "form response" page and list the notes and MTD sales on the master page.

    The form Response page is continually getting reply from many locations at different times, but would like it to only pull the last entry "Sales MTD and Notes" for each store.

    thanks

    FYI any data already in sheet was me experimenting trying to get it to work.
    Last edited by ithacarob; 04-29-2014 at 12:11 PM.

  4. #4
    Registered User
    Join Date
    04-24-2013
    Location
    ithaca,ny
    MS-Off Ver
    google docs
    Posts
    18

    Re: pull only current data from form

    FYI, updated the workbook here-
    https://docs.google.com/spreadsheets...#gid=377880015

    I got the function, lookup to work in excel, but not in Google docs.

    Have used an Arrayfuction in another workbook but not familiar with fuction to know how to get it to work in a new formula.

    Please, please help, and many thanks, have a deadline to try and get this working.

+ 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. Replies: 1
    Last Post: 08-28-2013, 05:04 PM
  2. Pull Current Month's Data Out of List - Repost
    By Karl Burrows in forum Excel General
    Replies: 5
    Last Post: 05-05-2005, 12:06 PM
  3. [SOLVED] Pull Current Month's Data Out of List - Repost
    By Karl Burrows in forum Excel General
    Replies: 4
    Last Post: 05-02-2005, 09:06 PM
  4. [SOLVED] Pull Current Month's Data Out of List - Repost
    By Karl Burrows in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2005, 09:06 PM
  5. Pull Current Month's Data Out of List
    By Karl Burrows in forum Excel General
    Replies: 2
    Last Post: 04-24-2005, 06:06 PM

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