Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in excel-formula
Excel VBA - Loop through range and set formula in each cell
Jun 27, 2026
excel
excel-formula
vba
Sumproduct with 5 criterias from another workbook takes too long to run
Jun 27, 2026
excel
optimization
excel-formula
find longest string in with criteria - excel
Jun 27, 2026
excel
excel-formula
Custom Function using a Sheet name as a parameter
Jun 26, 2026
vba
excel
excel-2007
excel-formula
excel-2010
Using a LAMBDA as the 2nd argument to FILTER
Jun 26, 2026
excel
excel-formula
office365
Excel Lambdas (GROUPBY and PIVOTBY) - Providing a vector of lambdas in function arguments
Jun 25, 2026
excel
excel-formula
lambda
group-by
pivot
Make an equivalent to Excel's =PERCENTRANK.EXC function in R?
Jun 24, 2026
r
excel
excel-formula
Is there a way to count the number of characters per word for a string, returning values separated by a comma?
Jun 24, 2026
excel
vba
excel-formula
word-count
charactercount
Use excel to generate table assignments for each person
Jun 23, 2026
excel
excel-formula
Building Sorting/Ranking into an Index Match Array formula?
Jun 22, 2026
excel
excel-formula
Using DateTime when referencing a cell with SUMIFS()
Jun 22, 2026
excel
excel-formula
excel-2010
excel-2007
Strip trailing slashes from a string in Excel
Jun 22, 2026
excel
string
excel-formula
Filter a table to remove duplicates from one column only, bottom to top
Jun 22, 2026
excel
excel-formula
Excel - Date Range includes given time of day (a better approach)
Jun 18, 2026
excel
datetime
excel-formula
Check file existence with formula in excel
Jun 19, 2026
excel
excel-formula
A function Excel which sends back the date of Monday of the next week
Jun 19, 2026
vba
excel
excel-formula
Excel function to transpose every nth row into columns
Jun 18, 2026
excel
excel-formula
transpose
offset
How to do the 1,1,2,1,2,3,1,2,3,4... pattern?
Jun 17, 2026
google-sheets
excel-formula
in EXCEL every number in column A is part of or equal to a number in column B , How find full number from column B Base on numbers in column A?
Jun 18, 2026
excel
excel-formula
Older Entries »