=INDEX(B2:D2,MATCH(FALSE,ISBLANK(B2:D2),FALSE))
This is an Array Formula. After entering the formula, press CTRL + Shift + Enter to have Excel evaluate it as an Array Formula. This returns the first nonblank value of the given range of cells. For your example, the formula is entered in the column with the header “a”
A B C D 1 x x y z 2 y y 3 z z
Related Posts:
- How to run a SQL query on an Excel table?
- What is the difference between UNION and UNION ALL?
- Selecting COUNT(*) with DISTINCT
- ORA-00904: invalid identifier
- Unknown column in ‘field list’ error on MySQL Update query
- When should I use CROSS APPLY over INNER JOIN?
- Insert Data Into Temp Table with Query
- How to create Temp table with SELECT * INTO tempTable FROM CTE Query
- SQL SELECT WHERE field contains words
- Using group by on multiple columns
- Efficiently convert rows to columns in sql server
- Nested select statement in SQL Server
- What’s the difference between VARCHAR and CHAR?
- How to split the name string in mysql?
- How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
- Sql Server equivalent of a COUNTIF aggregate function
- Column name or number of supplied values does not match table definition
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- Simple PHP Pagination script
- SQL Server FOR EACH Loop
- ORA-12560: TNS:protocol adaptor error
- How can I select the first day of a month in SQL?
- Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
- SQL – HAVING vs. WHERE
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- Oracle Apex column link from LOV values
- What’s the difference between RANK() and DENSE_RANK() functions in oracle?
- When to use “ON UPDATE CASCADE”
- MySQL combine two columns into one column
- How to SUM two fields within an SQL query
- DateTime2 vs DateTime in SQL Server
- ORA-01861: literal does not match format string
- Difference between numeric, float and decimal in SQL Server
- SQL Server Insert if not exists
- SQL Server: Invalid Column Name
- “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
- ERROR: there is no unique constraint matching given keys for referenced table “bar”
- How do I query for all dates greater than a certain date in SQL Server?
- String or binary data would be truncated. The statement has been terminated
- Error converting data type varchar to float
- How to concatenate text from multiple rows into a single text string in SQL Server
- Remove duplicate rows in MySQL
- Cast from VARCHAR to INT – MySQL
- Conversion failed when converting the varchar value ‘simple, ‘ to data type int
- postgresql: error duplicate key value violates unique constraint
- Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- “You tried to execute a query that does not include the specified aggregate function”
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- Convert timestamp to date in Oracle SQL
- How do I reset a sequence in Oracle?
- MySQL error: key specification without a key length
- SQL: Two select statements in one query
- Update statement with inner join on Oracle
- Check if MySQL table exists without using “select from” syntax?
- mysql update column with value from another table
- Can I use multiple “with”?
- SQL Server dynamic PIVOT query?
- Incorrect syntax near ”
- MySQL: Can’t create table (errno: 150)
- Join vs. sub-query
- Alternative to except in MySQL
- What does Include() do in LINQ?
- SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
- Get everything after and before certain character in SQL Server
- LEFT function in Oracle
- What are database constraints?
- Postgresql column reference “id” is ambiguous
- Inner Joining three tables
- How do I view the Explain Plan in Oracle Sql developer?
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- SUM OVER PARTITION BY
- SQLite string contains other string query
- Varchar invalid for Sum operator
- SQL: How to properly check if a record exists
- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
- Sorting search results by taxonomy terms
- SQL select of users by metadata
- How to properly sanitize strings without $wpdb->prepare?
- WordPress SQL LIKE request doesn’t work for fields with special symbols
- posts_where Fails with More than One Custom Field in Query
- WordPress database error: You have an error in your SQL syntax
- Restose content from revisions – sql query
- Better way to migrate to server?
- Inner Join user tables to select users with roles
- $wpdb->prepare with LIKE returning blank array instead of rows
- Removing posts by sql
- Why line returns are not reapply after doing esc_sql?
- WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
- WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
- Help me SELECT thumbnail from SQL and use
- Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
- Search results sort order failing: set by date only
- Creating a “forum” – showing last post or last commented post
- Replace Unwanted Space in Post Content URL
- SQL to transform all email addresses in my DB in lowercase [closed]
- How to write inner join using posts_clauses?
- This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1