Excel Tip - Use VLOOKUP to Return Multiple Values Horizontally

I have been asked this questions a number of time about Excel and VLOOKUP formulas. How to return multiple values from one VLOOKUP.

Let's say we have customers who have more than one piece of equipment, but we want to return the serial numbers of all those pieces of equipment using the VLOOKUP formula. Normally customers have one item that we want to match, so a normal VLOOKUP fits our needs but some have more than one. We need to do a bit more with our VLOOKUP and turn up the volumes on this formula.

So, let's do this with some data... here is a list of customers and their equipment (a very small extract of our data set).

Customer Number Equipment Type Serial Number

776546 Baffle 1432

776546 Stoker 1552                     

776546 Plank 1749

776324 Plank 1500

764632 Baffle 1683

763452 Baffle 1815

763543 Stoker 1263

OK, so looking up the multiple types or serial numbers is really easy in this example with such a small data set, but what about if we have thousands of records, that would be pretty tough. Let's get Excel to do the tough work, and write a formula for get this job done.

{=INDEX($A$2:$C$8,SMALL(IF($A$2:$A$8=$E$2,ROW($A$2:$A$8)-1),COLUMNS($F2:F2)),3)}

Firstly this is an array formula. An Array formula is a formula that will perform multiple calculations on one or more sets of values). The INDEX function looks in our table ($A$2:$C$8)

It then uses the SMALL function to find which row to look in and then subtracts 1 from what SMALL tells us. ( it takes the smallest row number first and matches the value in Column C)

The ROW function returns the row in the worksheet where our value was found.

The INDEX function considers the first row of our table as row 1. Because our table data starts in row 2, we need to subtract 1 from the ROW value to get the correct row inside the table.

In your own spreadsheet you may need to adjust this value to take account of where your data table is located

The INDEX function then looks in column 3, which is where the data is found.

As we drag the formula along the columns, the next instance of the row number I.e 2 in F3 and 3 in G3 and so on until there are no more matches and we get an error. Job done.

BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com a site that shares Excel tips and tricks with it's enthusiastic members. To join in the discussion, where users are working smarter and faster with Excel sign up for the FREE newsletter and as a bonus receive a FREE EBook- 50 Top Tips and Tricks.

Article Source: http://EzineArticles.com/expert/BJ_Johnston/850729

Article Source: http://EzineArticles.com/9075152

Outlook - Easy and Efficient

Outlook is an e-mail service which was created by Microsoft for personal and office use. Apart from e-mail, it also includes text messaging, calendar, contacts, etc. In this internet era, everybody is dependent on it for almost everything. Outlook is also one such creation that enables people to connect and even work through e-mails. It's an efficient way of communicating and spreading the word to others as well. It can also be expanded with Smartphones which allow users to view their mails- everywhere around the world.

Every user has a different need and chooses an e-mail service accordingly. But when most businesses are involved, Microsoft is the winner. Microsoft is a household name and hence very popular and reliable. Microsoft tries to improve features of Outlook with release of every new version. They do not disappoint ever. Outlook makes e-mail management easier and syncs Outlook e-mail to your phone. Using Outlook is simple, and it provides security to your data as well. For using Outlook mail, all one needs is to create an Outlook account and log in to the Outlook Mail Login Page. Thus, the Outlook mail is at your disposal with just one login.

Outlook Tricks and Tips For Increased Productivity

• Create folders for Common Searches: One can create a common search folder in Outlook. If there are searches that you frequently search, those can be put under 'Search Folder'. Go to the Folder tab, then to new search folder in order to create one. This new folder will be on the left side of your Outlook window. Give it a name by right clicking on it. Creating a folder for common searches will save time.

• Ignore unwanted e-mails: If someone is sending you e-mails constantly and you do not want them clogging your inbox, you can block them by clicking on the junk drop down on the home tab. There you can block that person and also ignore them if you do not want to permanently out them. This will ensure security of your account.

• Save as Quick Parts: If there are some words that you use on a constant basis, you can save them as 'Quick Parts' so that they can easily be used while writing e-mails. Highlight the word under the compose window, then switch to the Insert tab, click on the Quick Parts drop down and select 'Save selection to Quick Parts gallery'. Whenever you start writing that word,suggestions will pop up.

• Use SkyDrive for attachments: Whenever you are attaching something with your e-mail, and the size of that attachment is bigger, then it will be uploaded to SkyDrive, and you can send the link to the recipient. This will make it easy to send larger files with no problem of space. It can be sent to multiple people as well.

Microsoft Outlook has all the important features and is a better and secure platform for different organizations. It also provides additional services to its users other than just e-mailing. So what are you waiting for, go and perform an Outlook Mail Login in order to experience the best mail service available.

Signin-Email.com - Get all email and social accounts login page at one place. Now check your email account via new way. For more details, Visit at http://www.signin-email.com

Article Source: http://EzineArticles.com/expert/Alex_Sam_Smith/2269899

Article Source: http://EzineArticles.com/9369516

Best Cloud Storage Devices Of 2016

distributed storage permits you to get to your essential records, archives, pictures and recordings at whatever time and anyplace furthermore keeps your information safe from any security risk or from information misfortunes. To secure your computerized data and information, distributed storage offers free online stockpiling from where you can without much of a stretch share and keep the reinforcement of your own information documents.

Distributed storage offers an extremely basic answer for email connections in which you can join an envelope or a document connection and give access level to it as opposed to appending the records independently in an email. With the assistance of distributed storage you can share your work, view it, alter it and transfer and download the documents.

With every passing day, distributed storage is turning out to be exceptionally well known and is considered as a standout amongst the most dependable and secure strategies for putting away your computerized information with a great deal of sharing and different components.

There are numerous elements which the clients aren't at present mindful of, so here we have scribbled down a rundown of three best distributed storage gadgets.

Google Drive

Google drive is the most utilized distributed storage gadgets; it gives a lot of storage room for putting away all your vital computerized information. At first, it offers 15GB free yet in the event that you utilize more than 15 GB then you need to pay additional. This distributed storage administrations has a greatly straightforward and easy to understand interface, you can move and customize the records specifically from the individual envelope. Introducing Google drive on your MAC, tablet or PC will permit you to effectively match up your documents in My Drive Folder. Anything you alter, include or uproot and adjust will likewise reflect in your Google drive account. You can without much of a stretch change the settings of the drive as in with whom you can share furthermore alter the level of their entrance.

Dropbox

After Google Drive, Dropbox is the second biggest distributed storage administration suppliers and it likewise offers incredible components. There are unlimited elements that distributed storage can give, however not every one of the administrations can give that yet Dropbox offers a ton of astounding components. Dropbox offers 2GB free space which can be expanded up to 16 GB with their referral program. Dropbox works splendidly on every one of the stages like: Android, Blackberry, MAC, Windows, iPhone and Linux so it gives you a chance to get to your records on every one of the gadgets at whatever time and anyplace.

The auto sync highlight is impeccable as it makes the entire framework one drive whether you have a web association or not, you can without much of a stretch get to the documents in light of the fact that Dropbox just overhauls changes made to the records as opposed to the entire thing. Sharing and welcoming is a typical component in all the distributed storage administrations, likewise, Dropbox additionally gives you a chance to welcome and add individuals to your drive and share interface or make visible displays. Another fascinating component is that inadvertently on the off chance that you erase any document or organizer then you can restore back your information inside of a month as dropbox keeps one month's history of your records.

Microsoft OneDrive

OneDrive or SkyDrive likewise offers you stunning storage room when you information exchange they give you 7GB free stockpiling and you get additional 8GB free space in the event that you initiate your camera move reinforcement to consequently store your pictures to the OneDrive, and on the off chance that you allude OneDrive to somebody then you get 5GB extra space, so when you whole it all altogether you get 20GB free space for your record, documents, recordings, photographs and so forth. OneDrive is accessible on every one of the gadgets and naturally adjust every one of your documents to your OneDrive or SkyDrive Account. You can likewise work, alter, save your records in OneDrive from Microsoft Office 2013 applications and on the off chance that you haven't introduced Office 2013 you can in any case use logged off capacity drive in your program.

These were the main three distributed storage benefits that offer stunning online stockpiling with no pay-ups, notwithstanding, there are more which are less known. Do let us know about which distributed storage choice you are utilizing underneath as a part of the remark segment.

Adams Smith Thompson is a technology adviser. Buy an assortment of inexpensive products for your business and organised your workplace. Buy IT products from http://www.Westenditstore.com at reasonable prices.

Article Source: http://EzineArticles.com/expert/Adams_Smith_Thompson/2139616

Article Source: http://EzineArticles.com/9375303

Direct X12 - Advantages and Disadvantages

PC gamers have been looking forward to the launch of Microsoft Direct X12, an application programming interface that plays the important role of connecting the operating system and software with the graphics hardware. This version is widely believed to be an improvement over the ones that preceded it; even so, it is important to find out more about this new API, considering that there are quite a few good ones in the marketplace offered by rival companies.

The advantages of Microsoft Direct X12 are numerous and immediately apparent to the user. For one, this API offers far improved performance than before. It produces highly detailed images at 1080p resolution with far more triangles than before on the GPU. Various algorithms used to create visuals are made highly efficient. As a result, the scenes that are created are very rich and attractive. It also offers multi-platform support. While lots of gamers still prefer to use PCs, there is increasing preference to use smartphones and tablets to play video games. This has been quite a problem until now but Microsoft's new graphics API seeks to address the issue of portability.

Another big advantage of this new API is that CPU load can be reduced drastically since applications will be permitted to have access to hardware at lower levels than before. While this varies according to the particulars of each device, the power consumed by the system can even come down by a whopping 50 per cent whilst ensuring that complex and detailed images appear on the screen. Video game developers are expected to make good use of Microsoft's new API since they will now have the ability to use the CPU to its greatest ability.

It has to be admitted that Microsoft DirectX 12 also has a few disadvantages. Graphics cards designed to use other APIs, DirectX 11 for instance, will not be able to function efficiently and the system can get heated up tremendously. Another disadvantage is that while it creates a high resolution image there are quite a few problems with visual fidelity; spaces between lines are not filled in properly and so there will be problems with the image. In fact, the push to 1080p can result in images that are not as clean as expected. Potential users of DirectX 12 have to weigh all of its advantages and disadvantages before making the final decision of spending money on it.

