Excel formula articles
Average
Choose
Combine/Merge/Consolidate/Join
Compare
Concatenate/Join
Conditional Formatting
Count
Date calculations
Duplicates
Extract
Filter function - Excel 365
Filter rows/records
Filtered values
Filterxml
Hyperlink
If cell
Index Match
Logic
Lookups
Match
Max
Min
Numbers in sum
OR logic
Overlapping ranges
Partial match
Records
Sequence
Small
Sort by - Excel 365
Sort values
Sum
Sumifs function
Sumproduct function
Text string manipulation
Time
Unique distinct records
Unique distinct values
Unique records
Unique values
Vlookup
Vlookup and return multiple values
Comments Off on Excel formula articles
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form