How to Change Excel/Word/Outlook from Black into White
After restarting my computer today, all my Microsoft products turned black. I have been using the light background all the time and do not feel comfortable with this black …
Category: Excel Formulas
How to Calculate the Third Largest Value with Duplicates
You can calculate the maximum value with the Max function, but to calculate the second or third largest values, you will need to use the LARGE function. When there …
How to Count Second Largest Value with Duplicates
You can calculate the maximum value with the Max function, but to calculate the second or third largest values, you need to use the LARGE function. If your data …
How to Convert Number of Days to Weeks
If you have the number of days and wonder how many weeks that equal to, you can use the following formula: =INT(A2/7)&" weeks" & " and " & (A2-INT(A2/7)*7) …
How to Extract Text before at sign for Email Address
To extract the text before the at sign (@), you need to find the location of the special character of the at sign (@) and then use the Left …
How to Convert Scientific Notation to x10 Format in Excel
When the numbers in Excel are too large or too small, you may need to convert them into scientific format. However, the default scientific format in Excel is not …