Google Sheets: Get First Value in Column
I need to find the first value in a column range. I've previously had help to find the last value in a column range, such as:
=INDEX(E4:E188, MATCH(999^99, (E4:E188)))
However I haven't figured out how to convert the above formula to return the first value instead. Any suggestions would be appreciated.
Solution
Although I'm not sure whether I could correctly understand your expected result, how about the following sample formula?
Sample formula:
=INDEX(FILTER(E4:E188,E4:E188),1)
Testing:
Reference
- ARRAYFORMULA Auto-Increment
- How can I drag and count data from a different spreadsheet without helper columns or sheets?
- Incrementing in formulas 1/n, 2/n, ... n/n
- Convert Dates into 3‑Letter Month for Rows, Year for Columns, and Sum Sales
- How to format a duration as HH:mm?
- Query fails with SELECT A, SUM(B) + SUM(C) GROUP BY A
- identify duplicates across multiple columns with completeness rules
- Get the last non-blank value in a row in Google Sheets
- How do you get the formula from a cell instead of the value?
- How to extract URL from Link in Google Sheets using a formula?
- Database Rows to static columns
- formula(s) to add "page breaks" to Google Sheets or x number of rows dynamically
- use ISFORMULA with ARRAYFORMULA on a range of cells
- Search for Value and Return All Columns In Which Value Appears
- Google Sheets: Get First Value in Column
- In sheet one, pull sheet two's cell values by using sheet one's cell values as variables?
- Match Value based on corresponding dates
- Formula to Display Each Multi-Select Value in Google Sheets Dropdown on a Separate Line
- Google sheets setting columns range in app script
- VLOOKUP IMPORTRANGE to select the column number in another file also
- Data validation for time input in Google Sheets
- Is there a formula to expand data to multiple rows per entry?
- How do I format a Google Sheets duration formatted cell to show days, hours and minutes in a human readable format?
- How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
- Add empty row in an array, each time the content of a given column is different
- Filtering multiple columns in Google Sheets without blanks
- Find row when Cumulative sum reaches certain value with condition
- Reduce number of characters in stacked Google spreadsheet query functions
- In Sheets returing a value from different tables based on multiple criteria
- Closing balance per currency from a transaction log?