While the VLOOKUP function is good for finding values in Excel, it has its limitations. With a combination of the INDEX and MATCH functions instead, you can look up values in any location or direction in your spreadsheet.

The INDEX function returns a value based on a location you enter in the formula while MATCH does the reverse and returns a location based on the value you enter. When you combine these functions, you can find any number or text you need.

[mai mult...]

If you’ve downloaded a file through the Chrome browser on your Chromebook (or in Chrome OS), you might not know where it ended up. Luckily, there’s an obvious place to look—and a way to double-check if you’re not sure.

[mai mult...]

You can use the COUNT function and variations to count cells that contain numbers. But what if you want to count only the distinct values in a cell range? We’ll show you two ways to count unique values in Excel. Both methods we’ll explain use a combination of functions and variations of the COUNT function. And because your cell range could include blank cells, we’re including alternative formulas to account for this.

[mai mult...]

Google Drive sometimes displays a “drive.google.com refused to connect” error, which is usually the result of an account permission conflict. You can get around that problem using a few different methods, which we’ll walk you through.

[mai mult...]

If you insert dates or times in your Google Sheet, you aren’t stuck with the default date formats. You can use the word for a month instead of a number or add seconds to the time by creating custom formats.

You might have a spreadsheet you’re presenting and want a more attractive date format using complete words for months or days rather than numbers or abbreviations. Or maybe you include times in your sheet and need it detailed to the millisecond. The custom date and time formats in Google Sheets give you great flexibility.

[mai mult...]

If you’ve forgotten a credit card number while using Safari on your Mac, it’s easy to view credit card information saved by Safari’s AutoFill feature. You can also add, edit, or remove the stored cards.

[mai mult...]

When you need a wireless internet connection on your Windows 11 machine, you’ll probably want to connect to Wi-Fi. Here are two different ways to do it—and how to troubleshoot when things go wrong.

[mai mult...]

You can install Windows 11 on a supported device by downloading and using the ISO file that’s available on Microsoft’s official website. To do this, you’re going to need a flash drive and meet certain requirements.

[mai mult...]

If you’re using Microsoft Excel for statistical data, you may need to find the range for a data set. Here we’ll explain a simple way to calculate range in Excel using formulas.

[mai mult...]

Excel makes it easy to perform basic math operations, which includes division. You can divide numbers in a single cell, from multiple cells, or even entire columns. Since there’s no DIVIDE function in Excel, you’ll need to use a simple formula.

[mai mult...]