How do I achieve a specific result concatenated with commas (ACT1, ACT2) from a filtered text ("Not delivered") and referenced from the position of the columns:
Google-sheets – Get an item value from a column item concatenated
concatenategoogle sheets
Related Solutions
I think this will do what you want. For example if your columns are A to D,
=iferror(match("Account Balance",A1:D1,0),"No match")
returns the column number or an error message.
Thanks for pointing out that function list. It will come in handy.
Seems to work for me:
Your formula is in K4. Maybe the first part of what you are concatenating has to be a valid address itself?
Related Topic
- Google-sheets – Make cell height in one column not affect other columns within the same row in Google Spreadsheets
- Google Sheets – Link to a Filtered View Based on Params
- Google Sheets Query – How to Fix Query Returning a Single Concatenated String
- Google-sheets – Fill a column with consecutive numbers concatenated with a letter
- Google Sheets – Return Value from Column if Multiple Criteria are Met
- Google-sheets – Consolidate columns from a dynamic range into a single column in Google Sheets
Best Answer
Assuming the coloured row is Row1, please try in G2 and copied down to suit: