Results 1 to 4 of 4

Match names and dates from source data

Threaded View

  1. 11-07-2013, 05:55 AM #1
    razaas
    razaas is offline
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2010
    Posts
    59

    Match names and dates from source data

    Please review the attached file and I need help, "ISNUMBER, MATCH, OFFSET" formula working fine on attached file but as an improvement I am trying to export calendar from share point to my data input (sheet1, row 28 onwards). The exported dates have time included, therefore need help to alter the existing formula. This was originally posted on http://chandoo.org/forum/threads/mat...ce-data.12287/ but no response yet so any help from this forum is appreciated.
    Attached Files Attached Files
    Last edited by razaas; 11-10-2013 at 02:05 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Match dates and names
    By bigband1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2013, 10:36 AM
  2. Match dates and names on different sheets and colour cells
    By ExCelNoob_ in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2010, 03:56 AM
  3. relative names as source data
    By pete_22 in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 05-13-2008, 11:26 AM
  4. Round to match source data precision
    By Hammer_757 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2006, 11:03 AM
  5. [SOLVED] How do I view Pivot Table source data file and field names?
    By chocolate2346 in forum Excel General
    Replies: 4
    Last Post: 09-14-2005, 02: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1