Looking to return a row cell (date) from an INDEX look up of 2nd last entry in a ROW
Title probably not a good description but can anyone help please?
I have rows of players with columns of dates they could possibly have scored a goal in. Column A returns the number of goals scored the last time they did but I am looking to match that entry with the date they last scored on either in in Column B
Sample sheet link below. Looking for Column B to be automated to return the entry manually entered in B3,4 examples.
https://docs.google.com/spreadsheets/d/1yYJf3iQU43uWc2cEjJhVm1TQ1NB_VbYrETgLX6ka1H4/edit?usp=sharing
Thanks in advance, possibly a simple solution, but I cannot see it.
Solution
You may try:
=byrow(E3:U,lambda(Σ,if(counta(Σ)=0,,choosecols(filter(E2:U2,Σ<>""),-1))))
If the dates are ever-expanding & the formula needs to pick 2nd last entry(skip the Grand Total value)
=byrow(indirect("E3:"&rows(A:A)),lambda(Σ,if(counta(Σ)=0,,choosecols(filter(E2:2,Σ<>""),-2))))
- Using a gs function with an input from a selection in html on appscript
- Generate unique random numbers in Google Sheets
- How to prevent the SPLIT function from converting text to non-text in Google Sheets
- Google Sheets: Number Format option of horizontal axis labels in a histogram
- Google apps script Selecting sheets from dynamic menu in google sheets
- DSum mistake in choosing the right database records with multiple criteria in 3 fields
- Create grouping "bands" for rows with the same details, Google Sheets
- Sidebar To Show/Hide Sheet With Apps Script
- Exception: Unexpected error while getting the method or property openById on object DocumentApp while trying to open Google doc file
- Question on conditional formatting from another sheet using "VlookUP","Year","IFerror"
- Creating Nested List with Google Sheet Formulas from Pre-Made Tables
- Why can't an onEdit checkbox click trigger an import in Google Apps Script?
- Index Match Search Field with multiple rows in google sheets
- Make onEdit() recognize setValue() changes
- COUNTIF not working with string "True" or "False"
- Highlight row using conditional formatting if duplicate in two different columns of same row in Google Sheets
- Looking to return a row cell (date) from an INDEX look up of 2nd last entry in a ROW
- Extracting data in Excel inside Google Drive using App Script
- Fetching Rich Text Data From Google Sheets
- How to count exact text string matches when there is a partial text string overlap, such as counting both pills and pillaged pills but not pillaged
- Log users visiting a Google Spreadsheet
- Highlight overlapping time in Google sheet for a range of data with Start and End Time in Columns
- Google Apps Script MailApp change Sender Name
- Shade a specific tab if a value on that tab is equal to a value
- Google Sheets adding a date in the array used for multiple criterion
- Link a row number to another reference
- How to List All Combinations of Values from Two Semicolon-Separated Columns in Excel/Sheets?
- In a callable function to create a line chart I need to conditionally change the axis and line width of a series for which the series number can vary
- How to populate a Google Sheet cell with multiple values from data passed from HTML webpage to App Script
- IMPORTRANGE with REGEXREPLACE/REGEXMATCH function