Thursday, June 27, 2013

Excel formula to get percentage for the last value in column Excel 2007

Recently I was working on an excel sheet that needed to compare the current value to the start value.  The list is updated monthly so the column is constantly expanding.  After some searching I came up with the following formula:
=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))/A#

Replace the red letter A's with the column you are working with.
Example, if the data is in column E, the formula would look like this:
=INDEX(E:E,MATCH(9.99999999999999E+307,E:E))

Replace the green A# with the static reference cell.

The way I had this setup was to have the original data along with the % up at the top of my page, the cells below would have the running data.

this creates a dynamic formula that can replace:
= (cell1) / (cell2).

Wednesday, June 26, 2013

How do I get Contacts at the bottom of the Task window in outlook you ask?

Its quite simple actually.
These directions are using Outlook 2007
Tools>Options>Preferences Tab>Contact Options>Contact Linking>put a check in Show Contact Linking on all Forms

Boom
You now have Contacts on the bottom of the Task window.  I had a user request this, otherwise I would never have known this was something you can do, or would want to do, in Outlook.

Monday, June 17, 2013

Forwarding user mail Exchange 2003

First, be connected to the exchange server.
Go into Active Directory Users and Computers
Locate user (right click domain>find)
Right click user>properties
Exchange General tab
Select the Delivery Options button
under Forwarding address, select Forward to: and click modify
type in the name the emails should go to and click Check Names
Ok out and you're all done.
You also have the option to Deliver messages to both forwarding address and mailbox, if you want both people to receive the emails, select this option.
You have now forwarded emails from the located user to the selected user.

boom goes the dynamite

Friday, June 14, 2013

Dell Server, F1 to continue F2 to enter setup utility

System: PowerEdge700
Problem: Beeps really loud and says F1 to continue, F2 to enter setup with no reason why.

F1 will go straight to windows no problem.  Every reboot I get this beep and F1...F2...
After some searching I found out it was because I moved the drives from the onboard SATA to a PCI card so I could add more drives in the server.
I simply had to disable the onboard port I was not longer using.  The server was originally using 2 drives, in both the onboard SATA ports.  This could have saved me a ton of reboot headaches if I found it out sooner, that BEEP is really loud...

Oh, so to disable the port, hit F2 to get into the setup menu, then arrow down to the Sata Port you're no longer using, hit the Space bar to change it, then Space again to turn it off, then Esc out.

Getting RTL8812au passed to Virtualbox VM (Ubuntu)

There are no guarantees, I just write these notes so I can come back to them. First, get the dongle working on the host OS. After going thro...