Who Gets the Lowest and Highest Values with Excel
Find out how to easily locate lowest highest values using Excel's MIN and MAX functions. Get insights on working times!
INDEX
VLOOKUP Left Lookup Using INDEX or XLOOKUP
Explore advanced Excel techniques to overcome VLOOKUP limitations and retrieve data from the left with XLOOKUP or INDEX/MATCH.
Transform List to Matrix like Distance Table 🚗
How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article
Dynamic SUM in Excel
Discover two powerful techniques for creating dynamic sums in Excel: Excel Tables and the SUM function with INDEX.
How to use the INDEX function in Excel?
Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
Create a Lookup Offset
When you have many times the same ID in your table, the following formula will help you to create a lookup offset.
Categories
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (25)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (20)
- Lookup functions (14)
- Manage data (20)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (24)
- Text functions (17)
- Tips and Tricks (21)
