# Category: Excel Formula

## 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 Calculate the 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 will need to use the LARGE function. When there …

## 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 …

## How to Convert Weekday to a Number

Sometimes you need to convert weekdays and weekends into number. Weekdays in Excel can be a date, also can be a text string. 1. When Weekdays are Dates (Please …