Soluții

How to Count Unique Values in Microsoft Excel

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...]

How to Create a Custom Date or Time Format in Google Sheets

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...]

Fix Corrupt Registry for windows 10, 8 & 7

The severe corruption in the Windows registry can turn the PC/laptop into a brick.  And as a Windows user, you should know that minor damage in a registry entry can destroy the Windows 10, 8, 7 OS completely.

An issue on the registry means an issue on your operating system, and consequently, you will start facing various difficulties in using the device. Most of the time, when the registry gets damaged or corrupted, the Windows system needs to reinstalled and you lose your entire data.

[mai mult...]