Search code examples
OR function not working with arrayformula in Google Sheets...


google-sheets-formulaarray-formulas

Read More
How to count a specific word from a string in a cell from the entire column in google sheets...


google-sheetsarray-formulascountif

Read More
Google Sheets ARRAYFORMULA with Partial Match and Multiple Criteria Not Returning Expected Results...


google-sheets-formulamatchvlookuparray-formulaspartial-matches

Read More
How do I set up a formula that matches columns between two sheets, while returning blank values for ...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
How to update excel formula to work for all columns continuously to the right and not just the curre...


google-sheetsexcel-formulaarray-formulascounting

Read More
Formula not working when parsing set a dynamic range in Google spreadsheet formula ARRAYFORMULA...


google-sheetsarray-formulas

Read More
Combine two columns that's are on a column "B" and column "C" and then make ...


google-sheetsgoogle-sheets-formulaformulaspreadsheetarray-formulas

Read More
Arrayformula with Query in Google Sheets...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
What is an equivalent for INDEX in ARRAYFORMULA?...


google-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Find the position of a cell by sub-string based on another range in an array (Google Sheets formula)...


google-sheetsarray-formulas

Read More
Collapsing Wide Data into Tall Data in Google Sheets...


google-sheetsformulaarray-formulasgoogle-forms

Read More
Remove diacritics via formula on Google Sheets (Part 2)...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Get the exact value in array...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Find Latest Revision and Return Hyperlink using a Column to Search...


excelexcel-formulaarray-formulas

Read More
How to set cell color based in duplicated value in column with different colours for each values...


google-sheetsgoogle-sheets-formulaarray-formulasgs-conditional-formattinggs-vlookup

Read More
Arrayformula with IFS function didn't expand the output result in a column...


google-sheets-formulaarray-formulas

Read More
Getting the count and unique values of a column of comma separated values?...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Copy value from a cell to the rest of a colum...


google-sheetsarray-formulas

Read More
Google Sheets - Difference of Two Columns With Duplicate Values...


google-sheetsgoogle-sheets-formulaspreadsheetarray-formulas

Read More
I have a problem with removed records in Excel using Openpyxl...


pythonexcelopenpyxlarray-formulas

Read More
Using arrayformula to add suffix, but would like to skip empty cells...


regexif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Arrayformula to SUM matching ID AND when date is between two dates...


google-sheetssumgoogle-sheets-formulaarray-formulas

Read More
How to use arrayformula with a query that groups and sums a certain column in googlesheets...


google-sheetsarray-formulas

Read More
How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?...


algorithmgoogle-sheetsstatisticsgoogle-sheets-formulaarray-formulas

Read More
ARRAYFORMULA option for checking for cell values on each row of Google Sheet...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
How do I use INDIRECT inside an Excel array formula?...


excelarray-formulasexcel-indirect

Read More
I have a dataset of team members reserving one ( or more) of five rooms. I need a function that can ...


google-sheetsarray-formulasindex-match

Read More
I want to automatically populate a calendar sheet with scheduled meetings as team members select dat...


google-sheetsarray-formulasindex-match

Read More
Google Sheets Query - build referenced array source dynamically...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Compare row of three ETFs (text) to previous row of three ETFs (text) for changes. Order not counted...


google-sheetstextmatcharray-formulascountif

Read More
BackNext