Posts

Create a random sample in Excel

Select visible cells only in Excel

Extract variable lenght text from Excel cell

Separate first and last name in Excel

Dynamic workbook reference in Excel

Rank a category according its value in Excel

Left Vlookup in Excel

Dynamic Range in Excel

Conditional maximum/minimum with multiple criteria in Excel

Sum only the visible cells in Excel

Dependent Drop Down Lists in Excel

Format numbers in thousands or millions in Excel

Categorize Values in Excel