Home
Services
Web Development
Mobile App Development
Custom Software Development
SEO & Digital Marketing
Technology Consulting
Technologies
JavaScript
jQuery
ReactJS
Vue.js
Chart.js
Highcharts
ASP.NET
LINQ
SQL Server
VBA
Spring MVC
Flutter
Blog
Hire developers
Get interactive excel-formula coding examples
excel-formula
📝
INDEX MATCH array formula error for table with single row
📝
how to count cells in excel with conditional statement?
📝
I have to cells, A1 and B1, I want to display the value of A1 or B1 when either cell have value entered
📝
Multiple Cells Check Without VBA?
📝
Set Pass/fail based on 10 answers from each of many individuals
📝
Excel formula - How to stack values from 10 or multiple columns into 1 column?
📝
Autoincrement numeric element of a string on copy down
📝
What is the best range of numbers to use for ID number relationships in PowerPivot: 1 to 500,000 or 1,000,000 to 1,500,000?
📝
Trying to sumproduct parts to their final assembly in Excel
📝
Get Excel cell relative reference into a cell
📝
How to Calculate only Srinivas Hdfc Money in Excel
📝
Excel Index + if + indirect
📝
Weekday from date in TEXT formula independent from used language in Excel
📝
SUMPRODUCT: calculating multiple sheets
📝
Using the filling color of cell in conditional formatting rules
📝
Hiding certain columns on an Excel table
📝
Complex Alphabetising in Excel?
📝
How to alternate hue of rows in an Excel (or Google Sheets) spreadsheet where every column is a different color?
📝
Combining data in excel
📝
How to share generic LAMBDA-functions over different projects?
📝
Combine Separate Date and Time Cells to Get the Difference in hh:mm Format (Excel)
📝
Sum of all values in one column considering two others
📝
Excel SUMPRODUCT/COUNTIFS #DIV/0 Error
📝
List of 3rd Wednesdays of each month
📝
Reference a cell as a string within a formula
📝
How to find a row in excel based on multiple criteria
📝
Determining number of surnames using sumifs
📝
How can I change the decimal separator from "." to "," only for a specific cell using Excel?
📝
Is there a way to progressively subtract the quantity of same item on different cells and keep track of it?
📝
Find the higher number between two cells and divide by two
📝
Excel: any formula to calculate percentage growth over time
📝
Date Range Order by Number
📝
Sum a Column if it matches a Criteria in one formula - is it possible?
📝
Lookup distinct MAC addresses in EXCEL and provide minimum timestamp corresponding to MAC address
📝
Microsoft Excel getting element in previous row in the adjacent column
📝
Excel count unique with a condition
📝
Appending two lists in excel
📝
Copying Excel Cell and retaining Line Breaks
📝
Convert a string with a carat to a number (and evaluate)
📝
Return value in cell based on other cells values combination in excel
📝
find earliest date for two different strings in the same column
📝
Remove middle initial only if there is one in excel
📝
Marge multpile column in new one in excel
📝
Excel - IF with 3 Outcomes
📝
Why would sumproduct (used to return a whole number count) return a fraction?
📝
Countif(s) criteria is a range plus a number
📝
Extracting the top 10 maximum values in excel
📝
Excel - Time formula - between
📝
Excel formula to return value of cell in column A based off the relative cell value in column B
📝
Excel IF AND statement returning false when true
📝
The cell contains with Units, date and time, How to arrive only the first date and time
📝
how do I keep a formula in a particular cell when I add rows
📝
Entering conditional formula regarding a persons DOB in Excel
📝
Excel conditional replacement without a custom macro
📝
Not necessarily an IF function, but a condition being met
📝
Change values in formula based on data validation selection
📝
How to average every 7 cells without repeating the same cells
📝
Is there a simple way to sum a row of cells that have leading text?
📝
How To Create A Five-Star Rating System In Excel using Percentage
📝
MS Excel: Fraction of date span within another date span
📝
Round to hour THEN minute on multiple lines
📝
Excel: Calculate a Rolling Average Based on Dynamic Range
📝
Create a search box to list all searched results in excel
📝
Excel - get first record of data set
📝
Excel Nesting if clause to find names and assign a value
📝
excel - nested if condition formatting
📝
VBA to insert in a cell in a column a formula to calculate when multiple IF AND conditions are met
📝
Excel - Sumproduct with subtotal
📝
Adjust project hours based on priority
📝
Summing multiple index match formulas
📝
VLOOKUP not working when referencing cell
📝
Excel sum if meets condition
📝
filter out duplicate records with 0 instance
📝
Ranking with subsets
📝
writing excel formula to compare two sheets
📝
Creating a Column in Excel Based on Percentages
📝
I want to look up a unique number in a table and get row and column name
📝
Leave cell blank if no value or divide function
📝
How to compare 2 cells to another 2 cells in a different sheet in excel?
📝
Multiple conditional percentile
📝
Named range of consistent random numbers
📝
Adding accumulative value in excel based on unique ID
📝
Excel formula to make cell read-only
📝
Extract Top 5 Values for Each Group in a List without VBA
📝
Formula where Number is constant
📝
COUNTIF function using a date range with ">"&TODAY()-N)
📝
Convert dd.mm.yyyy hh:mm to date/time in Excel
📝
Dynamically re-order numbered list in Excel
📝
How to sum a number of rows based on a value in a different cell?
📝
Interpret value from formula as a formula in Excel 2010
📝
Excel: Formulas for converting data among column / row / matrix
📝
Excel Finding Value Based On Criteria
📝
Boolean switch from 1/0 to 0/1
📝
Generate random phone numbers
📝
Excel formula unique list formula not working, if counta = 1
📝
add a formula to a cell without disrupting existing data
📝
Find last non-zero cell's column reference in an UNORDERED range of values
📝
Summing a range of numbers after checking that is greater than a year
📝
Excel 2016 count unique values in a range based on more than one range
📝
Get list of rows with a second non-blank value and the column header for the second non-blank occurrence
📝
Convert date field into text in Excel
📝
Find the position of a related string in a list
📝
Excel Duty List
📝
How to take percentage rank of specific rows on conditional?
📝
Excel formula for calculating difference between two date columns
📝
Sum Only Visible Cells
📝
Excel combine Vlookups
📝
Fill column based on three other columns
📝
Replace Last 2 Digits
📝
List Sheet Names Without Macro or Excel 4 Functions
📝
How to sum two different sheets of excels in third sheet using phpexcel
📝
Hex values in one word in Excel
📝
Excel 2013 Conditional Formatting with AND operator
📝
Multiply a cell by a value only if it's greater than value contained in another cell
📝
How to find the maximum value from a column using another column as criteria in excel
📝
Excel Date Rounding Calculation
📝
Excel: Total Count of Cells Across Multiple Worksheets Formula
📝
Excel Index based on a criteria
📝
excel long nested if
📝
Can you have a formula remove zero values from a calculation?
📝
So I'm trying to stack up some =if(and( functions in excel, I can't seem to find the problem in the formula used, could anyone help me?
📝
Show residual grade in Excel
📝
If statement is giving too many arguments error
📝
Excel Conditional data selection by formula
📝
How to insert new column in excel with value in increasing order?
📝
Excel Formula to skip blank cells
📝
Allow data to fill only as per adjacent comma based cell
📝
How to maintain leading zeroes on binary conversions in Excel
📝
Generate a continous column from column with blanks using formulas only (no VBA)
📝
How to calculate the sum of each day from my excel sheet?
📝
Excel formula to compare two columns with colour and get the data of the column which has Amber colour
📝
Excel: Count Occurences of Value in Rows of a Range
📝
Eliminate Characters In Excel
📝
Using cell value as table array value in VLOOKUP (No Macro)
📝
how to perform text manipulation in excel
📝
AGGREGATE function not ignoring errors when it should
📝
I am trying to make a weekly projection using nested if in Excel
📝
Trying to reference data in variable rows after matching specific cell in excel
📝
Can you select the operator in an if statement from a cell in excel?
📝
Calculation divergence in Python
📝
Split rows into multiple rows based on time duration
📝
Create a button in excel that filters a specific text within a column
📝
compare extracted date with today() in excel
📝
Count subject to three conditions
📝
Excel 2010: Get next months 1st Tuesday from a date generated with VLOOKUP
📝
Count # unique values of column if all values in corresponding values are identical
📝
excel formula lookup with % min variable
📝
Excel Compare values from two tables and copy data
📝
If And Or Statement in Excel
📝
summation (sigma) in Excel