## Identify duplicates in different locations and sheets

We manufacture parts where I work, and to manufacture a part it needs to go through different work centers, and also need to go out for heat treatments or …

We manufacture parts where I work, and to manufacture a part it needs to go through different work centers, and also need to go out for heat treatments or …

I have big data and I want to get the actual price by Egyptian Pound (EGP) And bearing in mind the below points US dollar $ rate till 30-March-2015 # 7.58 EGP. …

To return an absolute value of a number in Excel requires the use of the ABS Function. An absolute value of a number is a the number without its sign, for …

How to convert Roman Number (LIV) to Arabic Number (54) using Execl Formula i.e the reverse of

To count how many cells contain data in Excel you use the COUNTA Function. Using the COUNTA Function will only count the cells that are not empty. The syntax …

To quickly find the largest number in a range of cells you can use Microsoft Excel’s MAX Function that will quickly tell you the minimum number from a …

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

Excel’s SUBTOTAL function can dynamically count records in a list that has AutoFilter activated. It can also show you other information about records within …

What formula would be required to show the total amount, say £175.50, in words, one hundred and seventy five pounds fifty pence? I’m using Excel 2010 …

A very popular, and often used function, VLOOKUP is a fantastic tool in Excel. The VLOOKUP Function in Excel is used to look for user specified data in …

The DATEDIF function in Excel will calculate the difference between two dates, showing you the answer in days, months, or years depending on how you specify it …

what is the reason for using the “–” symbol in a formula such as

The ISERROR Function in Excel allows to test for error messages that may result from a formula. The error messages covered include; #N/A, #VALUE!, #REF!, …

Microsoft Excel has a built in ROMAN Function that will convert arabic numbers to their Roman Numeral equivalents. The output is text based and not number …

Using Microsoft Excel’s HYPERLINK function allows you to link to other worksheets, workbooks, and websites. The format for the HYPERLINK function is as …

Using Microsoft Excel’s INFO Function we can quickly find out what operating system your PC is using. The INFO Function returns information about the …

Microsoft Excel’s WEEKNUM Function returns a number that indicates where that particular week falls numerically within a year. The format for this …

Excel has a built in function that allows you to link to other worksheets, workbooks, websites and for this example also send an email by clicking on a link. …

It is very easy to get Excel to pick a name at random from a list of names. This is great for running competitions!! To randomly select a name simply type the …

A great function in excel is to randomly generate a number. You may think it would require some programming in VBA but it really doesn’t. Generating …

If you have a list of say people with different scores, or perhaps even commission amounts, you can use the RANK function in Excel to quickly show who has …

A quick way to get an average from a range of cells, instead of using =AVERAGE function, is to use the auto average button in excel. All you do is click in …

Before Excel 2007 the maximum number of rows per worksheet was 65000! And if you had numbers in just a thousand of those, and needed to a total of all the …

When using Excel, it’s often beneficial to know how many cells that contain data there are in a range. A real easy to work this out is using the COUNT …

Hopefully you have come to this post after reading my previous article about using IF functions in Excel. This is a next step to using IF in Excel. …

The IF Statement in Excel is a good tool, but is quite often little understood by Excel users. The IF statement tests a value and then says whether it is …

The MID function in Excel allows you to extract a set number of characters from the middle of a string. For example you may have in cell A1 …

The LEFT function is excel allows you to extract a set number of characters from the left hand side of a string. For example you may have in cell A1 …

The RIGHT function in excel allows you to extract a set number of characters from the right hand side of a string. For example you may have in cell A1 …

I have worked with data downloads from companies where the date comes out of the database it is in an unsable format for date purposes. Instead of displaying …

The SumProduct feature in Excel is, I think, a fantastic formula that is so often under used. It allows you to multiply corresponding values in your chosen …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.