Results 1 to 11 of 11

Search/display a specific date from a seperate worksheet

Threaded View

dave57 Search/display a specific... 05-31-2017, 08:27 AM
dave57 Re: Search/display a specific... 05-31-2017, 08:57 AM
dflak Re: Search/display a specific... 05-31-2017, 09:41 AM
dave57 Re: Search/display a specific... 05-31-2017, 10:15 AM
dflak Re: Search/display a specific... 05-31-2017, 10:08 AM
dave57 Re: Search/display a specific... 05-31-2017, 10:16 AM
dflak Re: Search/display a specific... 05-31-2017, 10:18 AM
dave57 Re: Search/display a specific... 05-31-2017, 10:54 AM
dave57 Re: Search/display a specific... 06-01-2017, 06:49 AM
dave57 Re: Search/display a specific... 06-01-2017, 06:35 AM
avk Re: Search/display a specific... 06-01-2017, 07:45 AM
  1. #9
    Registered User
    Join Date
    05-23-2017
    Location
    North Carolina
    MS-Off Ver
    2010
    Posts
    25

    Re: Search/display a specific date from a seperate worksheet

    When I change it to IF(AND(, I get a #VALUE! result.....
    =IF(AND(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY, HH:MM:SS"), IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY, HH:MM:SS"),"MM/DD/YYYY HH:MM:SS","NONE"))
    I am trying to get Excel to return the Training #, Date, Time of the assigned training.
    Last edited by dave57; 06-01-2017 at 07:00 AM.

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: 06-28-2014, 08:08 AM
  2. Search for specific date range, copy entire row and paste to new worksheet
    By turias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2013, 03:57 PM
  3. Replies: 4
    Last Post: 03-21-2013, 10:02 AM
  4. Macro to overwrite a specific row in a seperate worksheet
    By Tradesman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2013, 05:34 AM
  5. How to search multiple worksheets and put results in a seperate worksheet.
    By bmsjeff in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2010, 09:45 PM
  6. Macro to pull specific data out and place in a seperate worksheet
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2008, 04:02 AM
  7. Calling a specific worksheet from a hyperlink in a seperate file.
    By TheChris in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2006, 09:48 PM

Tags for this Thread

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