file Archives | Page 43 of 45

Find Max or Min Value Based on Multiple Criteria

Let’s suppose you have an example with a list of people with names, age, and place of residence. What we want to do…

For this lesson, we are going to use the following example. The data don’t have to be highlighted. I did it so we…

Remove the calculated field from a pivot table.

There are at least two ways to convert yyyymmdd to date – a formula and text to columns wizard.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

1	=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

or with only…

In order to clear all filters in VBA, you have to do the following steps: Clear all filters in the active table Click…

Check if a file exists In VBA, you can check whether the file or a directory exists by using the Dir method. Look…

Usually, the #N/A error appears when you deal with lookup functions, such as VLOOKUP, HLOOKUP, LOOKUP, and MATCH. If you encounter this error,…

If you want to return the cell address or cell value by specifying a row and column, you can do it by using…

Dates in Excel are displayed as dates, but in reality, they are numbers formatted in a way that is easily recognizable by people….

Let’s say you have data on the hours you spent on your work in a week. The data is separated into each day,…