Category: Formulas
How To Conditionally Concatenate A Range
This formula will conditionally concatenate a range based on a criteria in another range.
Read MoreHow To Solve a Quadratic Equation
These formulas will give the solutions to a quadratic equation.
Read MoreHow To Select A Random Item From A List
This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.
Read MoreHow To Create A Hyperlink To The Current Workbook Folder
This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.
Read MoreHow To Get The Current Workbook Folder Path
This formula will return the folder path where the current workbook is saved.
Read MoreHow To Calculate The Volume Of A Sphere
This formula will calculate the volume of a sphere given its radius.
Read MoreAdvertisement
Categories
Recent Posts

Amazing Power Query Tips and TricksJun 11, 2018  Power Query

Create Grouped Serial Numbers with Power QueryMay 26, 2018  Power Query

Amazing Excel Tips and TricksMay 12, 2018  Tips & Tricks