How to add automatic row numbers to a list or table
CrispExcel Training & Consulting
Microsoft Excel Training
Subscribe to our YouTube Channel youtube.com/
17/02/2023
How to Add Numbers with Delimiters in Excel
26/01/2023
Yearly Sales Summary With Dynamic Arrays functions in Excel
Yearly Sales Summary With Dynamic Arrays functions in Excel In this video, we are going to get the yearly sales summary using the following functions, UNIQUE, YEAR, DATE and SUMIFS ...
In this video I'll show you four main method you can use to combine cells in Microsoft Excel. You'll learn how to use the Ampersand symbol, CONCANT function, CONCATENATE Function and the new TEXTJOIN Function.
.
UNIQUE RANK IN EXCEL
How to use the Rank function with the CountIF function to return a unique ranking list.
A unique ranking list may be needed when you have duplicate values in the array
https://youtu.be/6sdR2bxuWAk
How to copy values from status Bar
Have you ever wanted to include Text in a Number and yet perform Mathematical Operations on the number? 🤔
Here are the 2 Simple steps
Step 1: Watch the Video Below
Step 2:
1. Select cells to format
2. Press Ctrl + 1 to access the cell formatting
3. Scroll down to the custom format
Paste below format
[=1] 0 "Day"; [>1] 0 "Days";;
Click here to claim your Sponsored Listing.
Location
Category
Contact the school
Website
Address
Mombasa
NAIROBI