Microsoft will be launching Direct X12 [http://directx12download.com] targeted towards video games developers. Click here to read about its advantages and disadvantages.

Article Source: http://EzineArticles.com/expert/Rizvana_Manzoor/1397216

Article Source: http://EzineArticles.com/8759663

2 Ways Of Uninstalling DirectX 11

DirectX 11 is designed for Windows 7; however, other versions such as Windows XP and Vista can also install it. In some situations errors happen and you have to uninstall the program. There are two main ways in which you can uninstall the program: from the control panel, and Using a Windows registry editor and Installer cleanup.

From the control panel

You should note that it's impossible to uninstall the program from Windows 7 as its present by default. While this is the case, you can easily uninstall the program if you had installed it on Windows XP or Vista. It's possible to remove it because it will be displayed in the list of installed programs.

To remove the program you need to close all running programs. You should then click start and go to the control panel and click "add or remove programs." You should then select "Directx 11" from the list.

You should then choose "change/remove" or "uninstall" and click yes on the button in the dialogue box. To save the changes you should restart your computer.

Using a Windows registry editor and Installer cleanup

The Windows Installer Cleanup is a tool that is provided by Microsoft in order to remove registry entries of all installed programs. The tool is necessary when Directx 11 is installed on a system that doesn't remove the default version.

To remove the program you should close all the running programs, click on start and click on all programs. You should then click on "Windows Install Clean up" and from the list that comes up choose "DirectX 11". You should then click on "remove" and close the Windows Installer Cleanup.

After doing this you should click on "start" and then "run". You should then type "regedit" into the search box and press "Enter." Doing this results to opening of the Registry Editor.

Once the registry opens you should click the arrow that is placed next to "HKEY_LOCAL_MACHINE." When you click on it a list of folders will appear. You should then click on the arrow next to the software folder and a new list of folders will appear.

You should click the arrow next to the Microsoft folder and again a new list of folders will appear. You should choose "DirectX" folder and select "Delete."

You should close "regedit" and then restart your computer.

Conclusion

These are some of the ways of uninstalling DirectX 11. While the process helps you in getting rid of errors, you should avoid overdoing it as it brings about reduced system performance.

Directx 11 is a great program to have in your computer especially if you are gaming enthusiast. To undertake Directx 11 download you only need to visit out website and you will download the program effortlessly.

Article Source: http://EzineArticles.com/expert/Duncan_Lancer/1848978

Article Source: http://EzineArticles.com/8767358

7 Methods to Access the Windows Task Manager

Sometimes, knowing the usual option to access the Windows Task Manager (WTM) is not enough. What if the explorer is not responding? You cannot possibly stop the explorer when you cannot access the WTM through it. As such, here are some ways on how you can run this tool in Windows.

1. Through the taskbar

This is the most popular way on how you can open the WTM. To do this, you simply right click on the taskbar. After that, select Start Task Manager. This will open the WTM dialog box. Note, however, that you should do this preferably on the right side of the taskbar, like in the system tray or in an empty taskbar field. It might not work if you go to the left side; the Start button is there as well as the pinned program icons.

2. Through the Windows Explorer

If the taskbar lets you access the WTM by only two clicks, in this method it will take you longer than that. First, you go to My Computer by clicking the Start button and then selecting My Computer. Afterwards, open your local disk (Drive C) then go to the Windows folder. Find the System32 subfolder. You should be able to see the taskmgr.exe in it. Unless you have no other option to get to the WTM, then only then should you use this method. Given that it makes you exert more effort to get to the program, this process isn't efficient at all if you're going to access this tool on a daily basis.

3. Through the Run application

Using the Run command will enable you to access different locations not only in your computer, but also in shared networks. Also, it can open a specific program given that you put its location in the field.

To open Run, click the Start button then proceed to All Programs. In the Accessories folder, click Run. This will open the Run command dialog box. In the Open field, type "taskmgr.exe" then click OK.

You can also access the Run command via the Search programs and files. To do that, click the Start button. In the Search programs and files field, type Run. The application will populate in the Programs section. Click on the Run icon to open it.

4. Through creating a Shortcut

Perhaps an easy way to access the WTM is to create a direct link to the tool in your desktop. To create a shortcut, you have to right-click an empty spot in your desktop. Go to New, and then click Shortcut. This will open the Create Shortcut dialog box. Type its location in the field, which is the following path:

C:\Windows\System32\taskmgr.exe.

After that, click Next to continue. Enter Task Manager as the name of the shortcut, then press Finish. Afterwards, the shortcut will be placed on your desktop.

5. Through CTRL + ALT + DEL

If a specific application is not responding, most computer users will press the CTRL + ALT + DEL buttons. This will take them directly to the WTM screen. However, this is only applicable for the Windows XP Professional x64 and in lower versions. For Windows Vista, this keystroke will take you to the Windows log-on screen. Among the choices in the log-on screen are Lock this computer, Switch user, and Logoff. There is also a Select Start Task Manager option in that menu.

6. Through CTRL + SHIFT + ESC

Another three-button keystroke can take you to the WTM. This is the CTRL + SHIFT + ESC. However, compared to the CTRL + ALT + DEL, this keystroke is much harder to do because of the location of its buttons in the keyboard. Nevertheless, you can also use the CTRL + SHIFT + ESC while on Remote Desktop Connection, as it will open the WTM on the desktop you are accessing and not the desktop on your computer.

7. Through CTRL + SHIFT + END

If you're on Remote Desktop Connection and you clicked CTRL + ALT + DEL, it will not bring up the task manager of the remote desktop. Therefore, you can try other keystrokes such as the one previously mentioned. Aside from that, you can also try CTRL + SHIFT + END. However, if you use this on a normal desktop and not a remote one, it won't do anything.

And that's it - the seven possible ways on how you can access the Windows task manager. Through learning these tips, you can now determine which among these methods is the most efficient for you.

If you are looking for a free registry cleaner to restore missing corrupted files, you can download for free on http://www.dlltool.com/

Article Source: http://EzineArticles.com/expert/Pete_F_Morgan/1946400

Article Source: http://EzineArticles.com/8782943

Six Useful Tips in Cleaning Your Hard Drive and Freeing Some Space

Typically, the Windows Task Manager is often used to end unresponsive applications in your program. It is very easy to do especially for a computer novice. You just right click your taskbar and select the Start in the Task Manager Button to open the tool. In the Processes tab, you highlight the application then press End Process to kill it.

1. It lets you see which applications consume your CPU and RAM.

Upon opening the WTM, go to the Processes tab. It will list all the running programs in your computer. If you click on the Memory (Private Working Set) heading, then it will arrange the programs based on its "CPU" and "RAM" usage. You can also see how much memory is used by each application, which is expressed in kilobytes.

2. It shows your actual usage of CPU and RAM.

In the Performance tab, you will see graphs that depict your CPU and RAM usage. In the left side, the bar graph will show how much of the memory is used in real-time. Beside it are the history graphs for CPU and Physical memory usage. It will show you the usage spikes over a specific time frame.

3. It lists all the programs that frequently read and write in your hard drive.

The Resource Monitor keeps a record of the disk activity of each program. The disk activity is measured by bytes per second. In the right side, there is also a graphical representation of the total disk activity. Through this, you can see if your hard disk is being utilized at a maximum rate. What is the implication of these data? If you are going to use a disk-intensive program, then you might want to close the other applications listed in the Disk tab.

4. It gauges how long you have been using a program.

Are you interested to know how long have you been on your computer? If yes, follow these instructions. At the top of the WTM, go to View then click Select Columns. Check the CPU time, and click OK. In the Processes tab, you will see the time elapsed for each running application.

5. It enables you to stop background programs from running.

There are times when even though you have closed an application, it continues to hog your CPU memory. What happens is that this program is running on the background. To completely stop the application, go to the Processes tab. Next, select the background program and click End Process.

6. It lets you send a message to another user.

The Users tab will list all the users who are simultaneously logged in your computer, either through a remote desktop connection or through local sessions. To send a message to another user, simply click his username in the Users tab then click Send message. A dialog box will pop up; you can enter the message title and your message in the fields provided. Lastly, click OK to send your message.

7. It can arrange your program windows.

If you right click the taskbar, you can choose a windows arrangement option such as Show Windows stacked, Cascade windows, and Show windows side by side. The task manager lets you do this too. In the Applications tab, hold CTRL as you click each program that you want to be arranged. Afterwards, you right click on the selection for the options. You can either choose Cascade, Tile Horizontally or Tile Vertically.

8. It monitors your network activity.

Does a webpage takes too long to load? You may consult the task manager for some ideas. The Networking tab will show you the internet usage of each adapter on a percentage basis. If you see high spikes in the graphs, some applications may be consuming too much of your internet connection, which in turn causes your web pages to load slowly.

9. It tells you which applications use your internet connection.

Assuming that in our scenario above, you want to prioritize internet browsing over the other programs. Thus, you need to stop some irrelevant programs from running; but how will you know which programs to stop? To do this, go to the Performance tab then click Resource Monitor. In the Network tab, it will show the applications that are using your network connection.

Indeed, the Windows Task Manager is an indispensable application. These functions make it a great productivity tool for every computer user, so better share this knowledge among your friends and colleagues.

If you are looking for a dll fixer to restore missing corrupted files, you can download for free on http://www.dlltool.com/

Article Source: http://EzineArticles.com/expert/Pete_F_Morgan/1946400

Article Source: http://EzineArticles.com/8784692