Excelling With Excel: Finding Missing Numbers In A List Of Numbers And Other Excel Tips
A co-worker (Betty) and I stumbled into this tip recently. We assign volunteers a number so they can log into VolunteerWorks and track their hours. We currently have over 1500 active volunteers. Imagine the number of persons that are inactive, prospects and applicants. We try to keep the number four digits in length and try to reuse inactive numbers. So we needed a way to sort through a list of active numbers and identify what numbers were missing. With over 1500 names, looking through the list and pulling each number out individually was a daunting task. This tip would not have happened if my co-worker and I had not collaborated. We each had a piece to the puzzle and a bit of blind luck to get the results we needed. Why it works is something neither of us can fully explain. But hey, you go with what works sometimes, eh? Start by opening Microsoft Excel, then follow the steps below.
Tip: One way to enter a complete range of numbers in Excel is to enter the first three numbers, highlight them together with the cursor and then grab the little square dot in the lower right corner and drag it down until you have all the numbers you need. This is an Autofill feature.
Tip: Normally the COUNTIF formula looks through a range of numbers and counts how many times it appears and gives you a total. So if we had = COUNTIF(A$1:A$5,3) Excel would look through column A and count how many times the number 3 appears. In our case - only once. So we would get the number 1 in column C where we entered the formula. If there were no number 3 we would get a 0 and if there were two 3s we would get 2.
If you take the time to learn all the steps to do this, you will truly be "Excel"ing.
QUICK TIP: Adusting the View on Your Monitor
Todays Monitors usually have a few buttons on them to adjust the view on your monitor. One of the most reoccurring problems when you get a new computer is being able to whats on the screen. (This is actually two tips in one.)
In MS Windows Choose: Start > Settings > Control Panel.
Next, find and click on the Display icon and click on the Settings tab. Adjust the Screen Resolution downward. Less Resolution. This usually makes the window appear bigger.
Next (here's the second tip), if you have black areas near the edges of your monitor you need to adjust the screen. Read your monitors manual or if daring, play around with the buttons on the front of the monitor. These buttons usually include icons that show a monitor stretching horizontally or vertically and showing the window moving left or right and up and down. These are the buttons that will make the window fit the screen.
Do you know of a better way? Or do you have any questions?
Drop me a note at Michael@MichaelStills.com.
Return to Top
A Service of MBA
Publishing-A subsidiary of Macduff/Bunt Associates All materials copyright