+ Reply to Thread
Results 1 to 4 of 4

index match to show in date order

  1. 06-26-2015, 12:37 PM #1
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    index match to show in date order

    I am struggling to display invoice data in a graphic type display. In attached workbook I have formula to pick up data in the order I want. What I am struggling with is I need the instances for each vehicle in date order to appear below each other. I have entered the second line of data manually just to complete the exercise. In the graphic all entries on sheet "INVOICES" with position F1/2 will appear in top part and R1/2/3/4 in the lower part. Front and rear tyres.

    Any help or suggestions appreciated
    Attached Files Attached Files
    Last edited by nigelog; 06-29-2015 at 09:39 AM.
    Reply With QuoteRegister To Reply
  2. 06-26-2015, 02:08 PM #2
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: index match to show in date order

    Does this do what you want?
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  3. 06-29-2015, 09:39 AM #3
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: index match to show in date order

    Perfect was able to manipulate to suit all tyre types. Many thanks. Will mark as solved.
    Reply With QuoteRegister To Reply
  4. 06-29-2015, 10:03 AM #4
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: index match to show in date order

    Glad it worked out. Thanks for the rep too.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Sum, index, match two columns and put into ascending order
    By SteelMaster in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-23-2014, 03:09 PM
  2. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  3. Lookup or Index(match) function not in ascending order and not an exact match
    By Tobias1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  4. Index Match: Show blank instead of #NA for no match
    By cedarhill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2011, 03:21 PM
  5. Index/Match Left/Right With inconsistent string length/order
    By Alabaster in forum Excel General
    Replies: 2
    Last Post: 10-23-2010, 04:54 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