Personal Web Hosting UK Personal Hosting, cPanel Web Hosting, Personal Website Hosting, Cheap Personal Hosting

Starting October with a hint for Microsoft Office, Excel.

Excel is the spreadsheet calculation package Microsoft Office, Considered the best there is in the market by many specialists in the subject. I personally do not use, and when I need to use a spreadsheet opt to at Google Docs, always free and functional. But there are situations in the office, day-to-day work that you can not access the Internet and the way is to turn it with Excel.

Today a co-worker asked me how could I identify and remove duplicate records in Microsoft Excel. Of course it was a short list, you could even look at her and put an X in the column that represents the duplicate filter and then to remove, but we are talking here of a list of more than ten thousand records.

How to Identify and Remove Duplicate Records in Excel

Let’s use the function COUNTIF.

Imagine we have a list of names with cell phones and want to know who has two phones.

In column C, put the formula = COUNTIF (A2: A6, A2)> 1

we count the cell A2 to A6, differing only by A2, who has more than one returns True (true).

Copy to the end of the list (or drag down to cell C2) to process all records.

Once you do a column C will have only true or false (true or false), and you can use the filter to display only those with true value, which represents people who have a listing in our two cell phone numbers.

This same reasoning with the COUNTIF function can be used for other values and records, simply expand the selection of records.

Posted under General

A computer system called server provides services to a network computers, they store several files in your database. Number of computers accessing the server are called clients.

Dedicated Servers are computers that are leased by a customers to host their websites. These servers have their own characteristics for each type of accommodation, they are projected to stay connected round the clock in order to provide data at all times.

They serve mostly to provide space and accommodation so that clients can access the files and show the end user of these files.

There are several types of servers classified as uk dedicated servers and NOT DEDICATED, some of them are: Fax Server, File Server, Web Server, Email Server, Print Server, Database Server, DNS Server, Proxy Server, FTP Server, Webmail Server, server virtualization and servers for games.

Currently there are two types of dedicated servers, managed and unmanaged. An unmanaged dedicated server is the server type in which the customer will have to completely manage the server, performing tasks for software updates, application patches, system restore, manage security and software installation. In this case the web hosting company is completely responsible for providing connectivity and repair of any hardware problems. The option of an unmanaged dedicated server is recommended for users with more experience in managing machines.

Managed dedicated servers possess as care taken by the web hosting provider. The contract for a managed server, the company takes the responsibility to maintain the updated software, apply patches, accounts for the smooth operation and security of hardware, monitor the external Internet network connectivity. One option recommended for users without experience in server management, or lack of time for more complex task.

The advantage of opting for a dedicated hosting is that performance is larger for being a dedicated machine just for hosting services, it has everything that makes the site have a connection speed broadband internet access, and security updates when necessary.

Posted under UK Dedicated Servers