Results 1 to 15 of 15

Count last 3 results only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    118

    Count last 3 results only

    I have a table of results and would like to check the last 3 known positions across a row of data excluding a few columns and provide an answer on the results if finishing in 1st or 2nd place.

    Sample spreadsheet enclosed

    Answer / formula required in column "Q"
    Look for the last 3 results in each row counting backwards and excluding columns "H" and "P"
    and if either a 1st or 2nd place then show "0" any result which is 3 or higher in last 3 results then show "1"

    Thanks in anticipation.

    Junada0
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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