Search code examples
Split text string in Excel by semicolons and space...


excelvbaexcel-formula

Read More
Formula in Excel to count occurrences of substrings within strings...


excelexcel-formula

Read More
How to write formulas in openpyxl in german excel version...


pythonexcelexcel-formulaopenpyxl

Read More
Excel - Return value based in two conditions...


excelexcel-formula

Read More
Excel - Display entry with the highest value that meets a case-sensitive condition...


excel-formula

Read More
How to sum multiple columns with multiple conditions...


excelexcel-formula

Read More
MATCH formula with multiple conditions returning true when false...


if-statementexcel-formula

Read More
Finding the closest date in Excel...


excel-formula

Read More
Is there a way to find first non zero value for a lookup value in excel...


excelexcel-formulams-office

Read More
Excel: preserve hyperlink to the cell in the current sheet after copying the sheet...


excelexcel-formulahyperlink

Read More
Indexing folder content by alphabetical order in Excel...


excelexcel-formula

Read More
Best way to offset the target reference of another cell?...


excelexcel-formula

Read More
SUM of 2-way Weighted Grid in Excel...


excelexcel-formula

Read More
How to consume data of 1 column based on other column...


excelexcel-formula

Read More
How to match large data on excel based on some criteria?...


excelexcel-formula

Read More
EXCEL Search of multiple possible strings of text...


excel-formula

Read More
VLOOKUP Returns 0 even though there is a value in the line below the first result...


excelexcel-formulavlookup

Read More
transpose a table with multiple values in excel...


excelexcel-formulapivottranspose

Read More
Apply FILTER formula to array (and use filter criteria on specific column in the array)...


excelexcel-formula

Read More
Excel function to construct an array from values without VBA...


excelvbalambdaexcel-formuladynamic-arrays

Read More
EXCEL: How do I return multiple columns using XLOOKUP, when the lookup_value is a range?...


excelexcel-formula

Read More
Filtering an Array (not Range) based on a SUM of CHOOSECOLS applied to it...


excelexcel-formula

Read More
Add rows to table produced with filter function based on additional argument...


excelexcel-formula

Read More
Assign week numbers to dates based on multiple conditions in excel...


excel-formulaweek-numberweekday

Read More
Epoch Unix Value formula...


excelexcel-formula

Read More
SORT formula with empy column in data range and descending order based on another column (not the fi...


excelexcel-formula

Read More
Update the nth element of an array on Excel using formulas...


excelexcel-formula

Read More
Is there a way to Indirectly call an array of Table names?...


excel-formula

Read More
Power Query Dynamic Column Reference...


excelexcel-formulapowerqueryexcel-365

Read More
Excel(VBA) Formula in added column needing logical workaround...


excelvbaexcel-formula

Read More
BackNext