px to vmin
To convert pixels (px) to the vmin unit, you need to know the viewport's minimum dimension. The vmin unit is a CSS unit that represents the smaller value between the viewport's width and height. For example, if the viewport is wider than it is tall, then 1vmin will...
How to Use Vlookup Function in Excel With Example
Vlookup function name stands for “vertical lookup” and is a function in Microsoft Excel used to search for specific information in a table or range of cells. It searches for a value in the leftmost column of a table and returns a value in the same row from another...
Excel Shortcut Keys to Speed up Your Work
Navigation Shortcuts CTRL + LEFT/RIGHT/UP/DOWN: Move to the next populated cell CTRL + END: Move to the last populated cell CTRL + HOME: Return to Cell A1 CTRL + G: Go to a specific cell by entering the address CTRL + PAGE DOWN: Go to the next spreadsheet CTRL + PAGE...
Count number of words in cell
Here is a quick solution for counting number of words in given cell. There is picture with example and belov is formula that you can paste into your Sheet, and just change cell that you want to count words. Example for getting number of words in cell A2:...
Number of Saturdays in Month or Given Period
Here are a quick example how to determinate number of Saturdays for month or given period of time with excel formula. First in one cell, in our example it will be A1, put start time for desired period of time, then in second cell, B1 in our example put end of period....
Get Current Workbook Path With Excel Formula
If you have open Workbook and cant remember where it is on your HDD there are excel formula that can help you fast. =CELL("filename") Example:
Generate a set of unique numbers in random order
To generate random numbers in Excel between 1 to 20, where none of the numbers repeat, we can use the excel function RAND(). In cell A1 type formula =RAND() and drag formula to cell A20. You will get a list of random values between 0 and 1. It will change everytime...
Split Text With Excel Formula Into Two Columns
To split text with excel function, you can use combination of four excel function. Here are list of function that we will use: LEFT RIGHT LEN FIND In cell A1 type text "Fuel+Car". So we want to split text "Fuel" in B1 and "Car" in C1. Picture below After in cell B1...
VBA Code to Unlock a Locked Excel Sheet With Password
irst open VBA editor with Alt+F11. Double click on sheet that you want to unlock. Paste code below into editor and run macro. That's it. Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer Dim...
Extract Number in String
Vba function val() have property that help you to extract number from string. Here is code and exampe: Function ExtractAmount(data As String) As Variant Dim s As String s = Split(data, "$")(1) 'part after first dollar...