Results 1 to 8 of 8

Last 5 Results (footie)

Threaded View

  1. 11-21-2016, 07:20 AM #1
    Patcheen
    Patcheen is offline
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Last 5 Results (footie)

    How to find last 5 results

    i have 2 criteria s in 2 columns

    in G5:G500 (Won, Lost, Drew) in H5:H500 (Home, Away)

    im trying to get the last 5 results

    Example Home - Won (3) Drew (2) Lost (0) (See Pic)

    in R6 i want 3

    in S6 i want 2

    in T6 i want 0

    is this possible?
    Attached Images Attached Images
    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. Sumifs giving strange results but when saved the results seemd to be normal partly
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-07-2016, 11:28 AM
  2. Sort Query Results to remove duplicate entries and put results on one line.
    By Panther70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2015, 03:03 PM
  3. Extracting multiple results populated from changing dropdown list to compare results
    By XLamature in forum Excel General
    Replies: 3
    Last Post: 10-30-2013, 09:18 AM
  4. [SOLVED] Unable to display mail merge results using Preview Results function
    By trandle in forum Word Formatting & General
    Replies: 1
    Last Post: 05-30-2012, 12:29 AM
  5. Format results of a data table that displays multiple results in each cell - Help!
    By Slotin in forum Excel General
    Replies: 2
    Last Post: 02-03-2012, 12:13 PM
  6. Excel 2007 : Help with footie tourney...
    By KatieBob in forum Excel General
    Replies: 1
    Last Post: 08-17-2010, 10:25 AM
  7. Excel 2007 : Need to filter results, add results and group the results in Excel 2007
    By bpatters69 in forum Excel General
    Replies: 3
    Last Post: 03-31-2010, 11:47 AM

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